Set Analysis Expression

[helen_pip]

Hello

I have an expression which is using set analysis, but it appears not to be working.  I have set the criteria so it is only looking at one of my data sources, but it brings back all results, and ignores the fact I have asked it to only bring back results for that particular data set

I have checked the data structure and all seems O.K., so I was wondering if someone could kindly look at the expression, to see if I have written it wrong

=Count({<data_source = {'Out'}>} {diagnostic = {' No Date' , 'Month End'}>}, ID)

Any help would be greatly appreciated

Kind Regards

Helen

[SunilChauhan]

dont use , before ID in above expression and use , b/w two conditions see below

Count({<data_source = {'Out'},diagnostic = {' No Date' , 'Month End'}>} ID)

hope this helps

[helen_pip]

Hello

Thank you for your suggestion, I have removed the comma (,) and the same problem still applies.  Apart from the comma, did you kindly have any other suggestions?

Kind Regards

Helen

[SunilChauhan · Accepted solution]

syntax could be like

count({<field1={'Value'}, field2={'Value'} >} IDfieldname)

let me know if you have have any Q's

[helen_pip]

Hello,

Thank you so much.  This has worked......I really appreciate your help

Kind Regards

Helen