Latest Contributions by PeterBanwarth1

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. ... View more

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. ... View more