Hello.
I'm trying to get the maximum value of the sum doc_count but using a max_bucket aggregation it either reaches the maximum number of buckets (error: "too_many_buckets_exception"), or it ajusts the timerange to be per hour and does not give me the value I want.
What I need is the equivalent of the "Normalize: per second" option but instead of getting the average, getting the maximum. So that if the visualization auto scales the horizontal axis to be my timefield per hour instead of per second, at least give me the maximum sum of documents that a second has in that hour.
For example if in an hour I have a second when the doc_count is 10 and in every other second of that hour the doc_count is smaller, I want the visualization to show 10 for that hour.
How can I do this?
I can use any type of visualization. If this is possible with any of the default visualization that would be prefered but if I need to do this with a custom plugin visualization can you tell me how to create a something like that please?
Thank you so much in advance.