Conditions for count

[aditi_haldule]

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?

[chrismarlow]

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.

[Saravanan_Desingh]

@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)

[aditi_haldule]

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?