Can't seem to sort the dates on the X-axis
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…