Hey all-
I'm sure this will come off relatively simple but this one has me stumped.
We switched ERP systems and I'm trying to get previous year sales to populate in a bar/line chart that shows current sales (by month in the bars) and previous year sales (by month in the line). I cannot get the new ERP system data to load for previous year based on my formula. However, when I set the date range to the previous year Domo is retrieving the data in the bars.
I thought this would be straight forward, but here's what I'm using:
case when `Lag Date` = `Exec date` then `Invoiced Amount` else 0 END
Lag Date = Exec Date - 12 Months using the Date Operations function
Exec Date = Invoiced Date
Invoiced Amount = $ Sales
I've also tried using date functions such as case when year (exec date) = year (exec date)-1 then invoiced amount... but that didn't populate either. Any advice?
Thank you!