Forum Discussion
Syndicate_Admin
Administrator
AdministratorConsecutive 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 inacti...
Syndicate_AdminAdministrator
AdministratorFor 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
Community Champion
Community Championbut 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
- Syndicate_Admin
In this case I just want to calculate the active time the id 6 should throw me 3, the id 41 should throw me 3 also although since it is the longer than hard time active and so on.
idsocio Status Partner Type My Year 6 Active Benef.Familiar - Pri January 2022 6 Active February 2022 6 Active March 2022 6 Inactive Benef.Familiar - Pri April 2022 6 Active May 2022 41 Active Principa Diplomat January 2022 41 Active Benef.Familiar - Pri February 2022 41 Inactive Benef.Familiar - Pri March 2022 41 Active April 2022 41 Active Benef.Familiar - Pri May 2022 41 Active Benef.Familiar - Pri June 2022 155 Active Benef.Familiar - Pri April 2022 155 Active Benef.Familiar - Sec May 2022 248 Active Benef.Familiar - Pri April 2022 248 Inactive Benef.Familiar - Pri May 2022 301 Active Benef.Familiar - Pri April 2022 301 Active Benef.Familiar - Pri May 2022 375 Active Benef.Familiar - Sec April 2022 375 Active Benef.Familiar - Pri May 2022