Explore - Allow 0 values to be shown on time axis
Discussed with support who said Explore doesn't currently support this.
When making a report that shows all of our Organizations per region (Y axis) and the month they were created (X axis), if there weren't any Organizations created in the last month on the X axis, it won't show that month at all. It's important for us to show VISUALLY that there are no new Organizations created, otherwise the viewer could think that we just forgot to show the last month and it's our fault.
This is so important to consistency and readability! The other place I want this is when I have the same report going out every month, and it shows how many tickets had each reason from a custom field. If in May nobody chose one reason, the May report lists 4 total reasons, but June and April have 5. I just want my report to output the same rows and columns each month, even if the value for that cell is 0.
Came searching for how to have my reports that show certain types of contact by month to show every month, even if there wasn't any contact. Very disappointed to see it can't be done.
Please sign in to leave a comment.