0 Replies Latest reply: Sep 21, 2012 4:39 AM by yamazaki RSS

    Sum, interval match, and aggr?

      Hello everyone,

       

      I got few issues to find a way to calulate this (it may look simple to many of you....)

       

      So here it is :

      I got the data (pics datasample) , so I want to sum (Nb_Jour _ABS) , but as you can see the data is multiplied by the number of days beetween 'DATE_DEBUT' and 'DATE_FIN_ABS'

       

      I tried in the script :

       

      Load *,

      if previous(DATE_DEBUT) = DATE_DEBUT and previous(DATE_FIN_ABS)=DATE_FIN_ABS and MATRICULE_A = previous (MATRICULE_A), sum()....) as xxxx

      this, doesn't work.

       

      I tried :also: aggr(distinct sum(NB_JOUR_ABS), MATRICULE_AGENT, DATE_DEBUT, DATE_FIN_ABS) doesn't work either.

       

      I tried  : sum(NB_JOUR_ABS) / count(DATE_ABSENCE)...doesn't work

       

      I want to put the results in a jauge, and a chart which dimension is 'month' from another table which is a calendar

       

      ISo, I really need a help to solve this.

       

      Wish you the best ,

      Will