YOY in table card beast mode
How can i display YOY Sales Data side by side in table card using beast mode. I am using this beast mode to display LY
Case when year(DATE_SUB(CURDATE(), interval 1 year)) = year(`Date`) then `Net Sales` end and date selected in table card is This Month
0
Comments
-
Your Beastmode looks good, but you can't use the card's date selection because it is year specific. In essence when you choose 'This Month' then you filter out all data from last year.
Consider these beastmodes with no date filter:
`This Year`
CASE
WHEN YEAR(CURRENT_DATE()) = YEAR(`Date`)
THEN `Net Sales`
END
`Last Year`
CASE
WHEN YEAR(CURRENT_DATE()) - 1 = YEAR(`Date`)
THEN `Net Sales`
END
`Month` (for filtering)
CASE
WHEN MONTH(CURRENT_DATE()) = MONTH(`Date`)
THEN 'This Month'
ELSE 'Other'
ENDThen add a FILTER using the new beastmode `Month` and filter to 'This Month' which is not year specific.
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 137 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 53 Domo Everywhere
- 2K Charting
- 997 Ideas Exchange
- 900 Connectors
- 236 Workbench
- 342 APIs
- 76 Apps
- 19 Governance & Productivity
- 233 Use Cases & Best Practices
- 49 News
- 473 Onboarding
- 572 日本支部