Hello All,
I have created a card with the following fields (see Table 1) and trying to edit it using the Beast mode. I am basically looking for help to filter rows the courses last access by a user with the number of days (Today’s Date - DayAccessed). Below is a user “John Doe” who accessed two courses on three different days.
Table 1
FirstName | LastName | CourseName | DayAccessed |
John | Doe | Fall 2020 CIS 101 | 2020-11-21 00:00:0000 |
John | Doe | Fall 2020 CIS 101 | 2020-11-20 00:00:0000 |
John | Doe | Fall 2020 CIS 101 | 2020-11-19 00:00:0000 |
John | Doe | Fall 2020 BIO 222 | 2020-11-19 00:00:0000 |
John | Doe | Fall 2020 BIO 222 | 2020-11-17 00:00:0000 |
John | Doe | Fall 2020 BIO 222 | 2020-11-16 00:00:0000 |
Result will look like this table 2 (below) showing:
- Only the row that includes the last day the user accessed each course
- A new additional column (DaysAccessed) containing the number of days since last accessed
- Plus change the DayAccessed field from “2020-11-21 00:00:0000” to “2020-11-21”
Table 2
FirstName | LastName | CourseName | DayAccessed | DaysAccessed |
John | Doe | Fall 2020 CIS 101 | 2020-11-21 | 4 |
John | Doe | Fall 2020 BIO 222 | 2020-11-19 | 6 |
Thanks in advance.
Syed