Skip to main content
mahara_scholz
mahara_scholz
Contributor ⭐️
July 18, 2018
Question

Timeline report by time

  • July 18, 2018
  • 3 replies
  • 62 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

      tim_schukar
      tim_schukar
      Helper ⭐️⭐️⭐️
      July 18, 2018
      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
        mahara_scholz
        mahara_scholzAuthor
        Contributor ⭐️
        July 18, 2018
        Thank you Tim, I just noticed that I was using the wrong object to get this kind of information. 
        tim_schukar
        tim_schukar
        Helper ⭐️⭐️⭐️
        July 18, 2018
        Ah!  Good to hear.  (Finding where the data lives is always the hardest part!)
          Terms & ConditionsAccessibility statement