How to get sum of some last values correctly in KIBANA

I am a new user in KIBANA dashboard, I just want to create a card that contain sum of certain days last value(for example 1day, 2day, 3day or so on). I think I can get the result I need by change the last value interval in option menu, but I got the wrong result. Am I have miss understanding of Bucketing Concept in Elasticsearch or is it any something wrong?

Hi @Joko_Eliyanto, I can't tell exactly how your visualizations are set up, but if I'm understanding your request correctly, I was able to set up a similar dashboard using a combination of a Legacy Metric visualization with the Sum function, and the 'Reduced time range' advanced option. Here's a quick GIF showing what I came up with:

Thanks Davis for the answer, it match with my need. But why I cant find the 'Reduced time range' advance option in my KIBANA, is it any some setting or certain license?

I probably should have asked which version of Kibana you were using first. The option I suggested was only recently released in 8.5: [Lens] Add reduced time range option by flash1293 · Pull Request #136706 · elastic/kibana · GitHub. If you're using an older 8.x release and aren't able to upgrade to 8.5, an alternative that might work for you is the 'Customize time range' option in the Dashboard panel options menu. Here's another quick example:

Thanks Davis, the last answer was solution for my problem, once again

Terima Kasih (Thanks in Bahasa Indonesia)

1 Like

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.