Possible to graph a linear equation?

ChaseJepson
ChaseJepson Member
edited February 2023 in Charting

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!**
  • LWalker
    LWalker Domo Employee

    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:

    1. Create a new "Line" chart in Domo.
    2. In the "Data" tab, select the data source that contains the values for E_Rate, N_Rate, and GoalVariance.
    3. In the "X-Axis" section, select the column that corresponds to x (typically E_Rate in this case).
    4. In the "Y-Axis" section, select the column that corresponds to y (typically N_Rate in this case).
    5. In the "Line" section, select the "Equation" option.
    6. 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).
    7. 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.

  • 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?

  • 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
    FROM cases_slug
    UNION ALL
    SELECT NewSlug AS New, 0 AS Existing
    FROM cases_slug

    Then I created the XY graph and used the two variables

    Thanks for your help!