Visualization display

[herve06]

Hello
I would like to create a graph with data from the last 30 days.
It's ok if I've got data every day.
But if not, I've got this.
I don't have data in my MySQL DB between the 2015-02-08 and 2015-03-01, so I would like a "hole" (from 2015-02-09 to 2015-02-28) instead of this visualization.
Is it possible ?
Thanks

 

[cheesegrits]

Not that I can think of, no.

The only approach I can think of would be similar to this:

http://stackoverflow.com/questions/3538858/mysql-how-to-fill-missing-dates-in-range

... and create a MySQL view from a 'coalesce' query like that (substituting 'now' and '+1 month' for the hard wired date range). Then create a Fabrik list on that view, and build your graph from that.

The only other alternative would be to have a cron job which runs once a day at midnight, checks to see if the previous day has any data, and if not, insert a "dummy" row with 0 for your data.

-- hugh

 

[cheesegrits]

Oh, and if you need help creating the query for such a view, Stack Overflow is an awesome resource for getting help.

-- hugh

 

[herve06]

Hello, Thnak you for your answers. I will have a look soon.