Dynamic Dimension (Vertical) Reference Line

TRusso — Mon, 24 Oct 2022 16:30:26 GMT

Hi All,

I am looking to build a Dimension Dynamic Reference Line in a Pareto Chart. Basically, I would like to choose the bar (let's say by country) where the cumulative Sales (via rangesum(above(...)) hits or 1st exceeds 80%.

Example:

US: 40%

Canada: 30% / 70% Cumul

Peru: 8% / 78% Cumul

Ecuador: 7% / 85% Cumul

So I'd like the dynamic line to be referenced on Ecuador so the user can see the <80% and > 80% rather easily. I can accomplish this somewhat by coloring the bar and/or lines in a combo chart dynamically but am struggling to pick a dimension when a measure goes over 80%.

Hope that makes sense. I don't have a qvf to share as it has sensitive data but hope this is clear enough.

Thank you!

topic Dynamic Dimension (Vertical) Reference Line in App Development

Dynamic Dimension (Vertical) Reference Line