Set Analysis and Identifier Confusion!

[dinicholls]

Hi All,

I'm experimenting with my charts in my app.

I want to produce a chart that shows the number of calls overall, and then included on the chart the number of calls but by the selected agent.

The problem is, I'm getting really confused as to how to use the set analysis.

In my chart I have my dimension as 'Agent', and my expression as 'Count(DISTINCT([Contact ID]))', giving me the number of calls by agent.

How do I use set analysis, if that's the right tool, so that when an agent is selected, it shows the number of their calls, AND the total count of the rest of the calls as one. So, if using a pie chart, and the agent had called 25 calls, and overall, including the agents calls there were 100 placed, you would see the pie chart with a quarter showing for the agent, 25% of the calls made, and 75% of the pie chart as all the remaining calls made.

Does that make sense?!

Thanks

Di

[awhitfield]

Hi Diane,

an easy way would be to add 'Text in chart' on the presentation tab, with a expression like

='Total Calls ' & Count(Total(ContactID))

Then use CTRL and SHIFT keys to resize and move the text to where it's required.

Example attached

Andy

[dinicholls]

Thanks Andy, but that isn't what I need to see.

I've tried this so far, with no luck!

Count({$<Agent=>}DISTINCT([Contact ID]))

It just brings back everyone, when I just one the selected agent's, and a total for the rest.

Have attached a quick jpeg of what I'm trying to get it to look like.

Di

[mikecrengland]

Hi Diane,

You can fake it a little by messing with the colors. Take a look at my post:

Fortune Cookie BI: Twisting the knife in a useful pie chart

It will show you how to make your pie chart two colors, based on the selection.

mike

[awhitfield · Accepted solution]

Okey Dokey, see what your after now, Check out the new version

[awhitfield]

Excellent! Glad it did the trick!