Linear Chart - Empty Data

[system]

Hello Friends,

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

---

disipebr (BOB member since 2013-05-14)

[system]

Hi,

This Reporter’s FAQ can help:

FAQ: Reporter

How can I include data for all months in a crosstab, even if a particular month has no data? One way to do this is to create a second data provider using only the months. Then link (or “merge”) the second data provider (query) with the first data provider. Use the month column from the second data provider in the cross tab. This should bring in all months even if there were no data for that month. However this technique does not work if you have sections in your report. Dave Rathb…

---

Marek Chladny (BOB member since 2003-11-27)

[system]

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.

The Boxi not have anything like that?

Thanks

---

disipebr (BOB member since 2013-05-14)

[system]

If available in your version, this is what the TimeDim function is for

It will give you a complete date/month/quarter/year series between the min and max date in your data set

use as per the help pages

TimeDim function - to generate list of dates…

=FormatDate(TimeDim([Your dateDate];DayPeriod);“dd-Mmm-yyyy”)

The TimeDim function will give you a continuous set of days that auto-orders correctly to enable better trend charts…

---

matt1306 (BOB member since 2005-08-09)