I have a table of time series data tracking visits to a website, I have added calculated fields to track the standard deviation in variance between visits today and expected visits, in order to flag outliers in the data.
This is working well, but I have an issue where my most recent row (the most recent 5 minutes), is often flagged as an outlier due to having incomplete data. I’d like to exclude the most recent row from my data, however in my current setup I am only showing the most recent row in my visualization, which is the yes/no outlier indicator that my email schedule is based on.
Can anyone suggest a way I can hide the most recent row? As you can see I’ve tried adding a calculated field to highlight it, but due to this being a calculated field I can’t filter out the row.