Hello,
I have an issue tracking list on sharepoint which hasn't got that many inputs from any individual category, that outputs a grouped chart displaying the count of issues by date (grouped by month).
Whenever a single slice of data has no entries (month with no issues), it doesn't display on the chart (eg: July will display just after May, skipping empty June), causing plenty of misinterpretation. As the data is quite seasonal, it happens frequently.
Is there a way to display the empty months as in the "show items with no data" option from an Excel pivot table?
Thanks for the help