Looker Studio: Creating percent of row fields

A common goal in Looker Studio reports is to create a field that displays the percentage of the current data value over the row total. This is sometimes referred to as a "percent of row" calculation.

 

I'd like to surface a neat trick that user Mim shared in the forums. By blending a data source with itself, you can get the row total as a regular field in the table. Then you can create a calculated field to divide the source field by the total field. Check out their Percentage of Row example for a step-by-step walkthrough!

 

Contributors
Version history
Last update:
‎08-14-2024 11:51 AM
Updated by: