Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, how can I improve this formula into Set Analysis
Count(DISTINCT if(Date1 = Date2, Name))
Thanks!
Add the condition in script:
if ( Date1 = Date2 , Name) as Name
Then in the Set analysis Count (DISTINCT Name)
regards.
It depends on your datamodel if you could use SA. You could try it with:
count({< Name = ["=Date1=Date2"}>} Name)
and if not should at least the following approach perform significantly better:
if(Date1=Date2, count(Name))
- Marcus