5 Replies Latest reply on Apr 11, 2017 10:12 AM by Norbert Maijoor

    Mix aggregates using window_max and Dates (Turnover)

    Cody Biddle

      Hello,

       

      I'm trying to find a calculation that will give me the accurate headcount depending on the max date per quarter

       

      Date Field.PNG

      The outlined area in the image above is the max date that I need show the different breakdowns of each quarter to create a dynamic calculation.

       

      Termination.PNG

       

      Here is where I have an issue. I cannot finish the calculation because I can't mix aggregations, cant use floats, strings, or anything else that I have tried.

       

      As stated before. I want this calculations to be dynamic so the outcome requirements will change from quarter to quarter.

       

      Let me know if i need to explain anything if it isn't clear.

       

      Thanks!