Skip to main content
mark_gecsey
mark_gecsey
Contributor ⭐️⭐️⭐️⭐️
April 6, 2018

hours and minutes format mda table

  • April 6, 2018
  • 2 replies
  • 42 views
We have usage data formatted in the following format (hours: minutes: seconds), such as 27:44:12. I'd like to hear some suggestions on how an MDA table's Data Type may accommodate that format. We do not have an associated date so we cannot use Date/Time.
Thank you!

      2 replies

      dstokowski
      dstokowski
      Gainsight Employee ⭐️⭐️
      April 6, 2018
      We don't currently have a time data type in MDA.  We have Date and DateTime.  Do you have some specific operations you would like to do on this field?  

      Two options I can think of for handling today:
      1.  String - this should support valid sorting but would restrict filtering
      2.  Use DateTime and have a fixed date for all records.

      Thanks for posting Mark - We'll take this as an Idea for an enhancement to support Time only data type.
        mark_gecsey
        mark_gecseyAuthor
        Contributor ⭐️⭐️⭐️⭐️
        April 7, 2018
        Thank you. We are looking to use this data attribute to perform functions against it (sum, avg, etc) particularly to determine usage patterns and depth. As a result, we cannot use a string format. We could explore using a Date/Time with a fixed date. Thanks. The data, in its current state, fails upon ingestion. Thank you for responding.
        Mark Gecsey
        Terms & ConditionsAccessibility statement