Is there a way to exclude dates from outside months in the MoM comparison?
The current month is March and I have a chart showing sales data graphed by day and when selecting the MoM comparison, dates for March are showing up under the comparison for last month since February had only 28 days which is making our sales for last month seem much higher than they actually are. Is there a way to prevent this?
Tagged:
0
Answers
-
What would make the most sense would be to show the actual days for each month. February's line would stop at day 28, January's line would stop at 31 and March's line would stop at 31. I know I could achieve this through an ETL but I'm betting I could also achieve this through a beast mode.
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
- 435 Beast Mode
- 22 Variables
- 513 Automate
- 115 Apps
- 390 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