Line chart showing Values as 0.

Kaushik2020 — Wed, 20 Sep 2023 12:09:19 GMT

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)))

topic Line chart showing Values as 0. in App Development

Line chart showing Values as 0.