Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I've created a bar chart and want to keep second alternate dimension static as highlighted in the screenshot below. Only first dimension should give option to select other dimension whereas Channel should be fixed/static (No drop-down/selection icon next to Channel)
Can we achieve this using extensions?
Thanks,
Jaswanth
Let's suppose u have 3 dimensions:
Country , Year and Channel
U want Channel to be static and variate between Country/Year.
here's how I would proceed:
Create an inline table:
Load * Inline [
Dimension,DimensionID
Country, 1
Year,2
];
Now, in ur sheet, add this Dimension field as a filter above ur chart;
as dim 1 : if(DimensionID=2,Year,Country)
as dim2 : Channel
Now, dpends on ur selections on the new field "Dimension" u'll show one of ur 2 actual dimensions (Year and Country)
Hope that was clear