Jul 13, 2022 1:38 PM - edited Jul 13, 2022 1:38 PM
We have a sales pipeline that has around 6 steps through where each one we are able report on the average days through it however what I want to be able to do is report on total time through the whole process (as well as broken down).
I cant't seem to find a report that does that, any ideas? my thoughts are leading to using datasets
Thanks in advance
Jul 15, 2022 2:19 AM
Since you already have time between stages, you can create a calculated property where you either calculate the time between the first and last stage or add up the time between different stages to be able to calculate the different time fields that you need. This should give you the information you are looking for.
Jul 15, 2022 5:35 AM
HI Nicole, yes I thought it would be that simple but when I look within data sets, there isn't 'Time in Stage' which I am not sure why but this is where my challenge is.
Jul 15, 2022 7:50 AM
See this video, http://video.sixandflow.com/watch/92f7oWWV3mCBNgerBZiKAd?
There is a way to calculate the amount of time a deal is open (close date - create date) using a calculated property or you can use the prebuilt table showing time spent in each stage.
Jul 15, 2022 10:18 AM
We have that calculation but we want to actual measure from prospecting stage (which isnt always the case that create/prospecting are same dates).
Jul 14, 2022 4:41 PM
Thanks for reaching out!
I wanted to invite our subject matter experts to this conversation.
Hi @Josh, @Mike_Eastwood, @NicoleSengers, @johnelmer - Do you have any reporting recommendations or insight for @SClifford5?
|Did you know that the Community is available in other languages?|
Join regional conversations by changing your language settings !