# How to get sum of some last values correctly in KIBANA
**URL:** https://discuss.elastic.co/t/how-to-get-sum-of-some-last-values-correctly-in-kibana/317878
**Category:** Kibana
**Created:** [November 1, 2022, 9:05am UTC](https://discuss.elastic.co/t/how-to-get-sum-of-some-last-values-correctly-in-kibana/317878 "2022-11-01T09:05:32Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Joko\_Eliyanto](https://discuss.elastic.co/u/Joko_Eliyanto)
#### Post date: [November 1, 2022, 9:05am UTC](https://discuss.elastic.co/t/how-to-get-sum-of-some-last-values-correctly-in-kibana/317878/1 "2022-11-01T09:05:32Z")
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?
---
### Author:  [@Davis\_McPhee](https://discuss.elastic.co/u/Davis_McPhee)
#### Post date: [November 2, 2022, 2:33am UTC](https://discuss.elastic.co/t/how-to-get-sum-of-some-last-values-correctly-in-kibana/317878/2 "2022-11-02T02:33:27Z")
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:
---
### Author:  [@Joko\_Eliyanto](https://discuss.elastic.co/u/Joko_Eliyanto)
#### Post date: [November 2, 2022, 6:47am UTC](https://discuss.elastic.co/t/how-to-get-sum-of-some-last-values-correctly-in-kibana/317878/3 "2022-11-02T06:47:04Z")
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?
---
### Author:  [@Davis\_McPhee](https://discuss.elastic.co/u/Davis_McPhee)
#### Post date: [November 2, 2022, 4:51pm UTC](https://discuss.elastic.co/t/how-to-get-sum-of-some-last-values-correctly-in-kibana/317878/4 "2022-11-02T16:51:50Z")
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](https://github.com/elastic/kibana/pull/136706). 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:
---
### Author:  [@Joko\_Eliyanto](https://discuss.elastic.co/u/Joko_Eliyanto)
#### Post date: [November 3, 2022, 4:37am UTC](https://discuss.elastic.co/t/how-to-get-sum-of-some-last-values-correctly-in-kibana/317878/5 "2022-11-03T04:37:25Z")
Thanks Davis, the last answer was solution for my problem, once again
Terima Kasih (Thanks in Bahasa Indonesia)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 1, 2022, 4:37am UTC](https://discuss.elastic.co/t/how-to-get-sum-of-some-last-values-correctly-in-kibana/317878/6 "2022-12-01T04:37:47Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.