community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

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