Dynamic Charts

[Anonymous]

Hi everyone,

Situation:

I have got a task to create a dashboard. On the sheet there should be a filter of Category, depending on a selection in the Category field, a line chart should show monthly (Dimension) values (Measure) for Sub-Categories in the selected Category as separate lines.

So this considers different number of lines for different category, and I can not include them all by hand because there is a large amount of sub-categories.

Question:

Is there a way to create a dynamic line chart that has a feature of filtering the selected values only?

Thanks!

[lakshmikandh]

Check these

Cyclic Dimension in Sense

[Anonymous]

I downloaded and added the extension, I am able to add the options list, but in the end i only see one single line of filtered values. Instead, i need to see multiple lines as subcategories related to selected category.

Hope this is explanatory.

[lakshmikandh · Accepted solution]

Did you tried Drill down option in Dimensions ?

[Anonymous]

Thanks! It now shows the proper values in the graph. Could you please help get a clear idea on what this drill down dimension does?