7 Replies Latest reply: Dec 21, 2015 12:56 PM by Andy Weir RSS

    Average comparation in bars graphic

    David Arroyo

      Good morning,

      imagine a very simple table with three columns: EMPLOYEE - SKILL - SCORE.

       

      I want to make a bar graphic with skills in Y and scores in X. Each bar would be the score average of each skill, that's easy. But I want to filter by employee in order to see his skills compared with the global average.

       

      My problem is: when I select a user then the filter applies to the graphic averages, so global averages and employee averages are the same. I would need global averages stay fixed filtering employees.

       

      Can I make this with the current table? Or should I add another table without users for the global average measure?

       

      Thanks in advance.

       

      Best regards,

      David.