Pivot Table Text Metric

[jtucker1972]

I'm trying to port over some charts from Tableau to Looker. Below is a table I was able to create in Tableau, but unable to figure out if this is even possible in Looker. The closest I've come to is using Pivot Chart, which only allows for numeric metrics, not text, which I have in the table below. I just wanted to see if this type of chart can even be recreated in Looker.

[sam8]

I think it's possible.

You've got the right idea - a pivot table should be able to show this. You can have one dimension for Round and one dimension for Pick Position.

The values in the center of the pivot table don't have to be numeric - they just have to be measures. If you have a Player dimension, you can make it into a measure by applying any aggregation to it. The post How do I turn a dimension of type string into a measure? talks about how to do this. For example:

measure: player_measure {
  type: string
  sql: MAX(${player}) ;;
}

This assumes that your database can perform MAX on a string (which is usually the case), and that the MAX of a single string just returns that string (also usually the case).