Skip to main content



      Home
Home » Archived » BIRT » charting over grouped aggregate functions?
charting over grouped aggregate functions? [message #64127] Wed, 03 August 2005 14:11 Go to next message
Eclipse UserFriend
Originally posted by: adrian.cheerful.com

Hi,

I have a database of customers, like this:

Name Level Purchases
John Smith Gold 1000
Jane Doe Bronze 20

etc.

I created a report, grouped by Level with an aggregate data of group total
(total purchases of the group) Now, I would like to generate a chart based
on this data (x-axis is level and y-axis is the group total) Is there a way
I can do this? I can't seem to reference the aggregate data, only computed
columns and actual columns.

Thanks,
Adrian
Re: charting over grouped aggregate functions? [message #64395 is a reply to message #64127] Wed, 03 August 2005 21:54 Go to previous message
Eclipse UserFriend
Hi Adrian,

You can achieve the result by using a SQL query as follows:

SELECT SUM(Purchases) AS GroupTotal,
Level
FROM Table
GROUP BY Level

Then set: X-Series Data Definitions = row["Level"]; Y-Series Data
Definitions = row["GroupTotal"]

Cheers.

Regards,
Nina
Previous Topic:How do I manipulate two metrics from two data sources in a report ?
Next Topic:Comments in SQL query
Goto Forum:
  


Current Time: Thu May 08 14:48:19 EDT 2025

Powered by FUDForum. Page generated in 1.29441 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top