Status:
New Idea
Seconds Granularity: Support DateTimeLevel for seconds & milliseconds (ss:ms) for Elasticubes
Description
Limitations when working with DateTime fields in dashboards built on ElasticCube (not Live models). These limitations affect their ability to accurately display and analyze event/log/trade data.
Issues:
- We are unable to display the full timestamp including seconds — the format currently shows only up to minutes. Since our logs are time-sensitive and measured in seconds, this detail is essential.
- We cannot display the full date and time in a single field. As a workaround, we have to split the data into two separate fields (one for date and one for time).
- Sorting is also a problem. We can only sort by one field at a time, so if we sort by date, the time is not sorted correctly, making it difficult to follow the log order.
We’ve noticed that Live models handle datetime fields more effectively and allow displaying timestamps with seconds (such as “Every Second”). However, due to the size and complexity of our data model, switching to a Live model is not an option for us.
Request:
We would like improved support for DateTime fields in ElasticCube dashboards, including:
- The ability to show full timestamps with seconds.
- Support for displaying date and time in a single field.
- Better sorting logic when working with split DateTime fields
- The alternative solution https://community.sisense.com/kb/faqs/show-full-date-format-in-the-pivot-or-table-widget/25504 also does not work for us
You can add :ss: in the value format but it just not support it and feels like a bug instead of by design.