manoj_arsul
Board Regular
- Joined
- Jun 27, 2018
- Messages
- 61
I want program for the below condition.(Last 5 Days Count City wise .) ....( eg .Today is -19th July)
1) Filter to Column "A" Status For Working .
2) Filter to Column "B" City For Pune.
3) Get Till date (Today) Count of column "A" in the cell of table ( Today 19th)
4) Filter Today()-1 & Get date Count of column "A" in the cell of table ( 18th July)
5) Filter Today()-2 & Get date Count of column "A" in the cell of table ( 17th July)
6) Filter Today()-3 & Get date Count of column "A" in the cell of table ( 16th July)
7) Filter Today()-4 & Get date Count of column "A" in the cell of table ( 15th July)
Do the Same condition with other Pending , Pending - Not OK , Waiting
Source Data: -
<tbody>
</tbody>
Out Put :
<tbody>
</tbody>
1) Filter to Column "A" Status For Working .
2) Filter to Column "B" City For Pune.
3) Get Till date (Today) Count of column "A" in the cell of table ( Today 19th)
4) Filter Today()-1 & Get date Count of column "A" in the cell of table ( 18th July)
5) Filter Today()-2 & Get date Count of column "A" in the cell of table ( 17th July)
6) Filter Today()-3 & Get date Count of column "A" in the cell of table ( 16th July)
7) Filter Today()-4 & Get date Count of column "A" in the cell of table ( 15th July)
Do the Same condition with other Pending , Pending - Not OK , Waiting
Source Data: -
Status* | City | Country | Test | Date |
Pending | Pune | India | Ok | 19-Jul-18 |
Pending | Mumbai | India | Ok | 17-Jun-18 |
Pending - Not OK | London | England | Not OK | 16-May-18 |
Pending - Not OK | Pune | India | Not OK | 15-Jul-18 |
Pending | Mumbai | India | Ok | 18-Jul-18 |
Pending - Not OK | Mumbai | India | Not OK | 19-Jul-18 |
Pending - Not OK | London | England | Not OK | 17-Jul-18 |
Pending - Not OK | Pune | India | Not OK | 16-Jul-18 |
Waiting | London | England | Ok | 15-Feb-18 |
Waiting | Pune | India | Ok | 18-Jul-18 |
Waiting | Mumbai | India | Not OK | 19-Jul-18 |
Waiting | London | England | Not OK | 17-Jul-18 |
Waiting | Pune | India | Ok | 16-Jun-18 |
Working | Mumbai | India | Ok | 5-Mar-18 |
Working | London | England | Not OK | 18-Jul-18 |
Working | Pune | India | Ok | 19-Jul-18 |
Working | Pune | India | Ok | 17-Mar-18 |
Closed | London | England | Not OK | 16-Jul-18 |
Closed | London | England | Not OK | 15-Jul-18 |
Closed | Pune | India | Not OK | 18-Jul-18 |
Closed | Mumbai | India | Not OK | 19-Jul-18 |
Closed | London | England | Ok | 17-Jul-18 |
Closed | Pune | India | Ok | 16-Jul-18 |
Closed | Mumbai | India | Not OK | 15-Jul-18 |
Closed | London | England | Not OK | 18-Jul-18 |
<tbody>
</tbody>
Out Put :
Pune | Working Count | Pending Count | Pending - Not OK | Waiting Count |
15-Jul-18 | 0 | 0 | 1 | 0 |
16-Jul-18 | 0 | 0 | 2 | 1 |
17-Jul-18 | 1 | 0 | 2 | 1 |
18-Jul-18 | 1 | 0 | 2 | 2 |
19-Jul-18 | 2 | 1 | 2 | 2 |
<tbody>
</tbody>