Flat File Data Set Problem

Apologies if this is a simple matter, but I'm struggling!

I have a flat file data set, containing the following fields:
Appointment Date
Waiting Days
Count

where the Count is the number of people with this number of waiting days.
For instance:
Appointment Date Waiting Days Count
01/08/2009 5 3
01/08/2009 4 2
02/08/2009 1 5
....
01/09/2009 2 6
01/09/2009 3 4
02/09/2009 1 26
...

I need to chart the average Waiting Days per month. (i.e. The total (Waiting Days for date * Count for date) divided by the total Count for each month)
I can do this fairly easily in SQL but am baffled about how to do it from a flat file.

I've tried creating a table, with aggregation fields, but am struggling to use these in a chart.

Can anyone point me in the right direction?

Find more posts tagged with

Comments

mwilliams

Hi AlanC,

What version of BIRT are you using? I believe that in 2.5.0, the ability to use aggregations in a chart from a table became available. There are also aggregations you can use in the chart editor. Can you attach a flat file of data and a report design set up how you currently have it? Thanks.

AlanC

Hi Michael
Thanks for looking at this.
Our version of BIRT is (I believe) 2.3.2.

I've attached a first attempt at what I want (but it won't work with the chart in place).
The source file has a Referral Date, with a Waiting Time (in days) and the number of patients waiting for that time on that date. We use the Referral Date plus the Waiting Time to calculate the Appointment Date, which is the date used for grouping.

I need a chart that calculates the average wait for all patients with an appointment date in each month.

I've changed the extension on the input files from .csv to .txt in order to attach them.

Thanks again for your help.

Alan