1 Reply Latest reply on Nov 11, 2013 9:57 AM by Tracy Rodgers

    Difference between maximum and median values along a row?

    Chris Hubbuch

      Anyone know a formula to calculate the difference between maximum and median values along a single row?

       

      For example, I have a database of property values and want to show the difference between the top and median. I've set up a dual axis viz that illustrates it but I want to be able to display the actual value in tooltips.

       

      The calculations I'm familiar with all want to compare between rows.