Dear visitor, despite all the challenges, our team continues operating at full speed.

We are ready to help with any questions you may have. Please fill out this quick form and we'll get back to you.

Fill the form
Get Free Trial

How to display date and time in a measure cell

Ahmed asked on July 10, 2019

How to display date and time in a measure cell without replacing text in cell.text
Thank you.

1 answer

Vera Didenko Flexmonster July 10, 2019

Hello, Ahmed,
Thank you for your question.
Date and time can be displayed in a measure cell by specifying the appropriate data type.
Please consider using the datetime JSON data type for Fields containing date-time values.
The datetime data type is a date field that can be used for values in the pivot table. Min, max, count, and distinct count aggregations can be applied to this field.
Please see our date and time formatting tutorial for more information.
Here is a JSFiddle example for illustration.
Please let us know if you have further questions.
Best Regards,

Please login or Register to Submit Answer