possible to have a dynamic date x axis [message #1058521] |
Tue, 14 May 2013 07:53  |
Eclipse User |
|
|
|
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?
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.06331 seconds