Sum not aggregating over mm-yyyy with conditional expression for > one year

DawidDaw — Fri, 24 Jul 2020 10:32:26 GMT

Hello,

I have an issue where my sum is not aggregating correctly over my dimension. The sum is made over the exact date, giving me multiple instances of each month instead of aggregating over month-year - see picture below.

This is caused by my condition in the dimension:

=if(interval(line_invoice_due_date-today(),'d') >= 360,'Due in more than 360 days',
if(interval(line_invoice_due_date-today(),'d') <= -360,'Late more than 360 days',
date(line_invoice_due_date,'MM-YYYY')))

For the measure, I simply sum(line_amount). Everything is in the same table and the lines are unique.

It works fine without the condition but it goes back too much into the past and future, where we only care about rolling year + and year -.

Any idea how to fix this?

Thanks!

Re: Sum not aggregating over mm-yyyy with conditional expression for > one year

DawidDaw — Mon, 27 Jul 2020 08:13:37 GMT

Bump

topic Sum not aggregating over mm-yyyy with conditional expression for > one year in App Development

Sum not aggregating over mm-yyyy with conditional expression for > one year

Re: Sum not aggregating over mm-yyyy with conditional expression for > one year