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?
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
Please let me know if your issue was fixed.
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.
Yes, this option is applied to all columns on the grid.