3 Replies Latest reply on Nov 19, 2018 3:23 PM by Don Wise

    Calculated field formula for average value, when users select measure in filter?

    lynn.davey

      I'm trying to figure out the correct calculated field formula to be able to display the average value, in the tooltip, for each of the metrics I'm using in the filter. In the dataset I'm using, all values across all metrics are in a single column called, "Est."

      If someone selects Unemployment, I want to be able to show average city-wide unemployment in the tooltip,

      If someone selects Child Poverty, I want to be able to show average city-wide child poverty rate, etc.

      This is not a field in database so I need to add it as calculated field and am having trouble.

       

      Much appreciate any help!