11 Replies Latest reply on Mar 1, 2017 6:55 AM by Norbert Maijoor

    Customers above average - LOD expression

    Esther Twain

      Hello again, community!

       

      I want to create a bar chart showing the number of customers who have above average number of records in the data set.

       

      Now, I've already calculated that number (1161, in orange), but now I don't know how to display it in a bar chart. I know it involves a LOD expression and I don't want you to just spit me the solution, I want you to tell me what my reasoning should be, as I want to get there myself.

       

      I can't attach the workbook as it keeps saying the file is too large...

       

      customers above average.PNG

       

      Thank you!

       

      Esther