I’m relatively new to Looker, so this may be an incredibly simple ask, but how do you build your table calculation to select specific pivoted columns? I can see how to select the measure I’m hoping to create a calculation for, but since it is pivoted and there are multiple versions of the same measure, how do you specify one pivoted column versus another for the same measure?
Example:
To be more specific, I am trying to just get a percentage by a calculation like this: (Transaction Count - Yes) / (Transaction Count - Total). I just don’t know how to specify anything more granular than just the Transaction Count measure. Please help!
It is pretty straight forward using a table calculation:
pivot_index(${<transaction count>},2)
/ ${<transaction count>:row_total}