Possible to group values and turn them into a chart?

[ranma1122]

Hello everyone,

I'm new to using Looker for visualizations and excited to learn more about the program. I'm coming from a Tableau background so I'm hoping to gain insight and practice another visualization tool.

On the back end, I'm using Google Sheets to connect the data; nothing related to SQL. 

I am wondering if there is a way to group values, similar to Tableau, in Looker and create visualizations using so. 

Example of Original Data ( Link to the Google Sheet )  

What I'm Aiming To Do (Tableau Example): 

• Create a custom group with specific values: 
  • 4 Projects on Hold 
  • 3 Projects Complete
  • 3 Projects Dropped
• Turning Them Into: 
  • 3 Projects Complete -> Complete
  • 4 Projects on Hold + 3 Projects Dropped -> 7 Incomplete 

Tableau Example:

Essentially, turning a pie chart (Sheet 1) into a custom grouped pie chart (Sheet 2)

 -->     

But I'm stuck at this step... which pretty much gives me the pie chart from Sheet 1 (above), but I'm wondering if there is a way to create custom groups within Looker to get it like Sheet 2 (above). 

Thank you

[prabhakaran_mai]

You could use Custom Dimension with a case statement to achieve this grouping

https://cloud.google.com/looker/docs/custom-fields#creating_a_custom_dimension_using_a_looker_expres...

[a_shah · Accepted solution]

You may try adding a custom field in Looker Studio like below:

Add a field

Next, create the expression like given below

Create the expression

And then place the grouped field in the pie chart in Looker studio like shown below.

Add to the pie chart

~Ashish

[ranma1122]

this was helpful! thank you. It seems with Looker the way to create custom groups is through creating the field; but there does not seem to be the ability to create them in a drag and drop custom method like Tableau. Good information to know. thank you!