Filters are a powerful tool that can slice an entire dashboard by anything in the database: geography, platform, user acquisition channel, etc. Here's how.
To start, create a filter for the user platform and name it "Device."
Start by clicking filter bar at the top of the dashboard. Then click the "+" button to the right of the dashboard-wide filter dropdowns.
To get the full list of devices, query all possible platforms from the gameplays table:
The user can also create a filter by manually inputting display names and values. The filter will display the name as the option but will input the value into the query itself.
Once the query is written, click "Save." The new filter will pop up on the left-hand side of the filter bar and will display the three values returned by the query: Android, iOS and Web.
Now that the Device filter has been created, it can be used in the charts!
In a SQL chart, use "where [my_column_name=FilterName]" anywhere in the SQL. Periscope will fill in appropriate values on the fly.
In this case, the "
users" table has a "
platform" column, which can be used in the "New Users" chart like so:
gameplays" table also has a "
platform" column, so the filter can be applied in a Gameplays chart like this:
Once the changes are saved to the dashboard, the appropriate Filter values can be applied in the Filter bar. Clicking "web" and then "Apply" (or double-clicking "web") will filter the charts on the dashboard to web users and web gameplays.
The filter bar now displays that the "web" filter is active, even when the bar is closed.
To select multiple values at once, simply check multiple values. For all mobile users, check both "iOS" and "Android" and click Apply.
Just like before, the charts update and the filter bar displays the newly active filters.