You’re offline. This is a read only version of the page.
Announcements
55
I have table to track total tasks by staff.
I need a gallery to show past 7 days total tasks by Staff and Task type. the gallery need to order highest total task by person on top.
I used below however the filter is not working also unable to figure out how to sort by columns.
I used "AddColumns" because the "Person" column was not visible to Group.
GroupBy(Filter(AddColumns(
'Activities monitor',"StaffName",Person.DisplayName,"TotalTask",Sum(Total,0)), DateDiff('Date of Activity',Today(),Days)>=7), "StaffName","DATA")
Share
Report
All responses (
Answers (
