I have a bar chart that is using the basic “count of id attribute” for the measure. The problem that I have is that some of the “view by” values are missing from the chart if their count happens to be zero. I need to show all possible values of the “view by” column on the chart, even if their count is zero.
Best answer by Joseph Heun
Something like this could work:
SELECT IFNULL(COUNT(Records of Event,Records of Event) ,0)*1
Sometimes there needs to be a little arithmetic trick at the end of the metric, so multiplying by 1 helps force the values.