3 Replies Latest reply on Sep 5, 2018 1:15 PM by Jim Dehner

    Calculated field compared against Window Average?

    Bryan Pon

      Struggling with what I think is pretty basic.

       

      I'd like to create a calculated field that compares that row's numbers against the entire table's average.

       

      To use Superstore example, I want to first calculate the aggregate average sales per customer for each of the Categories (Furniture, Office Supplies, Technology). Then I want to expand back the table to see each customer row, and put in my calculated field that determines whether that customer's sales are above/below the average.

       

      The ultimate goal is to show a stacked bar for each Category, showing the percentage of customers that had NULL sales, above average, below average for that category.

       

      Screenshot (124).png