Bar Chart

[#1]

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

[vinay_hg]

you can use KPI object or text object to show the measures. and with filter this will cater your requirement.

[kangaroomac]

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).

[#4]

can you explain how can i do that

[gautik92]

use seperate text object for both measures if yu use client id as dimesion in bar chart it will show for all the clients

[NareshGuntur]

Change your dimension like this.

=if(GetSelectedCount(Client_id)=0,'Client ID',Client_id)

and let me know if this is working

Cheers,

Naresh

[reddy-s]

Hi Pramod,

Do it this way:

Check the QVF for more details

Thanks  and Regards,

Sangram Reddy.

[#8]

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

[NareshGuntur · Accepted solution]

Hi Pramod,

Just wanted to find out if this is not working

Dimension:              =if(GetSelectedCount(Client_id)=0,'Client ID',Client_id)