Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
In my data, I have the following scenario:
Req # | Status |
1428 | Completed |
1365 | Completed |
1428 | Error |
1428 | Completed |
1365 | Error |
In my analysis, I want to show a count of Req # where there are more than 2 and their Status count of "Completed" is more than 1.. I've attempted using nested If statements, but my results do not show what I am looking for.
If (If(Count([Req #])>1,Count([Req #]))>2 and Count(Status='Completed')>1,[Status])
So my results should be:
Req # | Completed |
1428 | 2 |
Is there a better way (or rather the correct way) to handle this?
Please find the attachment, hope it will help you
Create a pivot table using below
Dimension 1: Req
Dimension 2: =if(Status='Completed',Status)
Expression : =if(Count(Total <Req> Status = 'Completed')>2 and Status = 'Completed',Count({<Status={'Completed'}>}Total <Req> Status))