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
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 434 Beast Mode
- 22 Variables
- 510 Automate
- 114 Apps
- 388 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive