Timeline report by time

  • 1
  • Question
  • Updated 3 months ago
  • Answered
Is it possible to create a report based on the time that an activity is being added to the timeline? Eg. I'd like to know if there is a time pattern of one kind of activity, therefore, I'll get the time the update is created in the timeline and analyze it. 
Photo of Mahara Scholz

Mahara Scholz

  • 84 Points 75 badge 2x thumb

Posted 3 months ago

  • 1
Photo of Tim Schukar

Tim Schukar, Employee

  • 1,870 Points 1k badge 2x thumb
Hey Mahara!

The "Created Date" field is a datetime field that will give you the date and time of the entry.  To get just the time component, you could either build your report and export to format in Excel or create an MDA object and use the string functions in Bionic rules to pull just the time component from the field.  

Just be aware of what timezone your SFDC instance is set to.  You may need to adjust timezones if you have a distributed team.  Thanks!

Tim
Photo of Mahara Scholz

Mahara Scholz

  • 84 Points 75 badge 2x thumb
Thank you Tim, I just noticed that I was using the wrong object to get this kind of information. 
Photo of Tim Schukar

Tim Schukar, Employee

  • 1,860 Points 1k badge 2x thumb
Ah!  Good to hear.  (Finding where the data lives is always the hardest part!)