Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
avg({<period={'>$(=date($(vmaxperiod)-$(vdays))) <=$(=date($(vmaxperiod)))'} >}merticvalue/(100000))
-(minus)
avg({<period={'>$(=date($(vmaxperiod)-$(vdays))) <=$(=date($(vmaxperiod)))'} >}previousmerticvalue/(100000))
here
ex:
metricvalue:
day1,100
day2,200
day3,300
previous metric value means i want like
metric value is day1 then previous metric value is 0
metric value is day2 then previous metric value is 1
metric value is day3 then previous metric value is 2
i have only field is metricvalue from this i have calculate prvious metric value
i have tried above function its not working
give me some idea when metricvalue is day1 iwant prev metricvalue is 0
metricvalue is day2 iwant prev metricvalue is day1
metricvalue is day3 iwant prev metricvalue is day2
got it