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!
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.