topic Re: How to show null values when filtered? in App Development

How to show null values when filtered?

Femke_DPG — Thu, 02 Jun 2022 08:53:35 GMT

Hi all

I want to see the null values, when filtering on week. For example: if I filter on week 2, I want to see the whole line, also the null values:

Now I see this, so only where it is filled in:

Can anyone help me on this please?

Appreciate!

Thanks

Femke

Re: How to show null values when filtered?

Or — Thu, 02 Jun 2022 09:18:30 GMT

If these values are actually null in your data (that is, there is a data row with the combination of dimensions that is showing null) this should happen automatically. If these are missing intersections (that is, there is no data associated with this combination of dimensions), I can't think of a way to do this that doesn't involve filling in the missing combinations in the script or inserting dummy data.