4 Replies Latest reply on Aug 1, 2016 11:33 AM by Shinichiro Murakami

    Color Formatting of Text Tables Center Value based on Grand Total Average of First Column

    Juvin George

      Hi All,

       

      I've been trying to dynamically set the center for diverging color formatting on a text table. This text table is a vintage table that requires the center to be based on the average of the first column.

       

      I have tried using calculated fields for color formatting. For instance, this is what I tried:

       

      WINDOW_AVG(AVG([Master Metric]), First(), Last())

       

      The table calculations are performed pane down. However, it picks the smallest and largest values  in the table and centers them based on that value.

       

      Any ideas on how I can set the center to be based on the average of the each column?