I’m looking to find a way to show zero/empty values in the chart widget created in dashboards and/or Docs.
For background, we often use WorkForms via monday.com to survey stakeholders and the data collected aggregates over time. Data collected is used for broader reporting - we are currently trialing the use of Dashboards and Docs to both collate and present findings to internal/external stakeholders.
The issue is that when we create Dashboards etc to facilitate reporting, we are unable to illustrate any empty values (especially for dropdown, or select fields/columns).
For example, I have a status column (single select field) that has 5 possible options available. Only 3 have been selected based on forms submitted. When I create a chart/graph I can only see the 3 selected options populated (even with the “show empty values” box ticked in “customise settings” menu).
This a really problematic for us as options that have not been selected are valuable data points in themselves.
The only workaround currently is to export data via excel and recreate the graphs there which leads to a huge duplication of work and makes the feasibility of using Dashboards and/or Docs for client reporting less attractive.