topic Re: Conditions for count in App Development

Conditions for count

aditi_haldule — Mon, 15 Mar 2021 16:34:47 GMT

Hi, I have a condition for a kpi measure where I'm using the formula count(IDs)- count({<month={'NC'}>}) so that I get count of IDs that excludes the IDs of the month NC. But now I also have to apply to show count of month=Nov and keep the condition of filtering out IDs with month as 'NC', so what formula should I use in measure?

Re: Conditions for count

chrismarlow — Mon, 15 Mar 2021 18:49:47 GMT

Hi,

Maybe I am missing something but if Month=Nov then how can Month be NC, in which case is just Month=Nov? Can you share some sample data?

Cheers,

Chris.

Re: Conditions for count

Saravanan_Desingh — Mon, 15 Mar 2021 18:55:50 GMT

@chrismarlow is right. How will you get NC, if you are filtering only for Nov.

Anyway try this if you still want to,

count({<month={'Nov'}>-<month={'NC'}>} IDs)

Re: Conditions for count

aditi_haldule — Wed, 17 Mar 2021 04:44:02 GMT

Hi,

actually NC here means 'no conversion' so for IDs that have not been converted have NC in the month column as well as other columns. So the column month currently has-Jan,feb,march...dec as well as NC. I want to exclude such IDs(IDs that have NC) and then in the remaining data, I only want to show count of IDs in november month.

So what condition should I put?