Plotting graph using business days(xaxis) but displaying xaxis as Quarter

Hi All,
I would be happy if someone could help me out with a problem I am facing on BIRT Charting. My requirement is to plot a line graph with x-axis as "QUARTER" and y-axis as the total volume of cars sold (SUM by Business Days). So I need to plot the graph actually with Total volume VS Business Days. But actually when its displayed, instead of displaying the business days, I would like to group just the labels and display as "Quarter ..". For example, I have a chart and the business days range is say 1 Jan 2009 to 30 Jun 2009. So now the graph will be plotted by Volume and business days. But, the labels on the x-axis should be like Q1 2009, Q2 2009 instead of showing all the business days (1Jan2009, 2Jan2009, 3Jan2009, ....... 30Jun2009). I would appreciate any help.

Thanks,
Rahul

Find more posts tagged with

Comments

Rahul_NJ

Can someone please help me out?? This is a sincere request.

mwilliams

Hi Rahul,

Can you set up a sample report how you'd like it to look using the sample database? I'll then use this report design to try to find a way to do what you're wanting to do. Thanks.

Rahul_NJ

Hi Micheal,
Thanks for your response. I have attached the sample rptdesign. In this graph, the total count of orders for each day is plotted vs the order dates. The requirement is that, the line graph should be plotted against the order dates on the x-axis, but the visible label on the x-axis should be broken down into Quarters. For example, if you have Order dates from 01 Jan 2009 to 30 Jun 2009. Then the graph should have points for all order dates as in the example. But the display in the x-axis should only be Q1 2009 and Q2 2009. I hope this information is good. Please let me know if you need any additional information.

Thanks,
Rahul Sudhakaran
(201)-654-1723 (Cell phone)

Rahul_NJ

Micheal,
Can this be solved using scripting?

Thanks,
Rahul Sudhakaran

mwilliams

Rahul,

Here's a report in which I made a quick example of a way to do this. You may want to do it a different way to determine which label to replace, but this one shows how to change the first label for each quarter to the quarter value and sets the rest to "".

Hope this helps.

Rahul_NJ

Thanks Micheal. Im gonna play with this. I will figure out how to replace the label almost in the middle of a Quarter's range. And also is it possible to highlight (change color) of the grid line ticks after each quarter ends? Thanks a ton.. This helped me alot.

Rahul_NJ

Micheal,
It would be really great if you could help me to hide the ticks and make it visible only on the beginning of the quarter. Its the same logic, but im not able to make the ticks visible. I need the exact value for the line attribute. Could you please help me out?

Thanks,
Rahul

mwilliams

Rahul,

I've messed with the visibility and color attributes of the ticks in the chart script and it doesn't seem to have any effect. If I figure out what I'm doing wrong, if anything, I'll update you. Good luck!

mwilliams

I'm guessing that most likely it's all or nothing on the ticks though. This may be something you could request as an enhancement request for future versions. You can do that here:<br />
<br />
<a class='bbc_url' href='http://www.eclipse.org/birt/phoenix/reportabug.php'>BIRT: Reporting Bugs and Requesting Enhancements</a>

Rahul_NJ

Sure. Thanks Micheal.. Will do that... Thanks alot for all your help..