Plotting a multi-line time series chart for multiple users

[wuaw]

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!

[lmorrell · Accepted solution]

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!

[wuaw]

Hi @lmorrell

Thank you, your solution is fantastic. The article is very helpful.

Have a nice day!