Klipfolio. The KPI Dashboard - Evolved
The KPI Dashboard – Evolved
1-877-233-6149
Contact Us

Displaying all data only at the last drilldown level

Problem:

You want to display all your data only at the last drilldown level.

Solution:

Setting drilldown: x for a column displays it only at level x of your drilldown Klip. In order to display your data at the last level of drilldown, simply specify that level for drilldown.

For example, in a two level drilldown, use drilldown: 2 for the columns you want to display at the last level.

First level:
http://www.klipfolio.com/images/content/cookbook/drilldown2-a.gif
Second level:
http://www.klipfolio.com/images/content/cookbook/drilldown2-b.gif

Here is the source code for the above example Klip:

<?xml version="1.0" encoding="UTF-8" ?>
<klip>
    <identity>
        <title>
            Displaying all data only at the bottom level
        </title>
    </identity>
    <locations>
        <contentsource>
            <![CDATA[
            <item>
                <year>2007</year>
                <month>July</month>
                <week>week 1</week>
                <apples>20</apples>
                <oranges>5</oranges>
                <bananas>100</bananas>
            </item>
            <item>
                <year>2007</year>
                <month>July</month>
                <week>week 2</week>
                <apples>10</apples>
                <oranges>15</oranges>
                <bananas>55</bananas>
            </item>
            
            ]]>
        </contentsource>
       </locations>
       <setup>
           <purge>
               permanent
           </purge>
           <autoremove>
               false
           </autoremove>
           <autodrilldown>
               true
           </autodrilldown>
           <columns truncate="false">
               true
           </columns>
      </setup>
    <style>
        item {
            type: item;
            definition: all;
        }
        
        month {
            type: enum;
            itemcol: 1;
            drilldown: 1;
        }
        week {
            type: enum;
            itemcol: 2;
            drilldown: 2;
        }
        apples {
            type: number;
            itemcol: 4;
            formula: sum;
            drilldown: 2;
        }
        oranges {
            type: number;
            itemcol: 5;
            formula: sum;
            drilldown: 2;
        }
        bananas {
            type: number;
            itemcol: 6;
            formula: sum;
            drilldown: 2;
        }
    </style>
</klip>

Tip: if you do not wish to display the sum of the values, use 'showresult: false' for the desired column(s).

Leave a Comment

To leave a comment, you must sign in or register (it's free).

   
Comment Type:
Title:
Comment: