Hi,
I am trying to write a set expression for comparing the Current Trend with the value Previous Week.
For example, on the 21-03-2020, I want to display the value on 14-03-2020 and so on for each date and each time.
My first expression is :
sum({$<[CG Metrics Metric]={'CGIn'}>}[CG Metrics Metric Value]) / 1000000000
Last Week Expression:
sum({$<[CG Metrics Metric]={'CGIn'}, [CG Metrics Timestamp]={'$(=date(Max([CG Metrics Timestamp])-7, 'DD/MM/YYYY hh:mm TT'))'} >} [CG Metrics Metric Value]) / 1000000000
This expression only creates one data point as shown in the attached. However I want to compare the values for each time and date.
TIA.
