Request to add color rules for data points calculated using Beast Mode as opposed to data included in the chart for the Filled Gauge chart.
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. 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