Average of top deals by sales rep?

edit filter action

Average of top deals by sales rep?
Ans:
1. Drag Longitude (Generated) into Columns.
2. Drag Latitude (Generated) into Rows.
3. Drag country into Details at marks cards.
4. And select the Map type is Filed Map.
5. Create a calculated field as Largest Sales Deal by Rep as shown below
{INCLUDE [Sales Rep]: MAX([Sales])}
6. Now Drag Largest Sales Deal by Rep into Color self and select the aggregation as AVG.
7. The visualization looks like below.

filed map

Sheet 3#
1. Drag Sales into Columns and select the aggregation as MAX.
2. Drag Sales Rep into Rows and right click on it and select the sort, in that give the fields like below.

drag sales rep

3. Create a calculation for conditional formatting.
Max(Sales) > WINDOW_AVG(MAX(Sales))
4. Now drag above calculation into color shelf at marks card level.
5. Right click on the Max Sales Header and select the A dd Reference Line.

edit reference lines

6. The visualization will look like below.

Average of top deals by sales rep

Dashboard 1
1. Drag the Sheet 2 into dashboard visualization area.
2. Drag the Sheet 3 Horizontally into dashboard visualization area.

dashboard 1

3. Now create a Filter Action as shown below.

edit filter action

And check the actions are working or not.

Leave a Reply

Your email address will not be published. Required fields are marked *