Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I'm starting to use Power Bi and I need some help with an analysis:
- I have a database of users making queries in a system. The database shows the time it takes to process the query (Elapsed Time) so I need to build a monthly percentile, a boxplot, excluding the 10% queries with the HIGHEST and LOWEST of Elapsed Time, in order to get an Average which is not affected by this bias.
- It would be great if is a boxplot like in the image of the link I paste below.
- I also paste an example of the database.
Database:
Date | User | Workbook (query) | Elapsed Time |
10/1/2019 | UKN1 | Demand Review | 0.20 |
10/2/2019 | UKN2 | Demand Review | 0.23 |
10/3/2019 | UKN3 | Demand Review | 0.00 |
10/4/2019 | UKN4 | Demand Review | 0.32 |
10/15/2019 | UKN5 | Demand Review | 0.27 |
10/16/2019 | UKN6 | Demand Review | 0.22 |
10/27/2019 | UKN7 | Demand Review | 50.34 |
10/28/2019 | UKN8 | Demand Review | 30.40 |
10/29/2019 | UKN9 | Demand Review | 0.50 |
10/30/2019 | UKN10 | Demand Review | 0.00 |
Boxplot:
https://towardsdatascience.com/understanding-boxplots-5e2df7bcbd51
Thanks in advance,
kr, Roger
Hi @torraro ,
I check power bi visuals but haven't found any visual can show boxplot, I'd like to suggest you refer to your link to create an r visual with r script to manually draw boxplot graph.
Create Power BI visuals using R
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |