Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a very simple bar graph with the below data.
Employee | Time booked |
A | 3 |
A | 2 |
A | 5 |
B | 8 |
B | 2 |
C | 4 |
C | 6 |
C | 7 |
C | 9 |
D | 1 |
D | 4 |
D | 8 |
D | 2 |
E | 6 |
In the bar graph what I need is a comparison of the average time booked by employee A versus the average time booked by all five employees. The graph should show the first bar for employee A with 3.33 value and the second bar for all five employees with value 4.78
What do I need in dimensions and how can I get two Measures from the same Time booked column, first measure being average for employee A only and second measure being the average for all employees?
Thanks
Bala
Just create a bar chart with 2 measures:
Measure 1:
Avg({<Employee={A}>}[Time booked])
Measure 2:
Depends on if you want all bookings averaged, or averaged by employee.
avg(aggr(Avg([Time booked]), Employee))
or
Avg([Time booked])
Just create a bar chart with 2 measures:
Measure 1:
Avg({<Employee={A}>}[Time booked])
Measure 2:
Depends on if you want all bookings averaged, or averaged by employee.
avg(aggr(Avg([Time booked]), Employee))
or
Avg([Time booked])
you need just the A to be compared with all the average or you want to memic this with other values also ?