Create Chart that filters data from a list by week

(0) Share

Report

Posted on by nicktempleton2

Trying to create a chart that filters all of my task hours by week.

The tasks are a single choice on sharepoint lists, they have an amount of hours associated with it and a date

ClearCollect(
 colDate,
 AddColumns(
 GroupBy(
 Filter(
 'PSE Project Task Tracker',
 'Date of Project task time' >= _FirstDayofWeek && 'Date of Project task time' <= _FirstDayofWeek +7 && (User().Email = 'Created By'.Email)
 ),
 "Project Task1",
 "GPTask"
 ),
 "CountbyTask",
 CountRows(GPTask)
 )
);

How would i go about doing this?

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @nicktempleton2 ,

I assume the issue is the Choice column (or is there something else not working ?

ClearCollect( colDate, AddColumns( GroupBy( AddColumns( Filter( 'PSE Project Task Tracker', 'Date of Project task time' >= _FirstDayofWeek && 'Date of Project task time' <= _FirstDayofWeek + 7 && 'Created By'.Email = User().Email ), "ProjectTask", 'Project Task1'.Value ), "ProjectTask", "GPTask" ), "CountbyTask", CountRows(GPTask) ) );

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
nicktempleton2 28 on at

Like
a
(0)

Report
Copy link

Link copied!
ClearCollect( colTest, AddColumns( GroupBy( AddColumns( 'PSE Project Task Tracker', "Project Task1", 'Project Task'.Value ), "Project Task1", "GPTask" ), "CountbyTask", CountRows(GPTask) ) );
As of right now this works but when i try to filter it down to the 1 week range it stops working
WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@nicktempleton2 ,

I answered another post on this issue yesterday - try

With( {wNext: FirstDayofWeek + 7}, ClearCollect( colDate, AddColumns( GroupBy( AddColumns( Filter( 'PSE Project Task Tracker', 'Date of Project task time' >= _FirstDayofWeek && 'Date of Project task time' <= wNext && 'Created By'.Email = User().Email ), "ProjectTask", 'Project Task1'.Value ), "ProjectTask", "GPTask" ), "CountbyTask", CountRows(GPTask) ) ) );

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
nicktempleton2 28 on at

Like
a
(0)

Report
Copy link

Link copied!

That worked thank you! But how would I get the columns to show the hours spent on each task versus right now it just counts how many tasks?
Verified answer

WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@nicktempleton2 ,

Add another column

With( {wNext: FirstDayofWeek + 7}, ClearCollect( colDate, AddColumns( GroupBy( AddColumns( Filter( 'PSE Project Task Tracker', 'Date of Project task time' >= _FirstDayofWeek && 'Date of Project task time' <= wNext && 'Created By'.Email = User().Email ), "ProjectTask", 'Project Task1'.Value ), "ProjectTask", "GPTask" ), "CountbyTask", CountRows(GPTask), "TotalTasks" Sum(GPTask,YourNumberField) ) ) );

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps