Plotting a multi-line time series chart for multiple users

Question

Hi team,

I wish to plot a multi-line time series chart, is it possible to do so using interactive chart?

Goal: To view how the travel frequency of each traveller varies over time

Sample data (Data_for_chart.xlsx):

Column A: 8 travelers, A to H

Column B: Number of days traveled in a particular month

Column C: A particular month (Year-Month format, e.g. 2020-01)

Appreciate your help, thank you!

Data_for_chart.xlsx

lmorrell · Accepted Answer

Hi @wuaw

Packaged workflow is attached.

This is possible by assigning a Date data type to the year-month column, crosstabbing the data so that each traveler is a separate column, and then plotting each traveler as a separate layer within the Interactive Chart Tool.

There's a great Alteryx knowledge base article to how to leverage the Interactive Chart tool here.

Hope this helps!