topic Re: Include Null Values Setting in Charts, equivalent for a formula? in App Development

Include Null Values Setting in Charts, equivalent for a formula?

chriys1337 — Mon, 20 Dec 2021 21:38:40 GMT

Hello,

In a bar chart I am counting my Customers per Dimension. In this bar chart I am using the "Include null values" Setting (it is unticked) which can be found under "Dimension".

In a textbox / KPI I also would like to count my customers. Unfortnately there is not such a setting to include / exclude null values. This means both figures are not matching :(.

Do you know how to achieve, that in a expression / formula the null values are not taken into consideration?

Thanks for your help,

chriys

Re: Include Null Values Setting in Charts, equivalent for a formula?

lorenzoconforti — Mon, 20 Jan 2020 16:22:24 GMT

It depends on whether values are null or blank; add set analysis to your KPI

{<Value -= {""}>}

{<Value = {"*"}>}

Re: Include Null Values Setting in Charts, equivalent for a formula?

Kushal_Chawda — Mon, 20 Jan 2020 19:36:25 GMT

-> With NULL values, you can simple count the overall customers like below

=count(distinct CustomerID)

-> If you want to count the values excluding NULL for specific dimension, you can use something like below

=count(distinct {<Dimension={"=len(trim(Dimension))"}>}CustomerID)

Re: Include Null Values Setting in Charts, equivalent for a formula?

chriys1337 — Thu, 23 Jan 2020 22:12:45 GMT

Hello Krush,

can you please explain your Set analysis formula?

"=count(distinct {<Dimension={"=len(trim(Dimension))"}>}CustomerID)"

I would think that =len(trim(Dimension)) just gives back the length of the Dimension? thank you