Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
"I have case file data with interactions, and I am trying to create a histogram distribution of cases based on the number of interactions. I have grouped the number of interactions into bins. For example, the histogram shows 8 cases with 1 to 5 interactions and 4 cases with 10 to 15 interactions. I have already created a histogram using a line and clustered column chart, and now I am attempting to add a median line that represents the median of the interactions [1, 2, 15, 3, 2, 12, 5, 12, 10, 5, 6, 5, 4] is 5.5
Here is the chart I created using my real data
I would greatly appreciate any assistance.
Sample data
Case | Interactions | Date | Group |
45632 | 1 | 2/8/2023 | Sales |
68795 | 2 | 2/8/2023 | Campaign |
34522 | 15 | 2/8/2023 | Campaign |
34223 | 3 | 2/6/2023 | Campaign |
45233 | 2 | 2/6/2023 | Campaign |
44452 | 12 | 2/6/2023 | Marketing |
45323 | 5 | 2/3/2023 | Marketing |
43424 | 12 | 2/3/2023 | Marketing |
44532 | 10 | 2/3/2023 | Marketing |
55532 | 5 | 2/3/2023 | IT |
42345 | 6 | 2/4/2023 | IT |
22331 | 5 | 2/4/2024 | IT |
44214 | 4 | 2/4/2023 | IT |
Solved! Go to Solution.
@Sharma0815 , based on what I got
MedianX(Table, Table[Iteractions])
Use this in bar visual using analytics pane -> constant line - Fx option
or
Use this measure as line in combo visual
MedianX(allselected(Table), Table[Iteractions])
@Sharma0815 , based on what I got
MedianX(Table, Table[Iteractions])
Use this in bar visual using analytics pane -> constant line - Fx option
or
Use this measure as line in combo visual
MedianX(allselected(Table), Table[Iteractions])
User | Count |
---|---|
42 | |
27 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |