7 Replies Latest reply: Apr 18, 2018 6:31 PM by David Forest RSS

    Filtering Data

    Kaina Baptista

      I've got a data base with products separated by ID, Status and Date. I'd like to create a function to count all the differents Id's that has the same status, although, as we use a accumulative Data, the older status of a same ID gets accumulated in the count of the provious

       

                                  Data Example

       

      ID               |            STATUS         |           DATA_HOJE

      1                               Fase 1                27/03/2018 11:43:04            

      2                               Fase 1                27/03/2018 12:47:04 

      3                               Fase 1                27/03/2018 13:43:05 

      1                               Fase 2                27/03/2018 11:43:04 

      1                               Fase 3                27/03/2018  11:43:04      

      2                               Fase 2                27/03/2018 11:43:04 

                                            .

                                            .

                                            .

       

                     Any Suggestions?