Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

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