Question

Timeline report by time

  • 18 July 2018
  • 3 replies
  • 33 views

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. 

3 replies

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
Thank you Tim, I just noticed that I was using the wrong object to get this kind of information. 
Ah!  Good to hear.  (Finding where the data lives is always the hardest part!)

Reply