How can I filter greater than '>' without 'ADD A FILTER'
Got a salary column in BigQuery.
Trying to figure out a way to filter the salary with logical operators without specifying a custom filter(ADD A FILTER) in Looker Studio.
I would like to perform the following operation: salary > 5000000000000000 for example.
Is this possible?
Solution
One way is to use a Filter Control, with the Dimension set to Salary, and the Filter Control set to the Search All view, so that comparison operators (>, >=, <, <=, =) can be used to filter Metrics quickly.
Created a Looker Studio Report (Google Sheets Embedded) as well as a GIF showing the process.
- Looker Studio BigQuery Custom Query returns error Not found: Dataset -:- was not found in location US
- JavaScript, find lowest value in array of objects
- Embedding Looker Studio reports in an AppEngine Application
- How can I filter greater than '>' without 'ADD A FILTER'
- How can I prevent filter from affecting scorecard?
- How can I returns the number of unique values when date matters?
- CSV data upload via API?
- How can I replicate a cumulative field?
- How can I allow users of my connector to set a different username and password each time they create a new source?
- How to show a Time Series chart by Date + Hour in Data Studio - only showing up as 12AM
- Long form record view in looker studio
- Cannot connect Looker Studio to Postgres Database hosted in Google Cloud SQL
- Converting UNIX time to Date in Google Data Studio
- How do I create a "Users by time of day" heatmap in Google Data Studio?
- DataStudio chart failing on initial page load in Internet Explorer 11
- How can I manage one-to-many relationship in Google Looker Studio
- Connect Google Cloud SQL Potsgres with Google DataStudio
- How to update permissions for a user in looker studio api?
- System Error when I share the report with someone others [looker-studio]
- How can I Filter Data in Google Data Studio based on containing 2 or more input options?
- How can I create a single time series chart with lines for each device category (mobile, desktop, tablet)?
- How can I connect Google Looker Studio with AWS Redshift?
- Using Array Field for Filtering Rows
- How can I use a single url parameter for multiple queries in google data studio?
- How to give access to a single Bigquery Dataset for a user to access the data in Datalooker?
- Change drill down level for multiple charts at the same time
- How do I add the current Week number in Looker Studio on screen
- Export data with looker studio
- Connecting Heroku Postgres to Google Studio Looker
- Does Google Data Studio have API functionality, and if not, will it in the near future?