How can we help?

New post
0

Drill down table with uneven number of items in dataset.

Avatar
Delft.co admin
None
Follow

Klipfolio states that 'All table columns must contain the same number of items and be aligned across rows' for a drill down table to aggregate up. Is there a way around this as I have a data set with an uneven number of items. Seems like a fairly major limitation for a common dataset structure?

I have three levels of drill down and have tried to concatenate the columns using a lookup to match against but this has not worked. I can't think of another way to do it.

Any help would be much appreciated.

Date Votes

1 comment

  • 0
    Avatar
    Claire Jones

    Hi There, 

    Thanks for posting in our community!

    You can try using the PADVALUES function on the column that has fewer values. This function will return the selected values with padding or additional values at the end of the data. 

    For example, this formula adds "None" four times to the end of the Billing column:

    PADVALUES(@Billing, 4, "None")

    And in this example, the difference between the number of values in column B and column C is used as the number of values to pad column C with. 

    PADVALUES (@C:C, COUNTALL(@B:B)-COUNTALL(@C:C))

    Hope this helps and works for you!

    If not, feel free to send us an email at support@klipfolio.com to create a ticket with our support team so we can take a closer look into your specific use case and figure out the best solution for you.

    Thanks, 

    Claire

Please sign in to leave a comment.