How to show text field as pivot table metric?

[LR12345]

Hello, 

I use google sheets as my data source. Is it possible to display text field in pivot table as a metric? 

Attached file has sample input data, and expected result has what I was hoping to display using Looker studio pivot table. Thanks!

[sam8]

I think this is possible in Looker with a string measure, but not in Looker Studio. The only metrics in Looker Studio that perform aggregation are numeric, as far as I know.

[Sichali1]

Pivot tables require numeric metrics, but you can display text fields by using functions like MIN() or MAX(), which return the first or last text value alphabetically. For example, to show the smallest alphabetical status in a pivot table, use:

MIN(CASE WHEN Status IS NOT NULL THEN Status END)
Since there is only one status per project, this aggregation will work correctly to display the status in your pivot table. For coloring, use Conditional Formatting in Looker Studio to highlight different statuses. Click the URL below for the expected output.

https://lookerstudio.google.com/reporting/f3022467-7e65-4fad-bca9-1f25e9cc261f/page/mR19E

[sam8]

Awesome explanation!