asked on October 11, 2017
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?
⋅ 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: 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
⋅ 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.
⋅ October 12, 2017
Michael,
Yes, this option is applied to all columns on the grid.
Thanks,
Tanya
