topic Re: Defining set expression with condition in App Development

Defining set expression with condition

andre_bento — Mon, 25 Mar 2024 16:02:27 GMT

Good afternoon all,

I am defining a measure that calculates the number of distinct users and applying it to a bar chart where my x-axis represents years.
My expression is the following: Count(distinct(FULL_NAME))
And I want to change this expression so that it only counts my users that are directly related with a specific year. In my current visualization one of the bars has values but it is not representing any year, this is concerning our users that haven't had any interactions with our project but that are already created and registered, I want to eliminate that column. I tried the following: Count(distinct FULL_NAME) If($(date_auto_grain) IN {$(date_auto_grain)}, 1) however I am getting the error: Garbage after expression 'If'.

Re: Defining set expression with condition

rwunderlich — Mon, 25 Mar 2024 16:53:03 GMT

Perhaps the simplest way to deal with this is to uncheck "Include null values" in the chart Data properties.

-Rob

Re: Defining set expression with condition

andre_bento — Mon, 25 Mar 2024 17:05:16 GMT

That does not resolve my issue, since the column is not with null values, what i have is a null value for the column in x-axis:

Re: Defining set expression with condition

BrunPierre — Mon, 25 Mar 2024 20:26:00 GMT

Data handling

Under AddOns

Uncheck >> Show zero values

Re: Defining set expression with condition

rwunderlich — Mon, 25 Mar 2024 22:33:08 GMT

That is what I was suggesting. If you uncheck "Include null values" for your Year dimension, does the null bar disappear?

-Rob