Skip to content

    • Charting

    Charting

    Possible to graph a linear equation?

    Member
    edited February 2023 in Charting
    LinearEq.png

    I wanted to graph this linear equation in domo


    GoalVariance = (E_Rate)x + (N_Rate)y


    Is this possible in Domo?

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Answers

    • Coach

      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!**
    • 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.

    • Member

      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?

      image.png
    • Member

      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

      image.png

      Thanks for your help!

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories