Hello, I’ve created what is essentially a task tracking app for my company. I have figured out how to filter per user so they can see their total tracking for the year, month, week, day ect. But what I am trying to figure out and struggling is how to total in a numeric value total for each activity, there are 4 activities per user, like this week you did a total of 5 hours of admin time. when I tried it pulls all the information for everyone and not per user.
Do you have any relations or queries that you use for your filter that you can point your Rollup to? If you create a query linking the activity and user for example, you can have your Rollup use that Query to get a total sum.
Hi Jeff, thank you for this, I think this will work. Do I put that in my worker table (where I currently have my month, week, day filter) or in their user profiles or in the task list data.
I guess it depends on how you intend to display the information. If it’s on the screen that contains the filters, as a summary based on the filters, then I would probably say the worker table. If it’s in a collection, then maybe you need it in the task table. I’m guessing you wouldn’t do it in the user table, but I’d probably need a better visual of your data and screen layouts and how it all works currently.
2 Likes