View anomalies in table structure

Question & Answer
, ,
1

Is it possible to show anomaly detail in a table format?

2

Not currently.

You might look to do this manually. You could look at conditional formatting and creating a calculated field / sql that can flag for an anomaly.

You could look at percentiles to add a rule.

3

Thanks. Is the feature on your product roadmap?

Using a percentile, would not be using RCF, right? It would say that any % greater than or less than a range based on expected value from ETS or ARIMA?

If I were to use percentiles to add a rule (calculated field), how would that look?

4

I don’t know if its on the product roadmap.

Here is how a flag could work. You can substitute {int_bearable} with you numeric field. This could also be a count or other aggregation.

ifelse({int bearable}> percentileDiscOver({int bearable},80,,PRE_AGG),‘Flag’,‘Do not’)

From there, you make a conditional format on the table.

image
image1735×1114 90.8 KB

One thing to note you will need to add the field into your table, but you can hide that field.