Master Calendar not showing 0-values (count data on textfield)

[ToinkToinkTigger]

Hi all,

I have added a master calendar to my dataset. This usually works fine as in it would also show 0-values on the X-axis. 

However this time it is not. 

This time however, I want to plot the count of field "verpakken.afwijking'' which is a text field as a function of time from the master calender. Count data works just fine, but it does not show months where count is 0. Show 0-values is enabled.

Anyone an idea what could be wrong here?

[rubenmarin]

Hi, you can try adding +Sum(0) or +Sum({1}0) to your expression.

[ToinkToinkTigger]

Ah, I thought it was working, but still not displays months where the count and/or sum is 0 for the selected month from master calendar.

The input in the field is a textfield, could that have something to do with it?

[rubenmarin · Accepted solution]

With the {1} doesn't work either? +Sum({1}0).

If you can make a sample with some dummy data to test I can take a look when I have some free time.

If it's a pivot table with vertical and horizontal dimensions it gets more complicated because the chart only calculates the expression in the intersections of existing values for both dimensions.

[ToinkToinkTigger]

adding +Sum({1}0) worked! Did try that too, not sure why only now I can see the effects. 

Thanks!