Drill Down dimension with variable

jalanhart — Mon, 11 Mar 2024 23:54:37 GMT

I have a drill down dimension that breaks down data based on a company hierarchy of its divisions.

I want to use a variable that has buttons to view charts based on which view you select on the button. I created a variable called vSALESVIEW and created a variable input visual with buttons, set on dynamic with options ='DIVISION DRILL THROUGH|CONTRACT|PF_CONCAT'

The I set the dimension in the chart to be =[$(vSALESVIEW)], and the measure seems to work correctly when "contract" or "Pf_concat" are selected as those are single dimensions. but the DIVISION DRILL THROUGH is not working. I would like it to work where i can drill through the divisions like I could if it was its own dimension, but when a button is selected.

Is this something that's possible?

Re: Drill Down dimension with variable

LRuCelver — Tue, 12 Mar 2024 07:13:08 GMT

I would just add the drill through dimension as a second dimension and then use the calculation conditions of both dimensions to switch to the drill though whenever your vSALESVIEW variable has the drill through selected.

topic Re: Drill Down dimension with variable in App Development

Drill Down dimension with variable

Re: Drill Down dimension with variable