Weighted average for Operations Dashboard

786
0
02-05-2018 01:33 PM
Status: Open
PeterBanwarth1
New Contributor II

It would be very useful to be able to compute a weighted average in the Operations Dashboard.  This would allow the calculation of rates across geographies.  Furthermore, a dynamic weighted average should be able to respond to a filter.  For example, if I have four police districts, I could calculate a crime rate for the whole city, or for a subset of districts.  Then, I could filter to crimes where the victim is a certain sex - the numerator and denominator both have to change to get the correct crime rate.

A dynamic filter could be achieved easily by having a "weight" option in the element configuration panel for elements like serial chart, pie chart, indicator, or gauge..  Ideally you could weight by a field in the same layer or by a field in another layer.

Thank you.