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]