We are using the chart wizard to show a particular value aggregated across items each month for analysis. However, if the board doesn’t have any items for a particular month that month will not show on the x axis. I need to make sure every month is shown on the chart so we can immediately see months that have no entries. I am not “show empty values.” I just need to have every month represented on the x (or Y) axis and if there are not items for that month show it as 0. Any ideas?
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Need to see which dropdown labels are not being used? | 1 | 6 | January 22, 2026 | |
| Is there a way to have empty dates populate on the xaxis?i | 1 | 98 | July 12, 2024 | |
| How to x-axis in a bar graph - even without data | 3 | 967 | June 27, 2024 | |
| Is there a way to have empty dates populate on the xaxis? | 2 | 153 | January 8, 2025 | |
| Chart Widget to show Zero/Empty Values - All Column Types | 2 | 41 | September 24, 2025 |