This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

How to create a new field as Metric？

Posted on 05-31-2024 01:46 AM
Janice414
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

I have three metrics. "cost%" is generated by “cost" comparison calculation.

Now I want to add a new field to multiply "cost%" by "ROI".

How should I write the formula? GPT can't solve my problem.....

Janice414_0-1717144449159.png

0 1 186
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
Mick-03
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hi @Janice414 

If you generated the cost% either as stated in the documentation or as a percent column, you can refer to both in the field picker. This allows you to calculate new metrics for ROI multiplied by cost% as a table calculation.

I hope this helps you.

How to calculate percent of total:
https://cloud.google.com/looker/docs/best-practices/how-to-calculate-percent-of-total

0 Likes