How to create index in tableau?

Question

Can anyone tell me how to create index in tableau?

Answer 1

Here are the steps to create index in Tableau:

• Start Tableau Desktop / Public
• Open the world_cup_results.xlsx
• Drag the World Cup. Tableau Format onto the data pane
• Click on Sheet1
  • Drag Team onto Rows
  • Drag Date onto Columns
  • Create a new Calculated Field called Index using: INDEX()
  • Drag Number of Records onto Text
  • See the table and observe the results

You will observe the number of records for each team for each world cup year. This is pretty simple stuff, but observe after dragging the Index Calculated Field onto Text. Now the whole table will be full of numbers which indicates the position depending on how it is calculated.

• Right click on Index. Go to Compute Using. See that Table (across) is selected
• Select Table (down) and observe the results
• Check out the other options. Observe the difference:
  • Table (across then down)
  • Table (down then across)
  • Cell
  • Date
  • Team

If you want to learn Tableau, check out this Tableau Training Course by Intellipaat.