Period over Period help
Hi Grant, I have used your date dimension solution for lots of PoP charts but like you have mentioned on your post doing month over month can be tricky. Thanks for your help so far on my domo journey.
My problem. I have daily data and have a period type of 'Last Month' and 'This Month'
I have the data in a pivot table with months along the top.
I have noticed for October when showing "Last Month" it is including 30th September twice.
Is there a sensible way around this?
Thanks
Answers
-
@GrantSmith I believe I have found a solution by rewriting the comparison date with a formula in my ETL.
case when `Period Type` = 'LM' and DAYOFMONTH(`Report Date`) != DAYOFMONTH(`Comparison Date`) then ADDDATE(`Comparison Date`, 36500) else `Comparison Date` end
I only have data for 1 month so difficult to test properly. Do you think this is a reasonable workaround?
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 86 Workflows
- 23 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 117 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive