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!
User | Count |
---|---|
5 | |
1 | |
1 | |
1 | |
1 |