I have a dataset that examines the running ELO scores of college football teams since 1900. (example)
|September 20, 2000||Colorado||Nebraska||1500||1600|
|September 27, 2000||Nebraska||Iowa State||1650||1450|
|September 27, 2000||Colorado||Oklahoma||1450||2200|
|October 15, 2000||Iowa State||Kansas||1400||1200|
Teams that are in the "Team.A" column are the winning team for that game, and teams that lost are in the "Team.B" column. I want to create a time series that looks at all of the ELO scores for each team in the Elo.A and Elo.B column in one graph. So if I wanted to look at Colorado's running ELO, it would be a time series that looked at the ELO scores in the A and B columns. How do I go about doing this? Is this possible in Tableau? The original file is a .CSV.
Its not very clear .My doubt is ELO.A and ELO.B are for which team? Team a or team b or winning team?
Can you give the expected output for the table you have in your post.