Metric Widget pulling data from a report
My objective is to create a dashboard where user can see the count of his/her tasks by status: On Track (green), Concern (yellow), At Risk (Red), and Completed (Gray).
Each status is a presented as a metric widget. When user clicks a certain metric widget (i.e. red - tasks at risk), a DynamicView window opens and pulls up the list of said tasks.
The summary dashboard will be accessible to users via Teams, as tab in the respective project’s Team.
I know how to make everything work, except for loading the count of tasks in the metric widgets. In my design, these counts are pulled in a report which has a Contact field filter set to Current User.
It seems a very obvious and ordinary use case, but I couldn’t find a solve for it. I hope somebody here may point me in the right direction.
Help Article Resources
Check out the Formula Handbook template!