How to Edit a Calculated Field in Looker Studio

Last Updated: December 17, 2024

Note: Google Data Studio is now known as Looker Studio.

In order to edit a data source specific calculated field, follow the steps below:

Step-1: Navigate to the Data Source Editor.

Step-2: Click on the ‘fx’ symbol next to the calculated field you want to edit:

Change calculated field

Once you clicked on the ‘fx’ symbol, it will open up the formula editor:

change formula

Step-3: Rename the calculated field and/or change its formula.

Step-4: Click on the ‘Update’ button at the bottom right-hand side.

In order to edit a chart specific calculated field, follow the steps below:

Step-1: Navigate to the Report Editor.

Step-2: Select the chart whose calculated field you want to edit. For example, let’s say we want to edit the ‘Conversion Rate’ calculated field of the following table. So we would select that table:

Select chart

Step-3: Find the chart specific calculated field you want to edit in the chart properties panel. Here is how the chart properties panel looks like:

Chart property panel 1

Chart specific calculated fields appear in the chart properties panel with an fx symbol on the left. 

However, this symbol appears only when you hover your mouse over it:

hover

Step-4: To edit the chart specific calculated field, click on the ‘fx’ symbol. This will bring up the formula editor where you can edit your field as needed:

edit formula

Step-5: Click on the ‘Apply’ button.

My best selling books on Digital Analytics and Conversion Optimization

Maths and Stats for Web Analytics and Conversion Optimization
This expert guide will teach you how to leverage the knowledge of maths and statistics in order to accurately interpret data and take actions, which can quickly improve the bottom-line of your online business.

Master the Essentials of Email Marketing Analytics
This book focuses solely on the ‘analytics’ that power your email marketing optimization program and will help you dramatically reduce your cost per acquisition and increase marketing ROI by tracking the performance of the various KPIs and metrics used for email marketing.

Attribution Modelling in Google Analytics and BeyondSECOND EDITION OUT NOW!
Attribution modelling is the process of determining the most effective marketing channels for investment. This book has been written to help you implement attribution modelling. It will teach you how to leverage the knowledge of attribution modelling in order to allocate marketing budget and understand buying behaviour.

Attribution Modelling in Google Ads and Facebook
This book has been written to help you implement attribution modelling in Google Ads (Google AdWords) and Facebook. It will teach you, how to leverage the knowledge of attribution modelling in order to understand the customer purchasing journey and determine the most effective marketing channels for investment.

About the Author

Himanshu Sharma

  • Founder, OptimizeSmart.com
  • Over 15 years of experience in digital analytics and marketing
  • Author of four best-selling books on digital analytics and conversion optimization
  • Nominated for Digital Analytics Association Awards for Excellence
  • Runs one of the most popular blogs in the world on digital analytics
  • Consultant to countless small and big businesses over the decade

Free GA4 Mastery Course (30 Days Access) – Certification Upon Completion! (Over 4000 Students)

X