4 Replies Latest reply on Nov 22, 2013 4:34 PM by Gina Cardazone

    Change view when selecting all in filter by year

    Gina Cardazone

      I created a viz mapping rates of child abuse and neglect in different districts in my state, with a filter so that it can be viewed by year. You can see it here:

       

      Workbook: Hawaii Count & District CAN rates 2007-2011

       

      Everything looks great when I select an individual year.  However, when I select "All" , it basically concatenates the values for each year, which changes the scale considerably since it is just adding up the rates for all years. I'd like to keep the "All" view, but have it show a single average for all years, rather than joining together the values from each year. Is this possible?

       

      Thanks!