Date Range til yesterday
I have a calculation which compares daily sailes from this year to last year. Addionally YTD will be calculated and compared.
Unfortunately, DOMO includes today as the starting date, which is 0 and compares that figure to the relevant day in the last year.
Therefore I receive a wrong YTD in my last year.
Does someone has a solution? I don´t want to change the date range (Today-1) manually. I already changed my SQL flow and ETL so, I don´t have a partial sales for today, but I can´t figure out how to automatically exclude the day of last year for today (If that makes sense) eg.
This year: 22.1.2018 (no value)
Last year: 22.1.2017 (value)