I have 3 fields (preferably dimensions) called A,B,C.
I want to create a Bar Chart where by default, A should be the dimension. When user Clicks a button named (A)/B/C, the chart should change it's dimension respectively.
P.S.: I tried the above by creating 3 different Charts with A,B,C as dimensions separately and then set the variable for each button to show the chart using Conditional option under Layout Tab.
I feel, that is not the right way of doing it. Is there any alternative to do this?
User doesn't want Cyclic group instead a button is needed for each dimension.
The simple thing I could try is clone the chart and change the dimension for each chart and put a Conditional Show for all the charts. But is there any alternative to doing this?
Your way is correct create 3 different Bar charts and, create 3 variables, using this variables give the conditions to the button and also use this variable in the chart in the layout tab conditional box using the getfieldselection() function,and whenever required then only show or else hide it.
Please see the attached.
See the trigger set
Ducument Properties->Triggers->Document Event Trigger->On Open
This trigger is set to display default dimension on chart.
Rest all is just set variable condition on button