Search the Community
Showing results for tags 'group'.
Found 1 result
Date data grouping does not show empty months
chartsaway posted a topic in Collabion Charts for SharePointHello, 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