real-time-intelligence-operations-solution-accelerator/src/kql/data_analysis/find_defect_probability_range.kql at 4b2e20c8b46861b90cd76d2a77f17e18b2800b68 · microsoft/real-time-intelligence-operations-solution-accelerator · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
//Raw data range for setting activator rules

events
| summarize
    MinDefectProbability = min(DefectProbability),
    MaxDefectProbability = max(DefectProbability),
    AvgDefectProbability = avg(DefectProbability),
    MedianDefectProbability = percentile(DefectProbability, 50),
    P90DefectProbability = percentile(DefectProbability, 90),
    P95DefectProbability = percentile(DefectProbability, 95),
    P97DefectProbability = percentile(DefectProbability, 97),
    P99DefectProbability = percentile(DefectProbability, 99),
    P99_5DefectProbability = percentile(DefectProbability, 99.5),
    P10DefectProbability = percentile(DefectProbability, 10),
    P8DefectProbability = percentile(DefectProbability, 8),
    P5DefectProbability = percentile(DefectProbability, 5),
    TotalEvents = count(),
    NonZeroEvents = countif(DefectProbability > 0)
| project
    Metric = "DefectProbability Analysis",
    MinDefectProbability = round(MinDefectProbability, 6),
    MaxDefectProbability = round(MaxDefectProbability, 6),
    AvgDefectProbability = round(AvgDefectProbability, 6),
    MedianDefectProbability = round(MedianDefectProbability, 6),
    P99_5DefectProbability = round(P99_5DefectProbability, 6),
    P99DefectProbability = round(P99DefectProbability, 6),
    P97DefectProbability = round(P97DefectProbability, 6),
    P95DefectProbability = round(P95DefectProbability, 6),
    P90DefectProbability = round(P90DefectProbability, 6),
    P10DefectProbability = round(P10DefectProbability, 6),
    P8DefectProbability = round(P8DefectProbability, 6),
    P5DefectProbability = round(P5DefectProbability, 6),
    TotalEvents,
    NonZeroEvents