I have a Google Spreadsheet that has a list of entries that is like a database of groups. Each group has corresponding info like, contact email, city, etc. This information is connected to Looker Studio in the form of separate scorecards. Everything is showing up correctly. However, when I first log into Looker Studio to view the report, each score card shows all the entries at once (for ex., it shows emails of all entries at once), until I select a group using searchtext or the table.
How do I adjust this in a way that upon page load, no information shows up, unless someone selects a group from the table above, or uses the searchtext to find the group? I've tried a variety of formulas, but nothing seems to work
Could you add a filter with a default value that doesn't match any information? Like "enter a group here" or some other string.
User | Count |
---|---|
3 | |
3 | |
1 | |
1 | |
1 |