3 Replies Latest reply: Nov 13, 2017 8:11 AM by Benoît Gochel RSS

    % Based stacked bar chart

    Benoît Gochel

      Hi all,

       

      I have a stacked bar chart with two dimensions (Employee and SubGroupProject) in order to analyze the timesheets of the employees.

      The timesheets are transactions lines with a quantity of hours and a projet-subGroupProjet-GroupProjetc.

       

      I would like to show with a stacked bar chart the repartition in % of subGroupProject for each employee.

       

      Eg :

       

      Untitled.png

       

      But with % repartition for every employee.

       

      I tried  :

       

      =num(SUM([#Hours.QTY])/SUM(TOTAL(<[empl.name]>[#Hours.QTY]))) as my meseaure expression

       

      But I got no result ...

       

      What can I do to solve this?

       

      Thank you in advance,