Hello,
I trying to create a cumulative % of a revenue metric in Looker Studio and and cant find a way to do it. I can see a running sum but not cumulative %. Is there a way to achieve this Looker Studio?
Hello,
I trying to create a cumulative % of a revenue metric in Looker Studio and and cant find a way to do it. I can see a running sum but not cumulative %. Is there a way to achieve this Looker Studio?
Not directly, no. You’d need to be able to reference that running sum elsewhere in order to get a cumulative percent.
If you implemented a running sum in your data source, then you could create a field in Looker Studio like: running_sum_of_x / SUM(x)
Including a cumulative percent as one of the preset options would be a reasonable feature request!