Dropdown control in Looker Studio

[luislizardi]

Hello,

I have one question.

I am trying to make a dropdown box in Looker. My data is in different columns.  Is is possible to make a dropdown list or the input has to be in one column.

Let me clarify it. The dropdown has to import the data from different columns of a worksheet. Is it feasible to make a dropdown list that way? 

Do you have some examples?

I am beginning to feel frustrated. 

Sincerely,

Luis Lizardi

[Sichali1]

Hi,
Yes, you can create a dropdown list in Looker Studio that pulls data from different columns in your data source. Here's how you can do that:
To make a dropdown list from data in multiple columns (like Name and Hobby), you can concatenate the two columns into one combined column using the CONCAT function. For example, if you have Name and Hobby in separate columns, you can create a new field in your data source with this formula:

CONCAT(Name, ", ", Hobby)

This formula will combine the Name and Hobby fields with a comma and space, creating a single column of concatenated values. You can then use this combined field as the dimension in your dropdown filter.
Click the link below for the expected output:
https://lookerstudio.google.com/reporting/a8c75781-a167-47c6-bc4a-125f00062f1a/page/9d4BF