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]
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!
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
Are you able to post the packaged workbook (or a sample workbook) showing the issue?