How do I add a trend line?
I know I saw this at Domopalooza in one of the breakout sessions (even tried to snap a pic of the screen but wasn't fast enough), so perhaps a Domosapien or a Major Domo with superior math skills can help me figure out how to derive a Beast Mode formula to demonstrate a trend line over a particular metric. What I'd like to do is use a Column + Line card, and have the line be the trend. While the columns may go up and down across the time series, the trend is more than just the net change between the first and last point - there's an overall (weighted?) slope to the result across multiple periods.
How can this be accomlished? Thanks in advance, Community!
**Be sure to select the answer that represents the best solution and mark as "Accept as Solution"
Best Answer
-
In the last big release there was functionality added to the single bar, scatter, and a few other cards to include a regression line. It will use a least squares regression formula to create a trend line and superimpose it on your card. Maybe this would be a simple solution for you.
To build one, create a Single Bar card like normal. Then in the Chart Properties section on the left, find the Regression Line section and click the Show Linear Regression Line option. You can customize the style and color of the line there as well.
Does that look like it could solve your problem?
3
Answers
-
In the last big release there was functionality added to the single bar, scatter, and a few other cards to include a regression line. It will use a least squares regression formula to create a trend line and superimpose it on your card. Maybe this would be a simple solution for you.
To build one, create a Single Bar card like normal. Then in the Chart Properties section on the left, find the Regression Line section and click the Show Linear Regression Line option. You can customize the style and color of the line there as well.
Does that look like it could solve your problem?
3 -
Thanks for the reminder. i had forgotten about that new feature, and that may work for me.
As always, the possible utilization desires may exceed designed/intended functionality. If anyone knows how to create that formulaically in Beast Mode, that would still be of interest - my initial thought around this was wanting to incorporate the trend line on either a Grouped + Line or a Stacked + Line rather than a single-bar.
**Say thank you by clicking the 'thumbs up'
**Be sure to select the answer that represents the best solution and mark as "Accept as Solution"2 -
I don't see the "regression line" setting in the chart properties. where is it located within chart properties exaclty. Ideally, i would like to add a regression line to the chart below.
0 -
The regression line options aren't available for a grouped chart. You'd need to use a Single Bar card to make use of that option.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive