I want to clean or select outliers in order not to include them in my reports. The data detail is the following:
I have an excel file, a sample of which I have attached in the post.
This excel captures queries data: it records the date, the workbook (resource visited) and the Elapsed Time of each query. As the example file attached (script load):
QueryDetail:
LOAD
Date, Workbook, "Elapsed Time [seconds]" FROM [lib://QS QUESTIONS/Excel Sample Database.xlsx] (ooxml, embedded labels, table is DATABASE);
I want to DETECT the queries which are outliers per each workbook. Then, I would love to clean them from my dashboards.
I want to do it in the Data Load Editor, so to write some script that allows me to detect outliers from the table "Query Detail"
