count of fields

[#1]

Hi Team,

I have 4 fields

Load * inline[

ID1,ID2,ID3,Date

1,18,31,12/12/2014

29,15,31,11/12/2015

10,13,1,10/12/2015

12,13,1,11/19/2015

];

I want to write a single expression where the condition is:

Distinct count(if ID1>5, ID2>12, ID3>5,Today()-Date>60) using set analysis, I am getting incorrect results.

Can you please help. Also, when user clicks on any chart. the selections shouldn't be changed.

[sunny_talwar · Accepted solution]

Try this:

Count(DISTINCT {1<ID1 = {'>5'}, ID2 = {'>12'}, ID3 = {'>5'}, Date = {"$(='>' & Date((Today() - 60), 'MM/DD/YYYY'))"}>} Date)

Update: Add 1 if you don't want this count to change based on any selections.