Get Free Trial

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

Michael asked on October 11, 2017

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:
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

Tanya Gryshko Tanya Gryshko Flexmonster October 11, 2017

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: Keep in mind that dateTimePattern is used to set the pattern for "datetime".
Please let me know if your issue was fixed.

Michael October 12, 2017

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.

Tanya Gryshko Tanya Gryshko Flexmonster October 12, 2017

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

Please login or Register to Submit Answer