Developer
How-To Articles

Displaying a column in only one drilldown level

Problem:

You want to show a certain column(s) in only one drilldown level

Solution:

Note: This article uses advanced features that are only available in the business version of Klipfolio Dashboard. Add <enterprise>true</enterprise> in your <setup> block in order to try them in Klipfolio Personal Dashboard.

The drilldown property displays a column only in one specified level. By using it in combination with a non-enum type, you can show the column only in the specified level and not others.

Level 1:

Level 2:

To display 'month' and 'apples' in the first drilldown level, we use drilldown: 1. Note that we set 'month' as type: enum because we want to drill down into it; we want to treat 'apples' data as numbers, so its type is number. Similarly, drilldown: 2 is set for 'week' and 'oranges'.

month {
    type: enum;
    itemcol: 1;
    drilldown: 1;
}
week {
    type: enum;
    itemcol: 2;
    drilldown: 2;
}
apples {
    type: number;
    itemcol: 3;
    formula: sum;
    drilldown: 1;
}
oranges {
    type: number;
    itemcol: 4;
    formula: sum;
    drilldown: 2;
}

Here's the entire source code for the above Klip:

<?xml version="1.0" encoding="UTF-8" ?>
<klip>
    <identity>
        <title>
            Displaying a column in only one drilldown level
        </title>
    </identity>
    <locations>
        <contentsource>
            <![CDATA[
            <item>
                <month>July</month>
                <week>week 1</week>
                <apples>20</apples>
                <oranges>5</oranges>
            </item>
            <item>
                <month>July</month>
                <week>week 2</week>
                <apples>10</apples>
                <oranges>15</oranges>
            </item>
            
            ]]>
        </contentsource>
       </locations>
       <setup>
           <autodrilldown>
               true
           </autodrilldown>
        <columns truncate="false">
            true
        </columns>
        <enterprise>
            true
        </enterprise>
      </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: 3;
            formula: sum;
            drilldown: 1;
        }
        oranges {
            type: number;
            itemcol: 4;
            formula: sum;
            drilldown: 2;
        }
 
    </style>
</klip>

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


Comment Type:
Title:
Comment:

Displaying a column in only one drilldown level

Problem:

Solution:

Leave a Comment