-
1. Re: calculated date x axis
Tracy RodgersFeb 20, 2014 9:55 AM (in response to Steffen Lerbs)
Hi Steffen,
One way you could do this would be to create a calculated field that combines today and yesterday similar to:
if [Date]=today() then [Open Tickets Today]
elseif [Date]=dateadd('day', -1, today()) then [Open Tickets Today] - [Created Tickets Yesterday] + [Resolved Tickets Yesterday]
end
If you want to be able to change the number of days before today that you want to look at, replace "-1" with the parameter.
Hope this helps!
-Tracy
-
2. Re: calculated date x axis
Steffen Lerbs Feb 20, 2014 11:44 PM (in response to Tracy Rodgers)Hello Tracy,
thank you for your reply. I have managed to correctly calculate the 2 amounts for Open tickets. The remaining challenge is to present the data in a graph with the correct date on the axis. I am not capable of showing that in a graph.
i hope you have an idea
thank you in advance
Steffen
-
3. Re: calculated date x axis
Tracy RodgersFeb 21, 2014 9:35 AM (in response to Steffen Lerbs)
Hi Steffen,
Are you able to post the packaged workbook (or a sample workbook) showing the issue?
-Tracy