Hi all,
I have documents which include a count
field (numbers). I want to implement a dashboard, in which based on the selected timerange, the difference of the first document's count
value and the last documents count
value is displayed. (Kind of a trend metric, which shows how much the values decreased/increased during the selected time frame).
I'm currently only able to show static trends with the following formula: last_value(count)- last_value(count,shift='7d')
However I need the value to be calculated based on the selected time frame and unfortunately there is no function such as first_value()
Are there any solutions to those requirements?
Thanks in advance