Charting Experts! How to get rid of dates with empty values on the Chart axis?

[kkkim]

Hi, Everyone!

I have a few charts where I am using date as one of the axis. I need to remove the dates that have zero values from the axis.

Any suggestions on how to do this? I changed date to a string but this didn't work!  And the dates that are highglihgted in yellow below are not even contained in the raw file (also attached).

Thank you for your help in advance!!!

[Qiu]

@kkkim 
Will a Filter tool not work?

Better you can provide some data but quick sample as below

[kkkim]

So it's very weird! I do not have those dates in the file (they are weekends so it's not in the raw file - only business days of the week and ex-holidays are). But they still show up! I tried changing it to string as well with no success....

[Qiu · Accepted solution]

@kkkim 

If it is an Alteryx Date Format, the interactive tool chart will append zero for the empty dates.
We have to do a little trick, maybe like below/

[kkkim]

Thanks so much for above! It worked but now some charts are showing dates out of order! 

Any idea on how to fix this issue? :(

Thanks again!!!

[OllieClarke · Accepted solution]

@kkkim following on from @Qiu's solution, if you sort your data by the original DATE field before the interactive chart tool, then your chart should also be in the right order. You may need to bring in a new interactive chart tool, because sometimes they 'get stuck'. 

Hope that helps

[kkkim]

Thanks so much! Figured out the issue and it is now resolved!!!