Comparing days of data 364 days apart
I can't believe this isn't as simple as I think it should be. The dataset has transactions which have a corresponding date value. I need to create a column to compare values for dates 364 days apart. Seems like it should be so simple.
This beast mode gets me the current day units:
(the column set up with a SUM aggregation)
These beast modes all validate but return unwanted values as noted after the -----:
SUM(IFNULL(CASE WHEN `DATE_VALUE`-364 THEN `GG_CONV_UNITS`ELSE 0 END,0)) ----- which returns all zero's
SUM(CASE WHEN (`DATE_VALUE`- 364) THEN `GG_CONV_UNITS` END) ----- which returns all zero's
SUM(CASE WHEN (`DATE_VALUE`-364) =`DATE_VALUE` THEN `GG_CONV_UNITS` END) -------which returns all blank cells
and I've tried lots of variations on this! Tried without the SUM in the beast mode and set it up on the column after added.
I 'm using 364 days because we use a fiscal calendar and I want to compare the same day fiscal year this year to fiscal year last year.
This beast mode always returns the correct corresponding day in the previous fiscal year:
I just can't get to the point where I'm collecting multiple rows of data from a day 364 days ago and summing them for the previous year.
Seems like it should be really simple!
- 10.6K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 63 Kowaza
- 296 仲間に相談
- 649 ひらめき共有