Tips to design this report

Hey,
My teammate gave an SQL query that contains data like this:
++++
Month PKG_ID AVG
==== ====== ====
1 23 456
1 26 4353
1 30 12
1 45 0
2 23 45
2 26 0
2 30 435
2 45 345
This goes for the whole year's month for each package
++++
Month is X Category and AVG is Y axis
My task is to built a single Line chart that displays the previous data so that the management can view the sales of all package during the year in on single chart.
Would you please help me how to design this?
One of the problems is I can't use Month as X axis since it is not distinct.
Is it possible to use BIRT in this situation?
Should I ask my teammate to modify the query?
Thanks.

Find more posts tagged with

Comments

bhanley

Can you use the package ID as the X Axis and the AVG on the Y axis? You could then use the Month on the label or potentially as a grouping.

HuBaghdadi

Well no, the requirements are:
X axis is the month
Y axis is the AVG
Should I ask my mate to change his SQL query?

bhanley

I am not sure I see the issue. These data represent a classic implementation for a line chart. You would have the months and the averages on the X and Y axes respectively. Then, if I were to map the simple sample below into a chart; there would be four lines, or series, on that chart. I would then consider using the package ID as the label on a mouse-over for each plot point on the chart itself.

The chart wizard should walk you though setting this up. If I have missed something here that is preventing the chart from being realized, polaease let me know. I would love to help.

HuBaghdadi

In my case:
1. What should be Category (X) Series?
2. What should be Value (Y) Series?
3. Should I use Optional Y Series Grouping?
>>I would then consider using the package ID as the label on a mouse-over for each plot point on the chart itself.
would you please guide me how to do this?
Dump questions? yes but this is my second report in BIRT and I'm lost.
I appreciate your time and patient.

bhanley

Here are the steps:

1) Drag a chart off the palette.

2) On the first page of the chart wizard, select "Line Chart" on the left side. Click Next.

3) On the data screen, bind your chart to an existing data set (Tick the "Select Data From" radio button and choose your data set in the drop-down).

4) You will now see a preview of your data on the table at the bottom of the Wizard. You can now drag the data elements to map them to the proper component on the chart. Drag the month onto the X Axis. The Avg onto the Y axis and the Product onto the Y Category Grouping.

5) You can click finish at this point to evaluate your chart or click next to apply formatting.

I have attached a sample report and CSV data file that approximate your data and use that CSV data to build out the line chart as you requested. You can hopefully use it as a good point of reference.

Note that you may need to tweak the Data Source to point to a local directory on your machine where you save the CSV if you want to actually run this report.

Good Luck!

HuBaghdadi

Man, u r great.
Thank you so much.
Would you please tell me how to add the mouse over thing that you suggested ?

bhanley

No problem, glad things are working.

To add the mouse-over, set up the interactivity on the Y-Series (values) via the "Format Chart" screen on the chart wizard. Once you click Interactivity, choose mouse-over from the drop-down. Then use the expression editor to select the field you want to display (AVG).