Possible to graph a linear equation?

I wanted to graph this linear equation in domo
GoalVariance = (E_Rate)x + (N_Rate)y
Is this possible in Domo?
Answers
-
You'd need to generate a dataset with numbers between the min and max of your graph and then you could utilize variables within the page for the E_Rate and N_Rate Values to automatically update your graph. You can use the value from the dataset for both your x and y value.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Yes, it is possible to graph a linear equation in Domo.
GoalVariance = (E_Rate)x + (N_Rate)y
To graph this equation in Domo, you can use the "Line" chart type, which allows you to plot a line based on a mathematical equation. Here are the steps you can follow:
- Create a new "Line" chart in Domo.
- In the "Data" tab, select the data source that contains the values for E_Rate, N_Rate, and GoalVariance.
- In the "X-Axis" section, select the column that corresponds to x (typically E_Rate in this case).
- In the "Y-Axis" section, select the column that corresponds to y (typically N_Rate in this case).
- In the "Line" section, select the "Equation" option.
- In the "Equation" input field, enter the linear equation in the form of y = mx + b, where m is the slope (E_Rate in this case) and b is the y-intercept (GoalVariance / N_Rate in this case).
- Click "Apply" to see the graph of the linear equation.
Note that you may need to adjust the scale of the x-axis and y-axis to make sure the graph is displayed correctly.
4 -
Hey @Lowell_Walker thank you for the reply. I am trying to follow your directions and getting stumped on step 5, not sure what I am missing. Can you point me in the right direction?
0 -
Hey folks, thanks for your help! I solved this using the first method of creating a dataset.
I pulled the two values from a separate table and created a small dataset of the two coordinates.
SELECT 0 AS New,
ExistingSlug
AS Existing
FROMcases_slug
UNION ALL
SELECTNewSlug
AS New, 0 AS Existing
FROMcases_slug
Then I created the XY graph and used the two variables
Thanks for your help!
0
Categories
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive