I am using a Line chat with a toggle button so show Count and Value.
in my expression, I am passing a date range from >= 1st of the month <= Current day -1. but if you see here in this, the data for 20th and rest of the day as 0 when I am using below expression. How we can customize so that it show data till 19th (Current Date : 20th Sept 2023) ?
if(GetFieldSelections(Data)='Count',
Sum({<Year=, Month=,Date=,Channel={'APP'},Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)-1))"}>}Count),
if(GetFieldSelections(Data)='Value',
Sum({<Year=, Month=,Date=,Channel={'APP'},Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)-1))"}>}Value)))