Forum Discussion
Using clustered chart column to display calculated measure
Apologies, I don't think I explained my ask clearly. I have since been able to resolve my issue. My ask was:
1. To get an overall service level as a % for the month
2. Get a view of the same measure across the various workstreams.
What was lacking from my original dataset was essentially some calendar data & the service availability of the team across each day. I created a table, sample below, and created the relationship between a 'Opened MonthYear' column in each.
Date Month MonthNo AvailableMins 01/11/2019 00:00 November 1 900 02/11/2019 00:00 November 1 900 03/11/2019 00:00 November 1 900 04/11/2019 00:00 November 1 900 05/11/2019 00:00 November 1 900 06/11/2019 00:00 November 1 900 07/11/2019 00:00 November 1 900 The measure I used to get this was:
Measure: 1 - (SUM('ServiceOps - Incident Mgmt'[TimeDiffMin])) / SUM(CalendarData[AvailableMins])I'm sure there's a more efficient way of getting to the same outcome, but I think I got there eventually! Screenshot of output available at link below:
Apologies, I don't think I explained my ask clearly. I have since been able to resolve my issue. My ask was:
1. To get an overall service level as a % for the month
2. Get a view of the same measure across the various workstreams.
What was lacking from my original dataset was essentially some calendar data & the service availability of the team across each day. I created a table, sample below, and created the relationship between a 'Opened MonthYear' column in each.
| Date | Month | MonthNo | AvailableMins |
| 01/11/2019 00:00 | November | 1 | 900 |
| 02/11/2019 00:00 | November | 1 | 900 |
| 03/11/2019 00:00 | November | 1 | 900 |
| 04/11/2019 00:00 | November | 1 | 900 |
| 05/11/2019 00:00 | November | 1 | 900 |
| 06/11/2019 00:00 | November | 1 | 900 |
| 07/11/2019 00:00 | November | 1 | 900 |
The measure I used to get this was:
Great P0werB1User , glad you got that resolved!