Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a normal bar chart for which I want to use the same expression regardless of dimensions, however I want the chart to use the dimension(s) that have been selected from a multi box by the user, e.g. one dimension may be margin and the other month initially, but if the user wanted to see profit/month they could select profit from the multi box and the chart would update to show this.
Many thanks,
T
Did you check this?
Adhoc reports are for same feature for what you are looking for..
HI,
Condition enabling will help you on this ,
First add both the dimension in chart and enable them based on condition like
if(GetselectedCount(margin)>0,1,0)
if(getselectedCount(Month)>0,1,0)
If you want to show any dimension by default then disable this condition for that dimension
You can store the select value in a variable and use this variable as dimention. (Adhoc Reportig)