Good morning,
I am working on preparing a scorecard for our team, and what I want to create is a dashboard where we can select a user via a drop down, and it will update the scorecard for that user.
There are 3 data points that we are looking at for performance: 1) Cycle time 2) External quality and 3) Internal quality. I have a slicer for internal quality and external quality (both are # of errors), a timeline that is connected to all 3 pivots, and those are easy enough. If I add the cycle time pivot as a connection on the Documenter/Reviewer slicers, when I select the user's name on both slicers, it will only show me data for rows that they fit both criteria, which is rare.
What I am trying to accomplish is for cycle time to see any deal they were a part of, whether they were a documenter or reviewer, and have the cycle time graph show the average time of any deal that they were working. Below is a sample of the data I am working with.
Is what I am trying to do impossible? If it is possible, I am not looking for the full solution (as I want to do the work), I just need a general direction of how to accomplish this.
<tbody> </tbody>
I am working on preparing a scorecard for our team, and what I want to create is a dashboard where we can select a user via a drop down, and it will update the scorecard for that user.
There are 3 data points that we are looking at for performance: 1) Cycle time 2) External quality and 3) Internal quality. I have a slicer for internal quality and external quality (both are # of errors), a timeline that is connected to all 3 pivots, and those are easy enough. If I add the cycle time pivot as a connection on the Documenter/Reviewer slicers, when I select the user's name on both slicers, it will only show me data for rows that they fit both criteria, which is rare.
What I am trying to accomplish is for cycle time to see any deal they were a part of, whether they were a documenter or reviewer, and have the cycle time graph show the average time of any deal that they were working. Below is a sample of the data I am working with.
Is what I am trying to do impossible? If it is possible, I am not looking for the full solution (as I want to do the work), I just need a general direction of how to accomplish this.
Code:
|
<tbody> </tbody>