Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

PowerApp gallery with Groupby, filter, sortbycolumns and sum

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")

 

raneesh_mr_0-1652423159352.png

 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Syndicate_Admin ,

     

    You could directly create a Matrix visual to get such output:

    Then apply [Date to Activity] field to slicer, select Relative Date type to remain last 7 days:

     

     


    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.