I’m trying to create a report that calculates the average number of days spent in each lifecycle stage. Right now, we’re using the property Cumulative Time in [Stage], but there’s a limitation—if a contact is currently in a stage for the first time, this property has no value unless they had previously been in that stage.
What we want is to calculate the average days spent in each stage, regardless of whether the contact is still in that stage or has already moved to another.
Do you know how to build this report?
Hi @Hardib81,
This is most easily done as shown below, in the custom report builder 
Create reports with the custom report builder
Best regards
Hi thanks, however, as i said, the problem is that if a contact is currently in a stage for the first time, this property has no value unless they had previously been in that stage. Check here: Use contact and company lifecycle stages
We want to calculate the average days spent in each stage, regardless of whether the contact is still in that stage or has already moved to another. Is there any way to do that?
@Hardib81 this should be possible with a ‘time since’ calculation property: Create calculation and rollup properties
