Hello Team,
I am using indicators and breakdowns to create dashboards in Platform analytics. The visualizations I am currently using are pivot table.
Lets say I have sales as my indicator and product line, product type as breakdowns. So I have two level hierarchy in rows product line --drill down---> product type. Now I need to show one more level of drill down, which is Product Name..As we know, we only have two levels of drill down. So what i do is create another tab of a dashboard with the same indicator, but this time breakdowns are product type, product name.
So there is a chart interaction feature, which is either data view or url. So i chose url option.
in the url i gave the url of the second tab i created with product type, product name breakdowns.
Now when I click sales values of a product line from first tab it takes me to second tab as expected.
Is there a way I can filter the second tab data with the context or combination of data I select in first tab? Lets say I have 1 Million $ as sales value for product line "camping equipment" and if I click on the 1M sales value, it should take me to second tab and also should only show product type which comes under Product Line.
Is there some kind of on-click behaviour that we can pass as a filter to breakdowns?
Thanks in advance for any suggestions!
