Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Consecutive status count

I have a table with the status of my clients of all the months, what I would like is to be able to make a measure to calculate how many average months they last with x status, either active or inactive and that only brings me the largest number of months not a sum over time

8 Replies

    • dventura's avatar
      dventura
      Frequent Visitor
      4 years ago
      idsocioEstatusTipo SocioFechaMes
      6InactivoBenef.Familiar - PriSaturday, May 30, 2022April
      11Inactivo Saturday, May 30, 2022April
      22Inactivo Saturday, May 30, 2022April
      24InactivoBenef.Familiar - PriSaturday, May 30, 2022April
      31Inactivo Saturday, May 30, 2022April
      41InactivoDiplomatico PrincipaSaturday, May 30, 2022April
      42InactivoBenef.Familiar - PriSaturday, May 30, 2022April
      45InactivoBenef.Familiar - PriSaturday, May 30, 2022April
      70Inactivo Saturday, May 30, 2022April
      76InactivoBenef.Familiar - PriSaturday, May 30, 2022April
      104InactivoBenef.Familiar - PriSaturday, May 30, 2022April
      155ActivoBenef.Familiar - PriSaturday, May 30, 2022April
      222ActivoBenef.Familiar - SecSaturday, May 30, 2022April
      248ActivoBenef.Familiar - PriSaturday, May 30, 2022April
      287ActivoBenef.Familiar - PriSaturday, May 30, 2022April
      301ActivoBenef.Familiar - PriSaturday, May 30, 2022April
      316ActivoBenef.Familiar - PriSaturday, May 30, 2022April
      335ActivoBenef.Familiar - SecSaturday, May 30, 2022April
      375ActivoBenef.Familiar - PriSaturday, May 30, 2022April

      Syndicate_Admin 

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

        Thank you dventura 
        Sorry I have to leave now as already late afternoon over here. I will get back to you max by Monday morning.

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      4 years ago
      idsocioStatusPartner TypeDateMy
      6InactiveBenef.Familiar - PriSaturday, May 30, 2022April
      11Inactive Saturday, May 30, 2022April
      22Inactive Saturday, May 30, 2022April
      24InactiveBenef.Familiar - PriSaturday, May 30, 2022April
      31Inactive Saturday, May 30, 2022April
      41InactiveDiplomat PrincipaSaturday, May 30, 2022April
      42InactiveBenef.Familiar - PriSaturday, May 30, 2022April
      45InactiveBenef.Familiar - PriSaturday, May 30, 2022April
      70Inactive Saturday, May 30, 2022April
      76InactiveBenef.Familiar - PriSaturday, May 30, 2022April
      104InactiveBenef.Familiar - PriSaturday, May 30, 2022April
      155ActiveBenef.Familiar - PriSaturday, May 30, 2022April
      222ActiveBenef.Familiar - SecSaturday, May 30, 2022April
      248ActiveBenef.Familiar - PriSaturday, May 30, 2022April
      287ActiveBenef.Familiar - PriSaturday, May 30, 2022April
      301ActiveBenef.Familiar - PriSaturday, May 30, 2022April
      316ActiveBenef.Familiar - PriSaturday, May 30, 2022April
      335ActiveBenef.Familiar - SecSaturday, May 30, 2022April
      375ActiveBenef.Familiar - PriSaturday, May 30, 2022April

      @Syndicate_Admin

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Sorry dventura 
    I got little confused. Would you please provide the expected reaults out of the same sample data?

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      4 years ago

      For example, if I have an active client for 5 months but only 3 of those were consecutive i.e. (January, February, March, July and August) the result I expect is 3.

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

        Syndicate_Admin , dventura 

        but the provided sample data does not reflect this scenario. Please provide relevant sample data thatt reflects different possible scenarios in order to provide appropriate solution