Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table like this. when I pivot it, I only want to do a distinct count of Names with Status MQL, I want the count to ignore the names associated with the not MQL status. Here is the expression I thought would work:
if(FINALMQLSTATUS='MQL',Count (DISTINCT [Name]),0)
Name | FINALMQLSTATUS |
Bob | MQL |
Jim | Not MQL |
Sally | MQL |
However, it still counts all of them and seems to ignore the if statement. Please help. What am I doing wrong? Thank you
I am about to. Thanks
A question about your expression above. What if I have two conditions instead of one? For instance, suppose I want to only count the name if FINALMQLSTATUS = 'MQL' AND [product interest lexi]='Yes'. What would that syntax look like?
I am referring here to the original response you gave where you suggested to use = Count(DISTINCT {< FINALMQLSTATUS = {'MQL'} >} [Name])
Just this
Count(DISTINCT {<FINALMQLSTATUS = {'MQL'}, [product interest lexi] = {'Yes'}>} [Name])