I have see a few older questions on something like this but nothing too new. I have a table right now we manually generate using a number of searches; getting data for the past few weeks. Using this as a way to identify trends and find items with low volume or long response times. Using predict would greatly reduce this need but, I would need a split by clause.
In Short I am getting something like
| _time | Volume | low(predicted(Volume) | high(predicted(Volume) | ResponseTime | low(predicted(ResponseTime) | high(predicted(ResponseTime) |
What I would like is.
| Operation | Volume | low(predicted(Volume) | high(predicted(Volume) | ResponseTime | low(predicted(ResponseTime) | high(predicted(ResponseTime) |
| op1 | 10 | 4 | 15 | 9 | 5 | 15 |
| op2 | 5 | 2 | 9 | 5 | 1 | 10 |
I am tabling the data so I would only have one entry for each operation. I want it to show an overview of the operations using the predicted values for context and then I would create formatting if they are outside some bounds of the predicted value.
