Tickets & Conversations

James-Preseem
Contributor

Time in current status calculation

I am sure if this is the right location for this question, please let me know if there is a more appropriate board.

 

I am trying to determine the length of time that a ticket has been in the current pipeline stage (status).   I suspect that I can find a way to make this work using a customer calculated property....however I know that this information is already an attribute of the ticket within HubSpot.   In late 2020, there was a short week of time in october, where the export of all ticket properties was not restricted and showed there were actually almost 270 properties available.

 

Specifically there were 

 

Date entered 'stagename (Pipeline Name)'

Time in 'stagename (Pipeline Name)' (HH:mm:ss)

Date exited 'stagename (Pipeline Name)'

 

For each stage / pipeline that we have  as well as for the current stage pipeline as a separate set of properties.

Unfortunately, these were only temporarily available and were no longer included in the export of all properties after a few days of public exposure.  Further unfortunate is the fact that these have never been exposed to then reporting or workflow parts of the product.

Which brings me to my question.   Are any of these properties exposed to the API as properties?  Is there an hs_pipeline_stage_time_in_stage_current  or something similar that I can access that will give me the current duration that a ticket has been in the current stage (status)?

 

 

 

 

 

0 Upvotes
James-Preseem
Contributor

Time in current status calculation

@MiaSrebrnjak 

Is there any indication from Product Management that they might expose the existing properties that track this information already.  I have created properties previously that mirror exiting properties that are not exposed already.  It seems to me that making users create a property, then build a workflow that monitors tens of thousands of tickets in order to provide information that is already available but not yet exposed is redundant and frankly a bit irritating.

0 Upvotes
MiaSrebrnjak
Community Manager
Community Manager

Time in current status calculation

Hi @James-Preseem,

 

Thank you for reaching out to the Community!

You are right - there currently isn't a default Ticket property that would record the date when a ticket has entered a certain stage. 

 

You could, however, create a custom date picker property by following the steps in @karstenkoehler's solution to this Community article. I hope this helps!

 

Cheers
Mia, Community Team 

 


Wusstest du, dass es auch eine DACH-Community gibt?
Nimm an regionalen Unterhaltungen teil, indem du deine Spracheinstellungen änderst


Did you know that the Community is available in other languages?
Join regional conversations by
changing your language settings