Sorting Date - Interactive Chart

[KamenRider]

Hi,

I am trying to arrange my date which are in the X-axis however it is not working. Tried both Date and String data type however it shows inconsiderable results.

Below is my data

Here is the results, they are not in order.

 

This one shows date not part of my data.

Need you assistance in fixing the issue. Need to sort data base on my data.

Thanks and hoping to hear from our expertise.

Kamen

 

 

 

[KamenRider]

Hi @alexnajm 

May I know what records should I filter? Because if you are referring to Saturday and Sunday date, I don't have that records. This dates automatically appeared in the graph.

Please advise.

Kamen

[alexnajm]

Yes exactly, because it will give dates in between the min and max of the data that you provide... so if you remove data that you won't need in the graph, then the axis should update.

But I can't help further without an expected output. Otherwise good luck!