CODEWITHSUNDEEP
looker-studio
Met Pasta
Met Pasta

Reputation: 47

Combine multiple fields in Data Studio into a single Field from same source

Is it possible to combine fields in Data Studio into a single data field?

Example:

Data Source - "ExampleSheet"

Available Fields - "Date", "Pet", "Food", "Movies"

Formula I need would take "Pet" and "Food" and turn them into "All the things"

But still be able to have the data align to add "Date" next to the new field.

So, the resulting table would look like this:

Date || Pet

Date || Food

Date || Pet

Date || Food

Date || Pet

Date || Pet

I know it's a long shot, but I want the data to be able to filter without breaking the source into another data source and concat the data into columns breaks the ability to align the data

I tried blended data, but it doesn't like the values being from the same source

You don't have to work it all out for me, just help point me in the right area if it is possible. Thanks for reading :)

Upvotes: 2

Views: 8811

Answers (1)

Minhaz Kazi
Minhaz Kazi

Reputation: 3168

You can create the new fields by using CONCAT.

Example: Pet Date would be CONTACT(Pet, " ", Date).

View About calculated fields to learn more about Calculated Fields in Data Studio.

Upvotes: 2

Related Questions