Does anyone now if there's a way to make an Insights report show a "0" value on a line chart?
I've built a line chart that compares the # of tickets created vs the # tickets solved week over week (using MAQL to build out the "What"s and the "Week (Sun-Sat)/Year (Event)" filter as the "How"), and a problem I'm running into is that the chart just skips over weeks where there was no activity. As a result, I'll get an X axis with the following labels:
You can see how there's 3 weeks missing there on the chart because there were no tickets created or solved over those 3 weeks. However, I WANT it to show those 0s so that I can quickly see that there were 3 weeks with no activity rather than having to examine the X axis labels.
Anybody know if there's a way to make 0s visible? Is there any kind of "show no activity" filter?
Please sign in to leave a comment.