Eclipse Community Forums: BIRT » possible to have a dynamic date x axis

Help

Home

Home » Archived » BIRT » possible to have a dynamic date x axis

Show: Today's Messages :: Show Polls :: Message Navigator

possible to have a dynamic date x axis [message #1058521]

Tue, 14 May 2013 11:53

Darren Gipson

Messages: 3
Registered: April 2013

Junior Member

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?

Report message to a moderator