Best Of

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.

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.

There are not color ranges in this card, but you can assign positive and negative colors. For the formatting, try setting the format on the gauge value and the target value to number. There are also individual formatting options within the chart properties, which can be confusing. I feel your pain there.

Yes, you can do this. I would put the field (can be a beast mode) that has the value for your records with a certain value in the Gauge Value and then the field that that has the total number of records in the Target Value. You will also need to put something in the Group By that will aggregate the data appropriately.

In the Chart Properties, under Change Value Options - Data, choose Last Target Value and Last Value. This will give you your percentage.

Explore the other chart properties such as General - Layout and Additional Text Options to get the display how you want. The Multi-Value gauge has a lot of customization to it, but it takes some experimenting to see all that you can do. Here is an example of how I am dynamically showing two different years with values and percent change by using the various macros in the Additional Text Options.