"Percent_of_total" by a different field

Looker Q&A Looker
1

i want to create a returnQuote by a total from a field.
In my Example:
I want to calculate the Quote Of Returns always from the total of MovingAvgPrice

image
image1845×292 44.4 KB

In my Example the TotalLine (green) is correct but not the values above in the Column Quote of Returns.

This are the correct values:

image
image1200×286 11.2 KB

(my: 1700_sandbox.returns.view / 1700_returnsCustomer)

Find Solution by AI :slight_smile: (great)
${returnsCustomer.Returns} / ${returnsCustomer.movingAvgPrice:total}
need just a little CustomCalculation.

hm..can not set to solved….why :slight_smile:

2

Glad you could find an answer with AI :smiley:

I think you can’t mark it as solved until someone has replied? You could try replying and then marking that reply as the solution.