ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Interactive Chart tool - Dynamically edit X axis for relative dates

Using other data viz tools like Tableau, we often plot yearly timeseries of data onto the same line chart so we can quickly compare year-on-year differences.  All data viz tools seem to have complexities but the logical approach is the same.  What you do is map all the years data to a relative year, i.e. this year, and then give each year it's own title.  See the example below snipped from a Tableau dashboard:

 

image.png

 

In this example 7 years of data have been plotted on the same chart.  Note the x-axis,  In Tableau we are able to format the X-Axis labels to only show month and day (Mon-D).  This removes the common relative year, i.e 2019.

 

As expected, Alteryx is awesome at preparing data to do this kind of thing.  Using the interactive charting tool you can build really nice charts.  However there is currently no way to format the X-Axis label, you must show the relative year too, as shown in the picture below (snipped from the browse tool, outputted from the interactive chart tool):

 

 

image.png 

 

It was really easy to prepare the 5 year min, max and average lines, which is almost impossible to do in Tableau!

 

My idea in a nutshell is, please change the interactive chart tool so that the labels on the axis can be formatted to the user's choice, i.e. in this case formatted from datetime to "%B-%d".

 

Please note, the workflow i'm building in this case, is creating 3 line charts of related data, each by year.  The end product is a daily email sent to users.

 

Thanks, nick 

1 Comment
SeanAdams
17 - Castor
17 - Castor

This idea would be a good addition to the interactive chart tool!