Hello. I have a collection of gauges that need to display the previous day’s metrics. This is fine using a filter set to “previous day” except for Monday, when I need to show a sum of Friday, Saturday and Sunday’s numbers. I have been playing around with parameters and filters and the “addDateTime…

@jayrey48 Can you wrap it in an ifelse and use firstValue and then depending on the value change the look back amount? ifelse(firstValue(extract('WD',{date}),[{date} ASC],[{date}])=1 ,periodOverPeriodLastValue(sum({value}),{date},DAY,3) ,periodOverPeriodLastValue(sum({value}),{date},DAY,1))

Need to account for weekends in a date filter

Question & Answer

Max March 15, 2023, 9:10pm 2

Have you looked at this?