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

    Average comparation in bars graphic

    David Arroyo de la Peña

      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,