Forum Discussion
rco123456
5 years agoMicrosoft Employee
table heatmap
i want to create a heatmap in a table
| user id | log in date |
| 1 | 1/1/2020 |
| 2 | 1/1/2020 |
| 1 | 3/1/2020 |
| 2 | 4/1/2020 |
| 1 | 5/1/2020 |
| 2 | 5/1/2020 |
| 3 | 2/1/2020 |
i want to creat counting of how many days left to the trail (trail have 30 days per user)
i want to get in the end somting like this
| date (first log in) | 30 | 29 | 28 | 27 | 26 | 25 | ..... |
| 1/1/2020 | 2 users | 1 user | 1 user | 2 users | |||
| 2/2/2020 | 1 user |
thanks!