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
