I noticed that our DOMO was pulling different trend %'s as compared to our regular route accounting software and in digging, I found it to be due to this year being a leap year.
When we first launched DOMO, the developer put in a beastmode to use as a slicer so that it would look at sales through the last full business day and compare it to the same date the prior year and we just named it "Future/Historic" and it defaulted to "Historic" so it matched our regular accounting software:
CASE WHEN (DAYOFYEAR(`date`) < DAYOFYEAR(CURRENT_DATE())) THEN 'Historic' ELSE 'Future' END
This worked fine until leap year date (February 29th) occured, then it began showing sales trends inaccurately when selected (Example: comparing 3/1/2020 - 3/25/2020 to 3/1/2019 - 3/26/2019). In order to have it compare {3/1/2020 - 3/25/2020} to {3/1/2019 - 3/25/2019}, I made a simple case statement adjustment - shown below:
CASE WHEN YEAR(`date`) = 2020 THEN
(CASE WHEN (DAYOFYEAR(`date`) < DAYOFYEAR(CURRENT_DATE())) THEN 'Historic' ELSE 'Future' END )
WHEN YEAR(`date`) = 2019 THEN
(CASE WHEN (DAYOFYEAR(`date`) + 1 < DAYOFYEAR(CURRENT_DATE())) THEN 'Historic' ELSE 'Future' END )
ELSE 0 END
I hope this helps someone else that may have a similar issue to deal with. I'm sure there are other ways to fix this issue, but this was a quick fix that worked...