search field

Looker Q&A Looker Studio
1

Hi team, I need to generate a search of 3 columns in a table of products, I need to generate the search or by reference, or by category or by descricpión, but that does not discriminate by uppercase or lowercase. and that everything is in a search field.

I did it with a beta viewer but the whole report becomes very slow, just by typing in that search bar it crashes.

2

@Andres_Orozco

What you’ve described is not resource consuming unless the data behind the scenes are not optimized for data viz purposed (more that 10M of rows to evaluate).

But some conditions of testing can impact considerably the performance. Your beta viewer is on Chrome or on another browser? Chrome is recommended for Looker Studio.

Can you describe how you filter your data thanks to search field? Maybe your solution is not optimized. 1 text parameter, a calculated field and a chart filter should do the job.

Mehdi

3

Dear friend, that’s not a lot of information

33,000 rows, but the problem I have is that with the native looker controls it does not look for the info in the tables, I must place a filter by column.

But when I put a looker studio add-in, which searches in all the columns that I want (in this case 3 columns) is completely blocked or takes a long time to search.
share link test report.

https://lookerstudio.google.com/reporting/e07eda62-b7ad-4431-9cf4-c7fc6b98e6b0

4

Hi,

Not sure if this is the complete solution but maybe you can try the following?

  1. Create a Parameter (called “Search”)

Beginner_0-1750861756908.png
Beginner_0-1750861756908.png1245×512 22.1 KB

  1. Create the following calculated field that references your 3 fields that you want to search and the above parameter (“Search”). We will name this field as “Filter” for now.

(Below CORRECTED on 26th June)

CONTAINS_TEXT(LOWER(Field 1), LOWER(Search))
OR CONTAINS_TEXT(LOWER(Field 2), LOWER(Search))
OR CONTAINS_TEXT(LOWER(Field 3), LOWER(Search))

  1. On the table that you want to search, apply the above “Filter” calculated field, as a filter

Beginner_2-1750862547157.png
Beginner_2-1750862547157.png1152×434 21.6 KB

  1. Drag the “Search” parameter created in step 1 to your dashboard area (this should create a input box).

  2. Test to see if it works as you want to.