3 Replies Latest reply: Jul 29, 2012 1:37 PM by Patrick Quirk RSS

    Bar chart showing supervisor turnover rate

      Hi All -

       

      Thanks in advance!

       

      I am calculating turnover rates for each supervisor and then showing the 'top 10' managers with the highest turnover rate in a bar chart.

      How do i limit the numerator and denominator in the expression to count terms and headcount just for that supvid?

       

      Dimension = supvid

       

      Expression =

       

          Count ({$<  STATUS = {"Terminated"}  >} DISTINCT EEID)

            /

           AVG( aggrCount ({$< STATUS = {"Active","LOA"},  TERM_TYPE = ,  TERM_REASON =  >} DISTINCT EEID ) , CYCM) )

      Thanks!

       

      Pat

        • Re: Bar chart showing supervisor turnover rate
          Stefan Wühl

          I think your numerator should only count terminations for that supvid.

          I am not sure with your denominator, since you are using an advanced aggregation. What is field CYCM and how is it related to your supervisors?

           

          I assume your denominator returns the total headcount (?), disregarding the dimension value.

           

          To debug, it would probably be better to create an expression per numerator / denominator, so you can actually see the numbers and locate the cause of your issue.

          It might also be helpful if you can post a small sample app demonstrating your issue (upload is available in advanced editor).