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; } } }

Charts based on grouping

Uday Reddy · 2011-09-19T08:36:38+00:00

Hi, I have a requirement. Below is the data set available. Technologist Exam_Count Modality DGG 243 CT HDS 224 CT PAP 214 CT TN 192 CT GVN 191 CT DJN 174 CT PSS 152 CT Unknown 144 CT JDC 137 CT ML 134 CT …

Uday Reddy

Hi, 
 
I have a requirement. Below is the data set available. 
 
Technologist Exam_Count Modality 
DGG 243 CT 
HDS 224 CT 
PAP 214 CT 
TN 192 CT 
GVN 191 CT 
DJN 174 CT 
PSS 152 CT 
Unknown 144 CT 
JDC 137 CT 
ML 134 CT 
AJ 132 CT 
CC 137 MR 
EH 107 MR 
RIE 84 MR 
DBW 80 MR 
KK 74 MR 
SHS 74 MR 
SS 74 MR 
Unknown 74 MR 
RTN 72 MR 
JRA 62 MR 
DK 56 MR 
MC 56 MR 
JT 53 MR 
 
 
For each Modality type (eg. CT,MR) I need to generate a pie chart with Technologist Vs Exam_Count having top 10 exam_counts. 
 
Thanks, for the help. 
 
Uday.

Find more posts tagged with

Comments

mwilliams

What is your BIRT version?

cypherdj

You just need to use the optional grouping on your modality column to get multiple pies, one per modality "group".

See the example attached, which expects a CSV file as source.
In my case, this file is named data.csv in the folder C:\work\tools\birt-rcp-report-designer-2_5_1\workspace

This example was done with BIRT Designer 2.5.1.

See attached image showing the resulting chart (not sure why it's not showing the exam count for that technologist in the slice label there, I think I left all data types as String, instead of integer for exam_count maybe)

I hope this helps,
Cedric

Uday Reddy

Thanks for the reply.

Let me explain my requirement in a pictorial way.
1. The Data Set is to be divided into groups based on the Modality.
2. For each Modality I need one pie chart with top 10 exam_counts and a legend.

I have attached an image file.

Tried doing in the following (but failed).
List (Grouped on Modality)
Header
GH1
Detail
GF1
TECH_TABLE
PIE CHART (Which uses TECH_TABLE)
Footer.

Are there any better ways to achieve this.

Uday Reddy

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="83001" data-time="1316462216" data-date="19 September 2011 - 12:56 PM">
What is your BIRT version? </blockquote>
BIRT version 2.5.0

mwilliams

Take a look at the attached. I left the detail row of the table so you could see that in fact the top 10 for each group were shown. You can delete the detail row of the table and it will show the same chart.

Hope this helps.

Uday Reddy

Thanks Willams, your solution really helped me.

By taking above solution as reference I tried to introduce one more level of grouping but couldn't achieve it.

Here is the requirement. Sample data set is as follows (attached as File1.txt):

Person Week Count Model_Type

BASKIN CINDY HOPE MD 04-JUL-11 1 Type2
BASKIN CINDY HOPE MD 04-JUL-11 1 Type1
...
...

1. Group on the Model_Type.
2. Group on the Person and find the total_Count.
3. Plot a pie chart for each Model_Type type, Person Vs Total_Count (Top 10).

Also, attaching a pictorial representation of the requirement.