# Calculating the sum of latest values - Timelion/Kibana
**URL:** https://discuss.elastic.co/t/calculating-the-sum-of-latest-values-timelion-kibana/109894
**Category:** Kibana
**Tags:** timelion
**Created:** [December 1, 2017, 8:37am UTC](https://discuss.elastic.co/t/calculating-the-sum-of-latest-values-timelion-kibana/109894 "2017-12-01T08:37:47Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@emil.mirzayev](https://discuss.elastic.co/u/emil.mirzayev)
#### Post date: [December 1, 2017, 8:37am UTC](https://discuss.elastic.co/t/calculating-the-sum-of-latest-values-timelion-kibana/109894/1 "2017-12-01T08:37:47Z")
Hey there!
I am new to ELK stack. I have the data of measurements of different devices by time. Every 15 min, I get new values per each device (and value in t is always bigger or equal to value in t-1). What I want to do, is to calculate the sum of the latest values of each device within a given time period. Is it possible to do in Timelion or Kibana directly? My data structure is like this:
timestamp; device\_id; value
timestamp; device\_id; value
timestamp+15min; device\_id; value
timestamp+15min; device\_id; value
Edit: Docouments are in one index named "measurements".
---
### Author:  [@LeeDr](https://discuss.elastic.co/u/LeeDr)
#### Post date: [December 1, 2017, 10:07pm UTC](https://discuss.elastic.co/t/calculating-the-sum-of-latest-values-timelion-kibana/109894/2 "2017-12-01T22:07:57Z")
Hi Emil,
My first thought would be a Data Table visualization like this;
I used Metric = max bytes, but you would use your `value` I think.
And then I split rows with a Terms aggregation by extension.raw, but you would use your `device_id` for that.
Let me know if that works for you.
Regards,
Lee
---
### Author:  [@emil.mirzayev](https://discuss.elastic.co/u/emil.mirzayev)
#### Post date: [December 4, 2017, 8:45am UTC](https://discuss.elastic.co/t/calculating-the-sum-of-latest-values-timelion-kibana/109894/3 "2017-12-04T08:45:05Z")
Hi Lee,
looks like it is what I need. I think after having lots of devices, showing only the top -n- won't be the best possibility. Is it possible also to remove the limitation? I can put it to 100 or 1000, but it would be great to know how to remove it
EDIT: Is it also possible to have timestamp field in the table? I want to show the value graph by time per each device?
best,
Emil
---
### Author:  [@LeeDr](https://discuss.elastic.co/u/LeeDr)
#### Post date: [December 5, 2017, 11:04pm UTC](https://discuss.elastic.co/t/calculating-the-sum-of-latest-values-timelion-kibana/109894/4 "2017-12-05T23:04:19Z")
In Management \> Advanced Settings there's this setting;
metrics:max\_buckets
The maximum number of buckets a single datasource can return
default value is 2000
You could increase that, but you might have performance issues or use a lot of memory on your Elasticsearch node(s) and/or your Kibana server.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 2, 2018, 11:04pm UTC](https://discuss.elastic.co/t/calculating-the-sum-of-latest-values-timelion-kibana/109894/5 "2018-01-02T23:04:44Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.