show "empty" dates in chart after a set expression for a Canonical calendar

[DavidJG]

Hi all clever people!

I'm currently working on expanding a data model with multiple dates for orders, invoicedDate and refoundedDate, so i'm plan to use multiple calendars and a Canonical calendar. Before I implement anything it wanted to test it.

The test model looks like this:

when I sum invoice amount using the invoice calendar I get the expected result of

so far so good, but when use the Canonical calendar to sum invoice amount (or refound) i need to specify the dateType as this: 
Sum({<DateType={'invoice'}>}invoice) 
And because of the set expressions all date with no registered invoice amount are excluded like this:

But I still want to show all the days in between as empty or zero, am I missing some settings for the chart or in  the expression or something else? I'd hope to not needing super complex expressions because it would be redundant to do every time I want to use the "combined calendar"

thanks

[mato32188]

Hi @DavidJG ,

have you checked Include null values in dimension section and Include zero values in Add-ons section?

BR

m

[DavidJG]

Hi, yes both are marked to "include null/zero values".