Hi I have these values:
Product | Sales | Price
A 1500 10
B 5000 15
C 250 25
D 1700 30
Leader sales product price is 15
Want to get
Product | Sales | Price | Price Diff
A 1500 10 -33%
B 5000 15 0%
C 250 25 67%
D 1700 30 100%
How do i achieve this in looker studio using all my dimensions values? Thank you!
Solved! Go to Solution.
Hey there! I don't think what you want to do is possible as the max is based on a different dimension, but there's a more manual workaround. You could create a parameter (https://support.google.com/looker-studio/answer/9002005?hl=en#zippy=%2Cin-this-article) for "Price of product with most sales" and add a control to the report canvas so you can type in the price manually for the product with the most sales.
Then, create a calculated field (https://support.google.com/looker-studio/answer/6299685?hl=en#zippy=%2Cin-this-article) that uses this parameter and add it to the table. For example:
(price - <parameter>) / <parameter>
You can set the result as data type "Percent".
I hope this helps!
Anyone? Thanks!
Hey there! I don't think what you want to do is possible as the max is based on a different dimension, but there's a more manual workaround. You could create a parameter (https://support.google.com/looker-studio/answer/9002005?hl=en#zippy=%2Cin-this-article) for "Price of product with most sales" and add a control to the report canvas so you can type in the price manually for the product with the most sales.
Then, create a calculated field (https://support.google.com/looker-studio/answer/6299685?hl=en#zippy=%2Cin-this-article) that uses this parameter and add it to the table. For example:
(price - <parameter>) / <parameter>
You can set the result as data type "Percent".
I hope this helps!
Thank you Edgard. That will do the job.