Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
count({<field1={},match={field2,'',''}>}id)
am trying like did,its nt wrking
Can you explain what you are trying to accomplish? Do you want to select rows where field1 = field2?
-Rob
can we use match in set analysis
count({<field1={},match={field2,'some value','some value'}>}id)
Hi Dy
what are you trying to do, can you explain it?
Thanks
Karthik
You need count of ID where Field2 is equal to 'some value','some value'?
=Count({<Field2 = {'some value','some value'}>}ID)
Might be easy if you can share few rows of raw data
Hi, just guessing... match() is used to check values, if you want to apply specific values to a field there is no need of using match, the syntax os set analysis expects that, ie:
Count({<Field2={'value1','value2'}>} id)