Hello,
I'm a beginner with Kibana. Now, I tried to make dashboard with hourly data.
My problem is visualization.
For example, every hour, 100 data comes in.
I want to sum up only the top five values. The problem is that the (current) time can be easily obtained as a top hit, while setting the Time Picker to Today will show the sum of the top five values of the entire day.
I want to show the cumulative sum of the top five values out of the 100 that come in every hour up to the current time.
From the first image, I can have the value in total.
I want to show the value in metric visualization because I want to add my dashboard.
Even if not in metric visualization will be fine, I just want to show total value in my dashboard.
How can I solve this problem?
I'm not a native English speaker, so if you can't understand please let me know.
I will do my best to explain again.
Thank you so much!