Hi,
I have a two option field in my entity called Paid or Unpaid - default value set to No.
I have created a simple chart using the Paid or Unpaid for the Legend Entries(series) Count: all
For the Horizontal (Category) Axis label I've also selected the Paid or Unpaid two option field.
The chart uses a view that filters out records based on the current Year field and if another Approval Status field is set to 'Fully Received'
This view is working as it shows two records that the Approval Status is set to 'Fully Received' and current year is 2020
When adding the chart to a dashboard - none interactive' - created not at entity level, the view and chart in 'preview mode' shows correctly: a bar chart with a height of two and underneath the bar a value of 'No' is displayed above the chart's Horizontal axis of Paid or Unpaid.
However, when the dashboard is published then added to site map of my app and the app is saved and published the dashboard shows, but the chart has (blank) displaying instead of No.
When drilling down to the records it shows the two correct records with a correct Paid or Unpaid value marked as 'No'
So not really sure why the chart is showing (blank) instead of 'No'
Does anyone know why this is happening?