Dynamic Spotfire KPI Formula Based on Selected Master KPI

I have a master KPI chart that has a detail KPI chart listening to it. The master KPI chart can have two measures (for simplicity): Eng Displ and Cylinders. The detail KPI chart then responds when the Eng Displ KPI is selected to show Cylinders broken down by business area:

I now want the detail KPI chart to break down Cylinders if it is selected without creating another details visualization (I want it all in the same visualization).

Summary: I want a details visualization to change formulas depending on which part of a master visualization is selected.


Image icon kpi.png13.87 KB

(1) Answer