Hi!
I am making a dashboard. I want to change a color of a point on the map according to the period I select on the dashboard's header. The point holds monthly records. I want the color changed according to the range of the average of the monthly records in the selected period. (blue: <235, yellow: 235~1260, red: >1260
)
I tried this:
a Web Map > "Contents" > the data layer > "Change Style" > "Choose an attribute to show" > "(Expression)" > clicked a pen icon > "Expression" > added "return mean($feature["Reporting_Result"]);"
It doesn't return the average of the single column ("Reporting_Result") in the specified period at the dashboard. I honestly do not know what it returns. The color changes oddly.
In short, the red circle on the map should be blue (avg. 171) but it's red:
![JulieWood_1-1612370853430.png JulieWood_1-1612370853430.png](https://community.esri.com/t5/image/serverpage/image-id/5231i87BF390D13DC214F/image-size/medium?v=v2&px=400)