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!
hours and minutes format mda table
Mark Gecsey
+5We 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.
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.
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.
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.