Question
Timeline report by time
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.
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
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!)
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.