Forum Discussion
Count IF based on date
Hello All - I have a scenario where I do a count IF based on below sample data table 1. Count IFS - Priority (P1,P2..) based on Open date & Closed date with situation = Issues ( should exclude act...
Hello -Let me create a simple table and explain it . In the below table the we are conting Priority for a date if the Issue category = Issue. Please find the Result table below as how it should display .
Thanks in advance
sudan
| Open date | Issue Category | Priority | ||
| 3/4/2019 | Action | P1 | ||
| 3/4/2019 | Issue | P1 | ||
| 3/4/2019 | Issue | P2 | ||
| 3/5/2019 | Issue | P2 | ||
| 3/6/2019 | Issue | P3 | ||
| Please note Issue category -Action is excluded | ||||
| Result | ||||
| Opendate | P1 | P2 | P3 | P4 |
| 3/4/2019 | 1 | 1 | ||
| 3/5/2019 | 1 | |||
| 3/6/2019 | 1 | |||
| 3/7/2019 |