Hi all ,
I have got the similar data and multiple iterations of this across several dates. What i would like to capture is the movement for ID's between 2 different dates (allow the user to select the variability of comparison dates like 4 weeks , 12 weeks etc ) and categorise them under
positive movement
negative movement
no Movement
as an example i have the following data
| date | id | status |
| 02/04/2015 | a1 | 01 |
| 03/04/2015 | a1 | 02 |
| 02/04/2015 | a2 | 02 |
| 03/04/2015 | a2 | 01 |
| 02/04/2015 | a3 | 01 |
| 03/04/2015 | a3 | 01 |
I would like to show is when the user selects Positive movement
| id | current status | Last week status |
| a1 | 02 | 01 |
when user select negative movement
| id | current status | Last week status |
| a2 | 01 | 02 |
when user selects no movement
| id | current status | Last week status |
| a3 | 01 | 01 |
