3 Replies Latest reply on Nov 30, 2016 10:32 PM by Norbert Maijoor

    Use Window Avg to Determine Outliers

    Allison Suarez

      I have been hitting my head against my desk because this should be sooooo simple.  I have a table (image below, can't post workbook due to sensitivity) that shows by device the average time it took to perform a function.  What I want to do is highlight any value that is higher than the average across all devices.  So if the average for "load" is 3.2 seconds, I want to make any values in the 'load' column red.  I have tried a bunch of the window average suggestions already on the forum but am not having any luck.  Plus I can't get the calculation the change from table(across) to table(down).

      Any thoughts are appreciated.  I am using 10.0 if that matters.

      Thanks!