I’m having a dataset on a daily granularity, but only data for a few of the days. How can I create a chart (e.g. bar chart) that shows all days of the month, including the days that don’t have data assigned?

Hi Thomas, If you’d like to enforce the null values into your reports, you can use the IFNULL statement to achieve this.

hey Ivana, I’ll give that a try, thanks!

Fingers crossed for you!

See https://community.gooddata.com/data-models-kb-articles-46/how-to-display-null-or-missing-values-98.

SELECT IFNULL(x,0) + 0

may be needed.