2016 match data

[antillies85]

Thank you! Yes, my brother mentioned doing that as well. Thank you for confirming that this is a good way to go about this. I'm trying to use Tableau to compile data and visualize it all.

Thank you for your help!

[Ether]

Originally Posted by antillies85

Thank you! Yes, my brother mentioned doing that as well. Thank you for confirming that this is a good way to go about this.

I'm not so sure it's a "good" way, but it's an quick-n-easy way.

In Excel, a better way would be to write a simple macro to pick each match that 469 played in, and copy it to a new sheet.

I'm trying to use Tableau to compile data and visualize it all.

I've never used Tableau. Does it have a macro language? If so, you might want to investigate that.

Thank you for your help!

You're welcome. Feel free to ask questions any time.

[Firgreen]

I'm trying to use Tableau to compile data and visualize it all

There's no equivalent of macro calculations to VBA in Excel, though it does have some kind of data blending between different CSV sheets, as well as some flexibility in their table calculations.
But I've found the best way is to blend the data in Excel and then import into Tableau, which does require calculations and possibly macros.