running percentage of total

I would like to take the running_total measure type [https://docs.looker.com/reference/field-reference/measure-type-reference#running_total],

but instead of displaying a raw number,

display it as a percentage of the total-total.
Due to ’ This means that you should not reference a running_total measure within another measure’:
I don’t think this is possible by combining measures.

I am stuck, not really knowing where to begin, to attempt to work-around this.

My overall aim is to essentially normalize the two lines in this graph (to make comparing trends easier)

[I also want it to go in reverse, i.e. running_total of 0 is 100%. running_total == total is 0%…but one problem at a time :D]

0 4 956
4 REPLIES 4
Top Labels in this Space
Top Solution Authors