🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
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 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