How to Create a Table in Looker Studio that Only Shows Data After ID Input

Looker Q&A Looker Studio
1

I WANT THE FOLLOWING DATA SYSTEM:

  • When the first report is opened: Only the table header is visible
  • When a user enters an ID in the input box:
  • The system will filter the data
  • The corresponding data row will appear below the header
  • If there is no match, only the header remains visible

HELP ME PLEASE

2

Hey there!

In Looker Studio, there is no way to conditionally hide a table or chart. So, the first and last parts of your ideal state won’t be possible.

As a workaround, I recommend entering a default value into the input box that you know will return no data. Something like “ENTER A VALUE”. Then, when users first open the report, they will see no data until they change the value of the input box.