I have created a bar chart, where
and i have a filterpane in a sheet dimension as client_id.
Now without selecting any client_id from filter pane bar chart is displaying separate bars for all the clients.
Instead i need only 2 bars for above two measures which calculates for all clients.
and when i select any client in filter pane then it should show the values for that client in bars.
How can i achieve this.
Solved! Go to Solution.
If you choose Client_id as a dimension, your bar chart will show measure values per dimension.
If you would like to show the "Total" as requested, you could add a dimension i.e. 'All Clients' (text instead of a field).
You have only one measure but i have 4 bars for one client.
lets take segment A as one client and 3 bars are different counts, So for 7 clients bars are displaying.
Instead 7 groups of bar just 3 bars which gives the total of 7 clients.
and when one single client is selected through filter pane only the counts of that client should show in bars.
Below image is used as example