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 | |
|---|---|---|---|---|
| Show full x-axis even if there is no data | 0 | 1654 | September 1, 2022 | |
| Is there a way to have empty dates populate on the xaxis?i | 1 | 94 | July 12, 2024 | |
| Using Numbers-Widget to display row data for a specific month | 1 | 1762 | June 21, 2021 | |
| How to x-axis in a bar graph - even without data | 3 | 960 | June 27, 2024 | |
| Is there a way to have empty dates populate on the xaxis? | 2 | 145 | January 8, 2025 |