Area charts should be ordered automatically by the series used on the x-axis first.

[TuringLovesDeathMetal]

Description

Today, if you don't add the correct ordering in an area chart, then it looks like it's broken and zig-zagging. There isn't a scenario I can think of where you'd want your area chart to be zig-zagging.

Instead of requiring users to use the correct ordering in the results table, instead, we should automatically sort by the x-axis first when plotting the data (similar to how we do this for line charts).

Here's more details on the issue: #9972

[rephus]

Relevant code is here https://github.com/lightdash/lightdash/blob/main/packages/frontend/src/hooks/echarts/useEchartsCartesianConfig.ts#L1485