Interactive Chart - Line Chart format different than Area Chart using DateTime on X-Axis

[Anthony_A2]

I am getting different results in the Interactive Chart tool between Line and Area formatting. Area seems to work as intended but the Line chart doesn't format the path of the line correctly.

This is what I get when using the Area chart:

And when I switch to the Line chart, the path of the line changes:

Below is a sampled dataset that I'm using in this example. The first column is a FixedDecimal while the second column is DateTime

FixedDecimal	Collection Date and Time
0	2021-12-20 13:55
0	2021-12-20 13:57
0.6	2021-12-20 14:33
0.9	2021-12-26 14:53
1	2021-12-26 14:52
1.3	2021-12-20 13:38
1.5	2021-12-30 15:58
1.5	2021-12-31 16:01
1.5	2021-12-31 16:02
1.6	2021-12-30 16:00
1.6	2022-01-03 10:49
1.6	2022-01-03 10:52
1.7	2021-12-21 14:09
1.7	2021-12-21 14:11
1.8	2021-12-20 16:05
1.8	2021-12-20 16:07

Does anyone have an idea why I'm experiencing this behavior? Or if there is a workaround with data types or etc,?

I would prefer to go with the line chart since I plan on adding on multiple layers and other details. 

[danilang]

hi @Anthony_A2 

I was able to hack around this by converting collection date to a datetime field, sorting the data by collection date, adding the area layer, adding a second line layer and then deleting the the area layer.  

Leaving out any of the steps results in the inverted line that you found

It's an ugly hack and you should probably open a ticked 

Dan