I am using the below beast modes calculations for a chart. where I am trying to find the no of records received today and yesterday. Data appends itself in the dataset date wise.
Eg: if yesterday 1 record received, today 2 records received. dataset will show 3 count for today.
Beastmode:
today:
case WHEN SUM(CASE WHEN event_date
= CURDATE() then records
END) - SUM(CASE WHEN event_date
= CURDATE() -1 then records
END) > 0
THEN SUM(CASE WHEN event_date
= CURDATE() then records
END) - SUM(CASE WHEN event_date
= CURDATE() -1 then records
END)
else 0 END
Yesterday:
case WHEN SUM(CASE WHEN event_date
= CURDATE() -1 then records
END) - SUM(CASE WHEN event_date
= CURDATE() -2 then records
END) > 0
THEN SUM(CASE WHEN event_date
= CURDATE() -1 then records
END) - SUM(CASE WHEN event_date
= CURDATE() -2 then records
END)
else 0 END
But in the table it is not populating correct value.