Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have created a bar chart, where
Dimension: Client_id
Measures:
1 Count(invitation_id)
2. Count(User_signed)
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.
Thanks,
Pramod
Hi Pramod,
Just wanted to find out if this is not working
Dimension: =if(GetSelectedCount(Client_id)=0,'Client ID',Client_id)
you can use KPI object or text object to show the measures. and with filter this will cater your requirement.
Hi Pramod,
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).
can you explain how can i do that
use seperate text object for both measures if yu use client id as dimesion in bar chart it will show for all the clients
Change your dimension like this.
=if(GetSelectedCount(Client_id)=0,'Client ID',Client_id)
and let me know if this is working
Cheers,
Naresh
Hi Pramod,
Do it this way:
Check the QVF for more details
Thanks and Regards,
Sangram Reddy.
Sangram,
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
Hi Pramod,
Just wanted to find out if this is not working
Dimension: =if(GetSelectedCount(Client_id)=0,'Client ID',Client_id)