I have an object class called Invoice history that consists of the properties Amount (float) and Completed date (DateTime). I have plotted Invoice history in a bar chart where data is grouped by month and the amount is summed. A filter ensures that only one year at a time is shown. Is there a way I can make the bar chart show all the months of the year, even though some months do not contain data?
In the screenshot here I would for example like to see November and December:
I tried adding an app variable that finds the last day of the current year as input for max value on the X-axis (and same method with min), but the chart then shows numbers in stead of month names and one month too many.