Misleading trend line
When viewing sales history for a customer and looking at the trend for a period of time, I have noticed that the trend line can be misleading. The first example is in Domo, you can see that there were no purchases in Feb or Nov of 2017 for this customer.
However, the trendline is very flat. If you were to include 0 for the two missing months, the trend line should look like this:
I have tried to graph using ifnull(`Net Test QTY`,0) but that did not change the trendline either.
Any suggestions?
Comments
-
What up Scott!
So you basically need some way to add a data point for the missing dates to your data source (Without a date and 0 value the linear regression formula is ran for N-2 essentially)
You could left join a list of calendar dates to your source data and fill in the nulls with 0.
Once you have a reference point for it to assign 0 values to it will look like this:
Let me know if you need me to go into further detail.
Sincerely,
ValiantSpur**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 755 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive