Skip to main content



      Home
Home » Archived » BIRT » possible to have a dynamic date x axis
possible to have a dynamic date x axis [message #1058521] Tue, 14 May 2013 07:53 Go to next message
Eclipse UserFriend
I have a 3 series bar chart that I want to use to compare performance

my series are: cases opened, cases resolved, cases closed. (these are date fields)

I have this configured okay on y axis, no problem. but I have a problem with the x axis, as I dynamically want to set the start date to 7 days from now.

so that it shows something like this in graph form (sorry about the bad table):

Day------------Open-----Resolve-----Close
Wednesday 8th---4----------5----------2
Thursday 9th-----7----------8----------2
...

then if I run the report tomorrow it should show:

Day------------Open-----Resolve-----Close
Thursday 9th----7----------8----------2
Friday 10th------3----------6----------6
...

The problem I have is I don't know how to give an array of values to the axis. I tried something like this (I know that the dates are set, I was going to use some javascript to give them the correct rolling dates):

x = new Date ("2013/05/13");
y = new Date ("2013/05/12");
retVal = new Array(x, y);

but it doesn't work.

Anyone done any thing similar?
Re: possible to have a dynamic date x axis [message #1058775 is a reply to message #1058521] Tue, 14 May 2013 23:06 Go to previous messageGo to next message
Eclipse UserFriend
So, you just want to automatically have the last seven days in the chart? Let me know.
Re: possible to have a dynamic date x axis [message #1058833 is a reply to message #1058775] Wed, 15 May 2013 06:22 Go to previous messageGo to next message
Eclipse UserFriend
yes
Re: possible to have a dynamic date x axis [message #1058961 is a reply to message #1058833] Thu, 16 May 2013 00:04 Go to previous message
Eclipse UserFriend
You could just set a filter or limit your query using something like: BirtDateTime.addDay(BirtDateTime.today(),-6);
Previous Topic:don't want Parameters to be mandatory
Next Topic:URL Escape codes coming in chart x axis label
Goto Forum:
  


Current Time: Wed Jul 23 07:44:08 EDT 2025

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

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

Back to the top