Pie chart based upon two dimensions

[ramon_vermeulen]

Hello Looker Community,

For one of our views we get a name column with a precalculated figure. Looker treats those two both as dimension fields. Ideally I would like to show a pie chart for this, any idea how I could achieve this? Because a pie chart only works with 1 dimension and 1 measure, and not two dimensions.

Table example:

name,some_value
foo,5820.12
bar,59129.14
biz,85.3

Greetings,

Ramon

[sam8 · Accepted solution]

Hey @ramon_vermeulen ,

A pie chart will definitely need a measure. Maybe use a custom measure to sum up `some_value`? It should return the same value while effectively changing the measure to a dimension. Then you could hide or remove the dimension.