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