topic Master Calendar not showing 0-values (count data on textfield) in App Development

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

ToinkToinkTigger — Fri, 16 Dec 2022 14:25:23 GMT

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?

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

rubenmarin — Sun, 18 Dec 2022 12:01:27 GMT

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

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

ToinkToinkTigger — Mon, 19 Dec 2022 07:58:08 GMT

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?

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

rubenmarin — Mon, 19 Dec 2022 08:54:01 GMT

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.

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

ToinkToinkTigger — Mon, 19 Dec 2022 09:16:33 GMT

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

Thanks!