Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
@mohdazhr did you find the solution for your post, I'm looking a solution something similar to this?