I have a list in sharepoint an want to display sum of users workhouers pr. project for logedin user.
The table look like this:
When user1 start the app i want to display in a gallery, his workhouers.
like this
Any ideas?
Solved! Go to Solution.
You can utilize the GroupBy function for this and then add a column to your resultant table with the sum.
Ex.
AddColumns(
GroupBy(
Filter(yourDataTable, user=loggedInUserName),
"user",
"_recs"
),
"hourSum", Sum(_recs, hours)
)
I hope this is helpful for you.
You can utilize the GroupBy function for this and then add a column to your resultant table with the sum.
Ex.
AddColumns(
GroupBy(
Filter(yourDataTable, user=loggedInUserName),
"user",
"_recs"
),
"hourSum", Sum(_recs, hours)
)
I hope this is helpful for you.
Fantasic 🙂
but i gruped by project 😉
now im going to sort witch projects i have worked on an how many houers each day 😉
Yes, sorry, I meant to group by Project and not user.
For the daily sums, you will need to employ the same grouping concept except you will group on the Date instead.
User | Count |
---|---|
157 | |
86 | |
68 | |
63 | |
61 |
User | Count |
---|---|
211 | |
152 | |
93 | |
81 | |
70 |