Pie Chart Grouping

Hi,
I created a pie chart. I want to slice the chartbases on some ranges.

Eg: I want to create a pie chart with 3 slices.
0-25 - 1st slice
25-50 - 2nd slice
50-100 - 3rd slice.

Please let me know how can I do it.

Thanks,
Sekhar.

Find more posts tagged with

Comments

bhanley

I am not sure I understand the goal here. Your Pie Chart would always look the same and therefore not really communicate any meaningful information. Can you describe the user's use case a little more so I can help?

ssekhar

Hi,
Thanks for your reply
Below is my query
select id, short_desc, round(sum(data)/sum(total_data),4) * 100 percentage
from test where id = 'test'
group by id, short_desc

I got 10 rows when I execute this query. It has data in percentage column ranging from 0 to 100.
example data: 5.0, 8.7, 22,44,54,76,33,89,98,99.7

I want to generate a pie chart based on the data. I selected "percentage column" as a value for series1. based on this I am seeing my pie cart getting sliced into 10 parts.
I want my pie chart to be sliced only 3 parts.
the data ranges from 0-25(in the percentage column 5.0,8.7,22 should be grouped into single slice) - 1st slice
25-50 - 2nd slice
50-100 - 3rd slice.

Hope this is clear. Please let me know if you need any information.

Thanks,
Sekhar.

mwilliams

Sekhar,

So, you want the pie slice to be a count of the amount of values in that range? i.e. 0-25 = 3, 25-50 = 1, and 50-100 = 6 in your example above?

ssekhar

Hi Michael,
I want to combine the slices which falls on particular range

0-25 = (usually it is 3 slices)- i want to group 3 into 1 slice - 1st slice

25-50 = 1 - 2nd slice

and 50-100 = (it is 6 slices)- want to group 6 to 1 slice - 3rd slice.

Please let me know if you need additional information.

Thanks in advance for your help.

Thanks,
Sekhar.

mwilliams

Sekhar,

My question was if you wanted to show the sum of the values in the chart or the count of the values in the chart. Either way, it shouldn't matter. If you create a computed column that checks the value and decides whether it's 0-25, 25-50, or 50-100. You can use that as the x-axis category and for the grouping option (click the button with the down arrow next to x-axis category) you can select sum or count, depending on which one you're wanting to do. Let me know if you have any other questions.

ssekhar

Hi Michael,

Thanks for your quick reply. I will try it out in this way.

Thanks,
Sekhar.

mwilliams

K. Let me know if you have any issues.

ssekhar

Thanks Michael. The approach you suggested is working fine.