Build Line chart with 30 days interval data
Comments
-
create a Beast Mode ... this is pseudo code.
Case
when Date >= today - 30 then 'Group 1'
when date >= 60 then 'Group 2'
...
END
Alternatively if you're using this logic a lot, build a date dimension ( a table with one row per day) in Magic or SQL and then add the '30 day trailing' column with similar logic from your beast mode.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
This discussion has been closed.
Categories
- 7.4K All Categories
- 13 Getting Started in the Community
- 150 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 905 Connectors
- 239 Workbench
- 343 APIs
- 77 Apps
- 19 Governance & Productivity
- 237 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部