Hello, I have 2 cards next to each other. One has a date field in the dataset already and another one date is calculated like this DATE(STR_TO_DATE(LEFT(Date + hour
, 8),'%Y%m%d')) where the field "Date + Hour" field looks like this
Even though the calculated field shows as type "Date" the chart sorts it as if it was a string, see the chart on the right.
Anyone has an idea on how to fix it?
Thanks
Alek