Color Rules for Gauge

apisciotta Member

In an effort to create a dynamic color rule for the Filled Gauge chart, I created color rules that correspond to a Beast Mode ratio of new users / day. However, the Gauge Values need to be populated off of total users added in current month. Is it possible to use color rules for data point calculated using Beast Mode as opposed to data included in the chart? If not, any suggestions on how else to create a dynamic color rule for a gauge chart in this scenario?Screenshots of scenario below:

Using today's date and new users this month (92 / 26) = 3.54, the chart should be dark green.

Gauge Chart

Color Rules

Beast Mode Calculated Field

Best Answers