Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi
You can do this using one chart itself. Just enable condition for each dimension and manage this using a variable.
Try like below example.
easiest way is to create Cyclic Groups from Dimension tab.
Use Edit Groups >> New >> Add A, B and C as Dimensions..
Hi Friend
Try Ad Hoc reporting
Please see attached file , may help you ,
Hi Manish,
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?
Hi,
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.
hi,
use conditional enabling of dimensions.
Regards
$@M
Hi
You can do this using one chart itself. Just enable condition for each dimension and manage this using a variable.
Try like below example.
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
Hi,
another solution could be:
hope this helps
regards
Marco