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

Sorting Date - Interactive Chart

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

data type.PNG

Here is the results, they are not in order.

not in order.PNG

This one shows date not part of my data.

with date not in data.PNG

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

Thanks and hoping to hear from our expertise.

Kamen

Workflow

Date Time

Accepted answers

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!

All comments

alexnajm

You should use the Date column then - the String column will not work because of the sort. This chart makes sense to me based on the Dates you have that have a count value - all the zeroes are not showing so you might consider adding a value so they can be counted

JosephSerpis

If you want your date in order sort them with a Sort tool before the Interactive chart tool

KamenRider

Hi @JosephSerpis @alexnajm

Yes, already tried this one using the sort tool before the Chart tool however, it is not working. Can't understand why. I have used both date and string data type in the X-axis of the Chart tool and it wont sort by date. See my previous image or screenshots for the results.

KamenRider

HI @alexnajm @JosephSerpis

I have the zero values posted however, i change the color to black so it wont be seen. This also the same with the legend. You can see it because the color is black. Hope you could help me solve this puzzle.

Kamen

alexnajm

@KamenRider using the Date value did sort correctly in your second screenshot, so I am not sure what output you are wanting to come! It shows the 17th, 19th, and 20th which are the ones that have a Rejects Count value

KamenRider

Hi @alexnajm ; @JosephSerpis

Yes it was able to sort the date however there are dates that is not part of my data like Nov 22 and Nov 23. I can't understand why there are dates that is not supposed to be included.

Hope you have a solution for this.

Kamen

alexnajm

I don’t understand - I don’t see barbvalues for Nov 22 and 23 in your second screenshot provided. If you want them removed from the axis, a Filter before your Interactive Chart tool would probably be the way!

What is the expected output? Can you draw us a solution?

KamenRider

Hi @alexnajm ,

If you review the data below, you’ll notice that November 22 and 23 are missing because they fall on a Sunday and Saturday.

However, the graph still shows November 22, and if I expand it, November 23 also appears. This does not match the actual data, since November 22 and 23 should not be present in the graph.

The output should accurately reflect the data and be presented in the correct order.

Date not included.PNG

Please let me know if you have any questions.

Kamen

alexnajm

That’s probably because the data you introduced includes dates up to 11/24 so it’ll try to fill in the axis since it’s a time series, regardless of the data. That’s why I think filtering those records out beforehand would work. Have you tried that yet?

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703