Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey everyone,
I have new mission and need your help .
My data based on open cases that divided to seveirties(1 high - 3 low), the CTO defindes cases SLA eg: if case defined as high the resolving time of that specific case is no longer than 24 days. It's a binaric situation in case we exceeded that period IsExceeding=1. in case we didn't it will be 0.
I need to present accumolate exceeding cases per month - stacked column chart that presents 3 layers of the severities.
Here's what I did,
As you can see what happened here is that if in total i have 102 exceeding cases the chart shows how much belongs to each month and doesnt shows me accumolate cases.
I mean I need to see in fabruary 2017 overall view of how much cases is exceeding until 31.2.17 - is should sum all open exceeding cases for last X months and shows how much did it collect until the 31.2 and divide it to severity type (high-low).
here's my data:
Your requirement is not quite clear for me. Based on my understanding, it looks that you're looking for a measure like
Acc exceeding cases = COUNTROWS ( FILTER ( yourTable, yourTable[createon] <= MAX ( yourTable[createon] ) && yourTable[isExceed] = 1 ) )
By the way, could you please post the sample data in plain text, the picture doesn't help too much.
Hi @Eric_Zhang,
I already used this messaure.
It doesnt answer my dashboard needs, lets say today we have 100 exceeding cases that are still open.
I want to see the trend in monthly view,
current result = power bi takes 100 cases spred them by the creation month and give me a view of how many exceeding case from january,feb,march.... I dont care how much from each month I care to see the trend over time.
heres a glanss of the data:
createdon | Acc exceeding cases | severitycodename |
29/02/2016 15:03 | 1 | Severity 2 - Medium |
15/03/2016 08:56 | 1 | Severity 2 - Medium |
18/03/2016 14:16 | 1 | Severity 3 - Low |
18/03/2016 14:47 | 1 | Severity 2 - Medium |
14/04/2016 12:50 | 1 | Severity 2 - Medium |
15/04/2016 08:25 | 1 | Severity 2 - Medium |
22/04/2016 08:51 | 1 | Severity 2 - Medium |
06/05/2016 14:26 | 1 | Severity 2 - Medium |
09/05/2016 15:20 | 1 | Severity 2 - Medium |
16/05/2016 10:55 | 1 | Severity 2 - Medium |
16/05/2016 10:59 | 1 | Severity 3 - Low |
16/05/2016 11:05 | 1 | Severity 2 - Medium |
17/05/2016 13:27 | 1 | Severity 2 - Medium |
30/05/2016 05:04 | 1 | Severity 2 - Medium |
30/05/2016 05:37 | 1 | Severity 2 - Medium |
02/06/2016 13:16 | 1 | Severity 2 - Medium |
03/06/2016 14:28 | 1 | Severity 2 - Medium |
06/06/2016 15:42 | 1 | Severity 2 - Medium |
07/06/2016 08:33 | 1 | Severity 2 - Medium |
08/06/2016 12:29 | 1 | Severity 2 - Medium |
08/06/2016 12:35 | 1 | Severity 2 - Medium |
09/06/2016 12:38 | 1 | Severity 2 - Medium |
10/06/2016 07:43 | 1 | Severity 2 - Medium |
14/06/2016 11:43 | 1 | Severity 2 - Medium |
15/06/2016 09:33 | 1 | Severity 2 - Medium |
21/06/2016 07:39 | 1 | Severity 2 - Medium |
21/06/2016 14:19 | 1 | Severity 1 - High |
24/06/2016 10:31 | 1 | Severity 2 - Medium |
27/06/2016 10:23 | 1 | Severity 2 - Medium |
27/06/2016 10:29 | 1 | Severity 2 - Medium |
29/06/2016 14:57 | 1 | Severity 2 - Medium |
29/06/2016 14:59 | 1 | Severity 1 - High |
30/06/2016 07:31 | 1 | Severity 1 - High |
30/06/2016 10:46 | 1 | Severity 1 - High |
30/06/2016 18:33 | 1 | Severity 2 - Medium |
30/06/2016 19:50 | 1 | Severity 2 - Medium |
04/07/2016 09:46 | 1 | Severity 2 - Medium |
05/07/2016 09:26 | 1 | Severity 2 - Medium |
08/07/2016 09:11 | 1 | Severity 1 - High |
08/07/2016 09:28 | 1 | Severity 2 - Medium |
11/07/2016 14:39 | 1 | Severity 2 - Medium |
11/07/2016 14:44 | 1 | Severity 3 - Low |
19/07/2016 18:11 | 1 | Severity 1 - High |
20/07/2016 19:25 | 1 | Severity 2 - Medium |
21/07/2016 07:10 | 1 | Severity 2 - Medium |
22/07/2016 12:50 | 1 | Severity 2 - Medium |
22/07/2016 13:21 | 2 | Severity 2 - Medium |
23/07/2016 16:10 | 1 | Severity 2 - Medium |
27/07/2016 08:25 | 1 | Severity 2 - Medium |
27/07/2016 09:03 | 1 | Severity 2 - Medium |
27/07/2016 15:11 | 1 | Severity 2 - Medium |
29/07/2016 13:07 | 1 | Severity 2 - Medium |
29/07/2016 13:51 | 1 | Severity 2 - Medium |
29/07/2016 14:00 | 1 | Severity 2 - Medium |
29/07/2016 14:08 | 1 | Severity 2 - Medium |
01/08/2016 11:19 | 1 | Severity 2 - Medium |
01/08/2016 11:33 | 1 | Severity 2 - Medium |
02/08/2016 13:29 | 1 | Severity 2 - Medium |
03/08/2016 21:30 | 1 | Severity 2 - Medium |
08/08/2016 21:22 | 1 | Severity 2 - Medium |
10/08/2016 15:39 | 1 | Severity 2 - Medium |
17/08/2016 20:39 | 1 | Severity 2 - Medium |
22/08/2016 13:48 | 1 | Severity 2 - Medium |
26/08/2016 19:47 | 1 | Severity 2 - Medium |
09/09/2016 10:13 | 1 | Severity 2 - Medium |
13/09/2016 10:54 | 1 | Severity 3 - Low |
14/09/2016 09:23 | 1 | Severity 1 - High |
19/09/2016 11:09 | 1 | Severity 2 - Medium |
19/09/2016 19:23 | 1 | Severity 2 - Medium |
21/09/2016 19:21 | 1 | Severity 2 - Medium |
22/09/2016 09:42 | 1 | Severity 2 - Medium |
23/09/2016 09:25 | 1 | Severity 2 - Medium |
27/09/2016 15:31 | 1 | Severity 2 - Medium |
@Noak wrote:
Hi @Eric_Zhang,
I already used this messaure.
It doesnt answer my dashboard needs, lets say today we have 100 exceeding cases that are still open.
I want to see the trend in monthly view,
current result = power bi takes 100 cases spred them by the creation month and give me a view of how many exceeding case from january,feb,march.... I dont care how much from each month I care to see the trend over time.
What do you mean a trend then? May be a increasing or dropping percentage of each month?
@v-lvzhan-msft wrote:What do you mean a trend then? May be a increasing or dropping percentage of each month?
I mean if increasing @Eric_Zhang. do you have any solution for that?
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |