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

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!!!

Screenshot 2022-02-23 181206.jpg

Screenshot 2022-02-23 181641.jpg

Reporting

Accepted answers

Qiu

@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/

0224-kkkim-r1.yxmd

OllieClarke

@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

All comments

Qiu

@kkkim
Will a Filter tool not work?

Better you can provide some data but quick sample as below

0224-kkkim.yxmd

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

@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/

0224-kkkim-r1.yxmd

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!!!

Screenshot 2022-02-23 194530.jpg

kkkim

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703