Add a Derived Table and Aliases

Using aliases enables you to create virtual joins between columns where an explicit join is not available. In this tutorial, you add the sheet created in the derived table Matches Table and define an alias to use the Player Name filter.

  1. Open Open Dashboards Dashboards and select TennisStats.
  2. Open Edit icon Edit.
  3. Click Matches Table to add it to the dashboard.
  4. Use the Drag icon Drag tile and Resize a tile Icon Resize options to position the table under the Round Type and PlayerName filters.
    Matches Table
  5. Click Change the title Icon in the upper right of the new tile.
  6. Name the tile Matches and click Save.
  7. Click Save.
  8. Click Commit.
  9. Enter the commit message and click Commit Changes.
    If you were to select a Player Name without setting up the alias, an error is generated:
    Server error
  10. Open Go to Dashboard Go to Dashboard.
  11. Append /model to the URL in your browser to open the bippDash editor. For example:!/dashboards/D~4J18dnUy1/model
  12. Locate the Matches tile in the editor and add an alias to match the filter values to the WinnerName:
  13. Another use of an alias is to exclude information for a sheet. For example, the Wins by Surface sheet should not be impacted by the PlayerName selection. Adding an alias from the PlayerName column to itself ensures any filter on the column is ignored on the sheet:
  14. Click Save.
  15. Click Commit.
  16. Enter the commit message and click Commit Changes.
  17. Open Go to Dashboard Go to Dashboard.
  18. Select one or more PlayerNames and click Apply to see the results. Click > to see additional rows.

Although you defined the parameter in Create a Parameter and added it as a filter widget in Add a Parameter. It also needs to be added in the SQL definition of the MatchesAndPlayers table to apply to the Matches table.

  1. Select Open Projects Projects.
  2. Select ATPTennisData.
  3. Open the MatchesAndPlayers table.
  4. Add these lines to the SQL. Adding it here with the where clause applies the parameter and prevents blank lines in the visualization on the dashboard:
  5. Click Save.
  6. Click Commit.
  7. Enter a Commit Message and click Commit.
  8. Click Deploy.
  9. Open Open Dashboards Dashboards and select TennisStats.
  10. Select a Round Type and click Apply: Table