Hi All,
Could you please let me know how I can add a search box on the lookerstudio, for the user to perform a search on all google sheet file?
If you're just looking to be able to search a particular field, like Last Name, you can use an input box control with "contains" on that field. Note that it is case-sensitive (but with some creativity and LOWER() you can hack that too.)
If you want to search multiple fields at once, you can create a concatenated field (ie, CONCAT(Last Name, First Name, City, Department) and use that with the Input Box control.
User | Count |
---|---|
4 | |
1 | |
1 | |
1 | |
1 |