Show dynamic trend values in Dashboard

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

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.