Forum Discussion
Changing status between users
Hi,
I have a table like below:
| Date | Status text | Status | User |
| 2021-01-02 | Deactive | 1 | A |
| 2021-01-24 | Active | 0 | A |
| 2021-02-04 | Active | 0 | B |
| 2021-03-10 | Deactive | 1 | B |
| 2021-03-12 | Active | 0 | C |
| 2021-03-15 | Deactive | 1 | C |
| 2021-04-19 | Active | 0 | C |
| 2021-05-10 | Deactive | 1 | D |
| 2021-05-11 | Active | 0 | D |
I am looking to create two separate column charts. One to see the trend of the number of users whose status changed from "active to Deactive" and the other "Deactive to active". For example, when it comes to "deactive to active" chart, the total number is 5 (Users A, B, C, C, and D) and for the "Active to deactive" chart, the number is 4 (Users A, B, C and D) like below: As you can see the latest date is important. Also, please note that the first date for the user is also considered as a change. For example, for user C, it first become active in March, then become deactive in March, and finally become active again in April.
Also, that would be ideal by clicking the graph I can see the instances in the table.
1 Reply
AnonymousThank you!
