In this tutorial, we will go through a few basic interactions with a dashboard.
Editing a widget
In this section, we will add more information to the basic Revenue by Production Company widget.
Click on the ... symbol on top of a widget → Edit Report
The widget edit screen will appear.
Drag in the Imdb ID field, and change the aggregation to CountD to count number of movies produced by a company.
Click Get Result if you want to view the changes.
Click Save to finish, and you will be navigated back to the dashboard
Explore a widget
When viewing a dashboard, you can also open an Exploration screen of a widget to freely drag-and-drop without accidentally modifying the underlying widget.
Right click on the visualization → Explore
Another way is click on the ... symbol → Explore Data.
The Exploration modal will appear with the current dashboard filter applied:
This widget is displaying a scatter chart of movie budget - revenue grouped by Budget Range. Now we only want to look at aggregation metrics of each budget range.
Click on Data Table visualization. The Table Fields area will revert to the basic field listing format.
Now we change things up a bit
- Remove Original Title field.
- Drag the Budget Range to the top of the list
- Drag in the Imdb ID field, change aggregation method to Count Distinct. Rename the field to Movies Count
- Change Budget and Revenue's aggregations to Sum
Click Get Result. We will see there is a row where Budget Range is null - this is because there are movies with no Budget value.
If we want to remove that row, in the Conditions section, select Budget Range field, "is not null" operator → Click Apply
A new condition will be added to the setting.
Click Get Result, and you will see the NULL Budget Range row was removed
Remove Release Date last 20 years condition since we will not need it. Get Result, then click on the v icon on top of Movies Count → Sort Descending.
We will see that in this data set, the largest portion of the movie has a budget between $1 million - $5 million USD.
Click Save As → Input widget title and select a new dashboard to save this exploration into. In this case, we have created a Movie Production Companies Overview dashboard beforehand.
Follow the link provided and you will be navigated to the new Dashboard
Among the movies with known budgets, how many movies are profitable? We will answer this using a Business Calculation.
Business Calculation feature allows end-users add calculations to the report using a simple set of syntax. In this section, we will create a Profitable Movies Count calculation that only count the movies with revenue greater than budget.
Click ... on top of the Movie Metrics by Budget Range widget → Edit Report to enter the report edit mode.
In the Table Fields area, click Add field... → Add Business Calculation.
The Create Business Calculation modal will appear. Enter Field Label, Description (if necessary), and the Formula:count(case(when: movies_metadata.revenue > movies_metadata.budget, then: movies_metadata.id, else: null))
Click Create to finish. Get Result to view the result of the new calculation
Click Save to finish, and you will be brought back to the dashboard view.