Hi guys,
I've only just started visualizing some data for my work and I was hoping someone could advise how to best go about this request:
- For each error code there is a comparison count of Current Day errors to daily Average using previous 7 days.
So in my data, every document has an error code associated with it (0 being no error).
Is there a nice way to visualize this data? perhaps in a data table? I know I need to split the data on the errorNo term however I am a bit lost trying to figure out which type of bucket aggregation I should be using to do the comparison of current day to the past 7 days daily average.
My first guess is something with the Average Bucket aggregation type but I don't know what Sub Aggregation would be correct.
Any tips?
Thank you