nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Multiple pie chart example needed please

AlbertYu

Hello,

Could anyone please provide me of an example BIRT report that shows multiple pie charts, similar to the attachment?

I am trying to get mine working, but I am stuck on the "Optional Grouping" part.

Thank you in advance,

Albert

Find more posts tagged with

Comments

AlbertYu

Sorry, I didn't click "Attach This file".

Here is the attachment.

Regards,
Albert

lrnrit

<blockquote class='ipsBlockquote' data-author="'AlbertYu'" data-cid="93399" data-time="1325546029" data-date="02 January 2012 - 04:13 PM">
Sorry, I didn't click "Attach This file". 
 
Here is the attachment. 
 
Regards, 
Albert </blockquote>
 
 
Hi , 
 
What are you not getting about Optional grouping, can you be more clear what you want. As attached image shows it seems optional grouping is used in it. 
 
Check Attached RPT design 
 
lrnit

AlbertYu

Thanks for the example. 
 
Yup. I will be more clear: 
 
I am using a data cube with the following set up: 
- Group: Org Name 
- Group: IT Sup Name 
- Summary field (measures): COUNT IT Sup Name 
 
When I set my pie chart element to the following: 
 
Slice Size Definition: data["Summary Field/IT_SUP_NAME"] 
Category Definition: data["IT Sup Name/IT_SUP_NAME"] 
 
it seems to come up with a correct pie chart (but just one). This is shown in "single_pie.jpg". 
 
What I want are multiple pies of ones similar to "single_pie.jpg". 
 
When I try to do this by setting: 
 
Slice Size Definition: data["Summary Field/IT_SUP_NAME"] 
Category Definition: data["IT Sup Name/IT_SUP_NAME"] 
Optional Grouping: data["Org Name/ORG_NAME"] 
 
the pie chart shown in "multiplepie.JPG" is shown. 
 
However, this output isn't correct because the values are all 1. They should be values like [5,6], [10,20], [30,10], etc? not 1s. 
 
Do you know why? What do I need to do or not do in order for the output to be what I want? 
 
Your help is much appreciated. 
 
 
Thank you in advance, 
 
Albert

lrnrit

<blockquote class='ipsBlockquote' data-author="'AlbertYu'" data-cid="93437" data-time="1325631760" data-date="03 January 2012 - 04:02 PM">
Thanks for the example. 
 
Yup. I will be more clear: 
 
I am using a data cube with the following set up: 
- Group: Org Name 
- Group: IT Sup Name 
- Summary field (measures): COUNT IT Sup Name 
 
When I set my pie chart element to the following: 
 
Slice Size Definition: data["Summary Field/IT_SUP_NAME"] 
Category Definition: data["IT Sup Name/IT_SUP_NAME"] 
 
it seems to come up with a correct pie chart (but just one). This is shown in "single_pie.jpg". 
 
What I want are multiple pies of ones similar to "single_pie.jpg". 
 
When I try to do this by setting: 
 
Slice Size Definition: data["Summary Field/IT_SUP_NAME"] 
Category Definition: data["IT Sup Name/IT_SUP_NAME"] 
Optional Grouping: data["Org Name/ORG_NAME"] 
 
the pie chart shown in "multiplepie.JPG" is shown. 
 
However, this output isn't correct because the values are all 1. They should be values like [5,6], [10,20], [30,10], etc? not 1s. 
 
Do you know why? What do I need to do or not do in order for the output to be what I want? 
 
Your help is much appreciated. 
 
 
Thank you in advance, 
 
Albert 
 
 </blockquote>
 
 
Hi Albert 
 
What output you are getting when you are using values from directly data set not cube. 
Can you create this issue with sample data base and upload the file so that, i could take a look. 
 
lrnit

lrnrit

<blockquote class='ipsBlockquote' data-author="'AlbertYu'" data-cid="93437" data-time="1325631760" data-date="03 January 2012 - 04:02 PM">
Thanks for the example. 
 
Yup. I will be more clear: 
 
I am using a data cube with the following set up: 
- Group: Org Name 
- Group: IT Sup Name 
- Summary field (measures): COUNT IT Sup Name 
 
When I set my pie chart element to the following: 
 
Slice Size Definition: data["Summary Field/IT_SUP_NAME"] 
Category Definition: data["IT Sup Name/IT_SUP_NAME"] 
 
it seems to come up with a correct pie chart (but just one). This is shown in "single_pie.jpg". 
 
What I want are multiple pies of ones similar to "single_pie.jpg". 
 
When I try to do this by setting: 
 
Slice Size Definition: data["Summary Field/IT_SUP_NAME"] 
Category Definition: data["IT Sup Name/IT_SUP_NAME"] 
Optional Grouping: data["Org Name/ORG_NAME"] 
 
the pie chart shown in "multiplepie.JPG" is shown. 
 
However, this output isn't correct because the values are all 1. They should be values like [5,6], [10,20], [30,10], etc? not 1s. 
 
Do you know why? What do I need to do or not do in order for the output to be what I want? 
 
Your help is much appreciated. 
 
 
Thank you in advance, 
 
Albert 
 
 </blockquote>
 
 
Hi Albert 
 
What output you are getting when you are using values directly from data set not cube. 
Can you create this issue with sample data base and upload the file so that, i could take a look. 
 
lrnit

AlbertYu

Hi lrnit,

Here is a small sample database of my data.

Please let me know if you have any questions about it.

Regards,
Albert

lrnrit

<blockquote class='ipsBlockquote' data-author="'AlbertYu'" data-cid="93715" data-time="1325799927" data-date="05 January 2012 - 02:45 PM">
Hi lrnit, 
 
Here is a small sample database of my data. 
 
Please let me know if you have any questions about it. 
 
Regards, 
Albert </blockquote>
 
 
Hi albert, 
 
First of all i suggest you not to use cube as i tried but cant get desired output. 
 
But it is possible if we use data directly from dataset. 
 
What you need to do is 
 
yes/no Category Defination 
App Slice Size 
ORG Optional Group 
 
Important In category Defination Use Grouping on it and count aggregation over it in chart itself. 
 
 
Let me know if it works for you. 
 
lrnit 
 
Check Attachments

AlbertYu

It worked lrnit!

Thank you very much

I appreciate it.

See you around.

Albert