Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
In the straight table the number of contracts are counted by the categories 'Late Payments'. I want the categories to be always displayed and zero values included. If the Date filter is not set, I get the desired result. All 3 categories are displayed. As soon as I filter by the MonthYear, only the actual accruing late payments are displayed. The goal is to have the dimensions displayed consistently in each month and for example in March 23 the category '61-90 days' counts 0 contracts.
I use following function
Count(distinct token_id)
And I also tried to use
If(Count(distinct token_id)=0, 0, Count(distinct token_id))
Include null values and include zero values is selected
Do you have any idea how I can make this work?
Thanks a lot
PatrickStraight table without filter
Count(distinct token_id) + Sum({1} 0)
Count(distinct token_id) + Sum({1} 0)
Thanks! It works.