Forum Discussion
Show Dates with 0 data
I am creating a report for my customer services team. This is problems resolved by the day of the problem being resolved. For example of what i am trying to achieve, today should show 0, and there should be other days showing 0 too. I have tried using the show items with no data tab and still no joy in showing 0 for certain days. Any help would be appreciated.
2 Replies
Hey tristanweeks47 ,
are you using a proper date table with all the dates in the given timeframe?
Best regards
Denis
Have a date table yes, however it didnt like the relationship between this table and said date table (I am assuming its because i have a number of other tables already linked to the date table). So i have used the Date in the current table which is called 'modified on' and grouped the data via Bins
