# Use Ratio between average metrics **URL:** \ **Category:** Kibana\ **Created:** [May 2, 2020, 7:56pm UTC](https://discuss.elastic.co/t/use-ratio-between-average-metrics/230826 "2020-05-02T19:56:39Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![filleul\_thierry](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/filleul_thierry/32/47627_2.png) [@filleul\_thierry](https://discuss.elastic.co/u/filleul_thierry)\ **Post date:** [May 2, 2020, 7:56pm UTC](https://discuss.elastic.co/t/use-ratio-between-average-metrics/230826/1 "2020-05-02T19:56:39Z")
Hello I try to make a ratio between 2 metrics during a period. 1 - sum aggregation of server RAM Used 2 - sum aggregation of server Ram capacity I did it with TSVB and bucket aggregation and it works but il would like to export these informations in csv so i try to do it with Data Table TSVB or TimeLion make a such operation for a given date. I would like to do it for a specified duration. Could you give me tips to do it un DataTable ? In fact if i could use a Bucket aggregation in a Kibana visualisation like DataTable i could fix my problem ---
**Author:** ![Luca\_Belluccini](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/luca_belluccini/32/33239_2.png) [@Luca\_Belluccini](https://discuss.elastic.co/u/Luca_Belluccini)\ **Post date:** [May 2, 2020, 11:07pm UTC](https://discuss.elastic.co/t/use-ratio-between-average-metrics/230826/2 "2020-05-02T23:07:26Z")
Hello @filleul_thierry Unfortunately the bucket script aggregation is available only on TSVB or on Canvas. Both options do not allow to export to CSV file. We have already 2 issues on Kibana to track this: - [https://github.com/elastic/kibana/issues/4707](https://github.com/elastic/kibana/issues/4707) (specific to bucket aggregations) - [https://github.com/elastic/kibana/issues/58628](https://github.com/elastic/kibana/issues/58628) (bucket aggregations status per visualization) - [https://github.com/elastic/kibana/issues/30982](https://github.com/elastic/kibana/issues/30982) TSVB Table to CSV At the moment, you might take a look to this community plugin: [https://github.com/fbaligand/kibana-enhanced-table](https://github.com/fbaligand/kibana-enhanced-table) I am sure it allows to display a ratio between columns, but I am not 100% sure it allows to export to CSV. ---
**Author:** ![filleul\_thierry](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/filleul_thierry/32/47627_2.png) [@filleul\_thierry](https://discuss.elastic.co/u/filleul_thierry)\ **Post date:** [May 3, 2020, 2:48pm UTC](https://discuss.elastic.co/t/use-ratio-between-average-metrics/230826/3 "2020-05-03T14:48:35Z")
Thank You very much Luca I try the plugin Enhanced Table it works fine and you can export the data with csv. May be a such plugin could be proposed by Elastic. I will track the bucket aggregation feature in Data Table visualization Regarding the csv option i would like to automatise csv export in Data Table but i think i need XPack plugin because i don't find a such option for my version. ---
**Author:** ![Luca\_Belluccini](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/luca_belluccini/32/33239_2.png) [@Luca\_Belluccini](https://discuss.elastic.co/u/Luca_Belluccini)\ **Post date:** [May 15, 2020, 12:09am UTC](https://discuss.elastic.co/t/use-ratio-between-average-metrics/230826/4 "2020-05-15T00:09:26Z")
Hello @filleul_thierry You need an X-Pack basic license to be able to export in CSV ([https://www.elastic.co/subscriptions](https://www.elastic.co/subscriptions)). To automate the triggering of the report within Elasticsearch, you need Watcher which is available only in Trial, Gold, Platinum or Enterprise. This means Watcher is included in [Elastic Cloud](https://www.elastic.co/cloud/). To automate the process from outside Elasticsearch, you can use this menu. ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/2/d2974fc617a659533a42114c4d935b06d1571e83.png) Once you `Copy POST URL`, you can write a script which calls Kibana via `curl` or any HTTP client. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 12, 2020, 12:09am UTC](https://discuss.elastic.co/t/use-ratio-between-average-metrics/230826/5 "2020-06-12T00:09:27Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.