Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Building a simple PIE chart from single row of data
Migrateduser
<p>I have a problem with creating a simple BIRT pie chart and perhaps someone could help.</p><p> </p><p>I have a data set that is generated from the following SQL SELECT statement.</p><p> </p><p>select count(*) total ,
sum(if(hour(StartTime) >= 0 and hour(StartTime) < 9,1,0)) earlyMorning,
sum(if(hour(StartTime) >= 9 and hour(StartTime) < 13,1,0)) Morning,
sum(if(hour(StartTime) >= 13 and hour(StartTime) < 14,1,0)) Lunch,
sum(if(hour(StartTime) >= 14 and hour(StartTime) < 18,1,0)) Afternoon,
sum(if(hour(StartTime) >= 18 and hour(StartTime) < 24,1,0)) Evening
from calls</p><p> </p><p>It groups a set of calls into sections based on the time the calls arrived.</p><p> </p><p>The data appears as a single row with the columns names as total, earlyMorning etc.</p><p> </p><p>E.g.</p><p>total earlyMorning Morning Lunch Afternoon Evening</p><p>100 10 50 10 10 10</p><p> </p><p>I would like to present the data as a pie chart using BIRT 4.3 designer.</p><p>I can't seem to get the PIE chart to pick up the different categories i.e. Morning, Lunch etc.</p><p> </p><p>Any help appreciated</p><p>John.</p>
Find more posts tagged with
Comments
There are no comments yet