# Trends metric, it's possible?
**URL:** https://discuss.elastic.co/t/trends-metric-its-possible/168059
**Category:** Kibana
**Created:** [February 12, 2019, 3:09pm UTC](https://discuss.elastic.co/t/trends-metric-its-possible/168059 "2019-02-12T15:09:20Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Aurelien1609](https://discuss.elastic.co/u/Aurelien1609)
#### Post date: [February 12, 2019, 3:09pm UTC](https://discuss.elastic.co/t/trends-metric-its-possible/168059/1 "2019-02-12T15:09:20Z")
Hi,
I want to create a metric in kibana dashboard, which use ratio of multiple metrics and offset period.
Example :
Date Budget
(YYYY-MM-DD) $
2019-01-01 15
2019-01-02 10
2019-01-03 5
2019-01-04 10
2019-01-05 12
2019-01-06 4
If I select time range between 2019-01-04 to 2019-01-06 , I want to compute ratio with offset period: 2019-01-01 to 2019-01-03.
to resume : (sum(10+12+4) - sum(15+10+5)) / sum(10+12+4) = -0.15
evolution of my budget equal to -15% (and this is what I want to print in the dashboard)
But, with metric it's not possible (no offset), with visual builder: different metric aggregation do not have different offset (too bad because bucket script allow to compute ratio), and with vega : I not found a solution too.
Any idea ? Thanks a lot
Aurélien
---
### Author:  [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [February 22, 2019, 11:31am UTC](https://discuss.elastic.co/t/trends-metric-its-possible/168059/2 "2019-02-22T11:31:14Z")
I don't really think you can do that for now. Maybe using Canvas SQL expressions would work.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 22, 2019, 11:31am UTC](https://discuss.elastic.co/t/trends-metric-its-possible/168059/3 "2019-03-22T11:31:23Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.