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.
- Open
Dashboards and select TennisStats.
- Open
Edit.
- Click Matches Table to add it to the dashboard.
- Use the
Drag tile and
Resize options to position the table under the Round Type and PlayerName filters.
- Click
in the upper right of the new tile.
- Name the tile Matches and click Save.
- Click Save.
- Click Commit.
- 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:
- Open
Go to Dashboard.
- Append /model to the URL in your browser to open the bippDash editor. For example:
https://learn-bipp.app.bipp.io/#!/dashboards/D~4J18dnUy1/model - Locate the Matches tile in the editor and add an alias to match the filter values to the WinnerName:
- 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:
- Click Save.
- Click Commit.
- Enter the commit message and click Commit Changes.
- Open
Go to Dashboard.
- 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.
- Select
Projects.
- Select ATPTennisData.
- Open the MatchesAndPlayers table.
- 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:
- Click Save.
- Click Commit.
- Enter a Commit Message and click Commit.
- Click Deploy.
- Open
Dashboards and select TennisStats.
- Select a Round Type and click Apply:
IN THIS PAGE
Sign up for a forever free account!
Connect to leading SQL databases
Build visual data models without learning a new language
Create two dashboards and ten reports for free