Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Interactive Chart is Not Showing Most Recent Date on X Axis

Goran
8 - Asteroid

Hi everyone,

 

I've put together a 3 input graph using the Interactive Charting tool with a combination of 1 bar chart and 2 line graphs  The x axis are individual days and the y axis are values.  The visualized data is accurate; however, the x axis doesn't ever show the most recent date under the most recent visualized data:

 

Goran_0-1685470503114.png

As you can see, the orange/green lines and grey bar on the farthest right are correctly showing May 29 data but the x axis doesn't actually show the date to which the most recent data should be aligned to and instead shows next day's date which doesn't have any data.  I've tried adjusting the padding, adjusting the height and width, re-sorting the data, etc. and nothing has worked.  

 

Any ideas how I can get the interactive tool to show every single date or at least correctly show the most recent data in the x axis (and not the date after it)?

 

Thanks!

 

Goran

3 REPLIES 3
binuacs
21 - Polaris

@Goran Just before the Interactive chart add a sort tool and sort the date field in descending order and try again

Goran
8 - Asteroid

@binuacs Yup, I've already done that.  As I said in my OP, the data is there and the visualization itself is correct, its just that the x-axis is not showing every date in the data set, and especially the most recent date.  As you can see from the screenshot, its skipping some dates on the x-axis but correctly visualizing the data in the actual graphs.  

 

Thoughts or ideas?

binuacs
21 - Polaris

@Goran would you be able to provide some sample data to test?

Labels
Top Solution Authors