I've created a lead funnel in Podio, where all incomings leads arrive "unqualified", then move on to "qualified" or "rejected", then if they were in "qualified" move on to "in process" or "rejected", etc.
I'm trying to map the changes in categories in several calculation fields, and know how long it took between each changes. I'd love to have a calculation field returning the 1st category the lead was changed to (qualified or rejected), and another one for the time it took (ideally in business days but not critical). Then the same for the 2nd category the lead was changed to etc..
Some of this information can be retrieved on the activity view, but I would love to have it in the app template so I can analyse the data in bulk i.e. calculate average time, sort them by time etc.
Many thanks for your help!!
Please sign in to leave a comment.