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.
[TABLE="width: 838"]
<tbody>[TR]
[TD="align: left"]
[/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 838"]
<tbody>[TR]
[TD="align: left"]
Code:
[TABLE="width: 838"]
<tbody>[TR]
[TD="align: left"]Affiliate[/TD]
[TD="align: left"]Credit Lead #[/TD]
[TD="align: left"]Documenter Name[/TD]
[TD="align: left"]Reviewer Name[/TD]
[TD="align: left"]Cycle Time[/TD]
[TD="align: left"]# of Internal Errors[/TD]
[TD="align: left"]# of External Errors[/TD]
[/TR]
[TR]
[TD="align: left"]FFF[/TD]
[TD="align: left"]2484[/TD]
[TD="align: left"]Pam[/TD]
[TD="align: left"]Pam[/TD]
[TD="align: right"]2:31:00[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]EEE[/TD]
[TD="align: left"]2480[/TD]
[TD="align: left"]Vanessa[/TD]
[TD="align: left"]Jennifer[/TD]
[TD="align: right"]1:44:00[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]DDD[/TD]
[TD="align: left"]2477[/TD]
[TD="align: left"]Ryan[/TD]
[TD="align: left"]Vanessa[/TD]
[TD="align: right"]2:40:00[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]EEE[/TD]
[TD="align: left"]2476[/TD]
[TD="align: left"]Jennifer[/TD]
[TD="align: left"]Anna[/TD]
[TD="align: right"]0:45:00[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]EEE[/TD]
[TD="align: left"]2473[/TD]
[TD="align: left"]Anna[/TD]
[TD="align: left"]Pam[/TD]
[TD="align: right"]4:18:00[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]FFF[/TD]
[TD="align: left"]2470[/TD]
[TD="align: left"]Oscar[/TD]
[TD="align: left"]Dwight[/TD]
[TD="align: right"]6:37:00[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]AAA[/TD]
[TD="align: left"]2465[/TD]
[TD="align: left"]Ryan[/TD]
[TD="align: left"]James[/TD]
[TD="align: right"]5:40:00[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]AAA[/TD]
[TD="align: left"]2463[/TD]
[TD="align: left"]David[/TD]
[TD="align: left"]Vanessa[/TD]
[TD="align: right"]6:45:00[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]AAA[/TD]
[TD="align: left"]2462[/TD]
[TD="align: left"]Vanessa[/TD]
[TD="align: left"]Sam[/TD]
[TD="align: right"]8:20:00[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]CCC[/TD]
[TD="align: left"]2461[/TD]
[TD="align: left"]Meredith[/TD]
[TD="align: left"]Vanessa[/TD]
[TD="align: right"]5:51:00[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: left"]CCC[/TD]
[TD="align: left"]2460[/TD]
[TD="align: left"]David[/TD]
[TD="align: left"]Vanessa[/TD]
[TD="align: right"]5:35:00[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[/TR]
</tbody>[/TABLE]