Menu
Download Free Trial

Use of the "max" or "min" aggregation options with the "date string" type

Hello,
It seems that applying the “max” or “min” aggregation options on “date string” types causes “Invalid date” to be rendered rather than making a cell empty. I’ve forked a JSFiddle to demonstrate this:
https://jsfiddle.net/kcq6zu5t/
In the JSFiddle, you should see that applying a “max” on a “number” type causes cells to be empty when no data is available. However, the same can’t be said about “date string” types.
Is this something you’re able to support?

3 answers

Public
Tanya Gryshko Flexmonster 6 days ago

Hello, Michael,
Thank you for writing.
"date string" data type is intended to be used in rows, columns and report filters. With measures, it is better to use "datetime" data type. I have updated your example and now it works as expected. Please, have a look: https://jsfiddle.net/flexmonster/kcq6zu5t/1/. Keep in mind that dateTimePattern is used to set the pattern for "datetime".
Please let me know if your issue was fixed.
Regards,
Tanya

Public
Michael 5 days ago

Thanks for the suggestion Tanya.
 
Another related question about your approach: is it possible to override dateTimePattern that applies per column if using datetime as the type? It looks like the former option is a grid-wide setting.

Public
Tanya Gryshko Flexmonster 5 days ago

Michael,
Yes, this option is applied to all columns on the grid.
Thanks,
   Tanya

Please login or Register to Submit Answer