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)