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

    Mix aggregates using window_max and Dates (Turnover)

    Cody Biddle



      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.




      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.