Pie Graph Problem

[paulmarr]

Hi everybody,

I am using CRv10 - but can also use CRXI.
I have been requested to create a report with a pie graph that shows a pie section for each of the groups listed in the report (there are 9 different groups in total).

The pie should show each group as equally sized pieces. If the group returns no data - the report should show the pie piece with a specified colour (lets say black) - if the group does have data - any other colour will do. I have managed to show the chart with the different groups - but had to resort to assigning the same value to each group (value = 1) for it to work. I would like to colour highlight the chart using a different value but the chart would not allow a second value.

I have tried almost every approach I can think of without success.

Any anyone come up with a suggestion that will show this breakdown - (I don't mind if the graph is not a pie)? Any ideas (no matter how unusual) would be greatly appreciated.

Cheers
paulmarr

 

[lbass]

I can't think of a way to do this with a pie chart. Have you found a way to return a group even if there is no related data? If this isn't an issue, then you could create a bar chart (advanced layout), and add the groupfield as an "on change of" field. Also create a formula {@sumamt} to test whether there is data and add this as a second on change of group (this assumes that in the main report you have a group on {table.groupfield}:

sum({table.amt},{table.groupfield})

Then use distinctcount of {table.groupfield} as your summary field. This will result in nine bars of the same height. Then to get the conditional color, go to the highlight tab->new->select {@sumamt}, is equal to 0, and select black. That should color the bars with zero amounts black. Not sure if a zero amount is what you mean by no data. You could also create a formula to test for nulls and then a second formula for a summary of the null test per group, and then use this in the highlight tab.

I believe you have to use a type of chart that will allow two series that coincide for the on change of values, so other chart types might work, but not a pie chart.

-LB