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 | |
|---|---|---|---|---|
| How to x-axis in a bar graph - even without data | 3 | 939 | June 27, 2024 | |
| Omitting blank values in stacked line chart | 2 | 694 | June 7, 2024 | |
| Is there a way to have empty dates populate on the xaxis? | 2 | 130 | January 8, 2025 | |
| Dashboard (new engine) Issue | 1 | 412 | March 20, 2024 | |
| Is it possible to make a line chart that only shows a line for the data available | 1 | 1083 | May 10, 2023 |