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
Creating charts with aggregated (grouped) dates
Migrateduser
Hi,
I'm new to BIRT but so far am very impressed! However, I'm having a hard time with a chart I'm putting together for a hospital. I would like to put together a chart showing the number of patients seen in one department by month. The underlying data has, among others, the following fields:
* Patient reference (used to count, and is the Y axis)
* Date (mm-dd-yyyy)
* Monthname (derived in the MySQL code)
* Monthyear (derived in the MySQL code)
The dates are set up as groups, but, if I only seem able to put in one 'group' variable at a time (e.g. month, year). My goal is to create a chart that can show either each data set as being month-year or having two groups (i.e. grouped by year, with months shown as a subgroup).
I know this is possible in pivot charts in Excel, and am hoping this is possible in BIRT as well (BIRT looks to be much better at creating reports!). Could anyone advise how best to go about this?
I've attached a screenshot showing my current setup, as well as my design so far.
Thanks in advance for any help you could provide!!
Best regards,
Tony
Find more posts tagged with
Comments
There are no comments yet