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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 178 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive