1 Reply Latest reply on Jul 7, 2016 7:13 AM by swaroop.gantela

    Need to display min/max/median in Tooltip box of data displayed as an average

    Pip Cameron

      Hi everyone

       

      I'm using data recording the temperature of 3 regions (northern temperate, equatorial, southern temperate) from 1880

       

      I've grouped the temperatures by decades (rows) and regions (columns) giving an average temperature for that decade/region

       

      I'd like to hover over the value and see the min/max/median temperatures of the data giving that average

       

      Unfortunately the min/max/median of one category is seen on the Tooltip of all average values in all 3 categories when I drag that measure to the Tooltip of Marks

       

      How can I assign/display the min/max/median of each decade/region combination?

       

      Message was edited by: Pip Cameron Rephrased question and updated file (changed colour conditioning)