Charts

[Former Member]

I'm new to crystal charting. I am trying to create a chart that shows percentage of anonymous/total calls by Business Units as well the total percentage in a horizontal bar graph. How do I create a simple chart that show both calucation in one chart?

Edited by: Carla Boyd on Jul 5, 2011 6:51 PM

[Former Member · Accepted solution]

Thanks for your response. I created formulas and placed in the show value and on Change of BU. What I'm seeing is two columns for each business unit. I only want one line per business unit and one for the total.. Any other recommendations?

[Former Member · Accepted solution]

Hi

I don't think we have such options in CR. As a work around you may have to cerate two chards and place one top of other and enable Use transprent background option through chart expart.

Thanks,

Sastry

[Former Member]

This solutiuon sounds complicated, but I'll try.

thanks again!

[Former Member]

Hi

To create this chart, you need to create two formulas to arrive percentages for example

Business unit wise percentage

sum(calls,businessunit)/sum(calls)*100

also create the other formula and insert chart and in on change give Business Unit and in show values you select two formulas.

This will give you the desired chart.

Thanks,

Sastry