charting over grouped aggregate functions? [message #64127] |
Wed, 03 August 2005 14:11  |
Eclipse User |
|
|
|
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  |
Eclipse User |
|
|
|
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
|
|
|
Powered by
FUDForum. Page generated in 1.29441 seconds