Hi,
I'm having trouble with this which is frustrating because I'm sure I was able to do this last year with another set of data.
I have data that I want to show in a pivot chart - however currently it's not showing the days of the month/s with no data. Screenshot is here: https://imgur.com/a/2LThYOX
I tried checking the box in field options to 'show items with no data' but it does a weird thing where it now shows every date in the year under each month - see screenshot: https://imgur.com/ca609Eq
I just want to be able to filter and look at the current month or year to date, and see days with data alongside days without data. This is to track incidents and see whether they are becoming less frequent.
Thanks!
