I have a big problem. I keep in my database creation date of all tickets that go, but tickets are not created every day.
When I put together a report and present these data in a line graph, the X axis is as month-day of creation and can filter out the last 7, 15 or 30 days with direct filter in the universe or a new variable using the where clause .
Thinking of a graph that has to contain even days that are not being saved (because they did not have tickets created), how can I include the days in sequence, like this:
08-22 - 5 Tickets
08-23 - 10 Tickets
08-24 - 0 (There was no record generated)
08-25 - 12 Tickets
08-26 - 0 (There was no record generated)
Thanks for the idea. I thought about it and did not think very usual thinking that other system that is very simple to do, just ask where you keep reading the same data as one internal cycle days.