Forum Discussion
Data type Date not sorting on a line chart
I'm trying to display some data on a line chart. Specifically, I want them to be split by week. I have a column called EventDate that contains DateTime values. To classify them by week, I created a c...
The problem was that, upon applying a custom query, the column loses its type. In other words, even if you're referencing from a Date column, the new custom column will not be of type Date, and you have to manually set it to be one.