Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi @DavidJG ,
have you checked Include null values in dimension section and Include zero values in Add-ons section?
BR
m
Hi, yes both are marked to "include null/zero values".