Description:
I am encountering a limitation in Looker Studio when trying to calculate percentages of a total while preserving filtering functionality IN Subsequent Calculations.
Issue:
- I want to calculate the percentage of a metric (Booking Amount) relative to its total sum. AND Resue it for other Calculations.
Example: Percentage of Total Count of Orders * Booking Amount - However, I need this percentage calculation to dynamically update when I apply filters to the data in the Looker Studio report.
- The current workaround of pre-calculating the total sum outside Looker Studio removes the filtering capability.
- The blended data source solution is complex to implement and may not be suitable for all users.
Proposed Solution:
- Allow the use of window functions (like OVER) or similar functionality within Looker Studio calculated fields. This would enable users to calculate percentages of total that respond to filters within the report.
Example: SUM(Booking Count) / SUM(Booking Count) Over () - Alternatively, provide a more streamlined way to create blended data sources for this specific use case, potentially with built-in filtering options.
Impact:
- This limitation is hindering the ability of Looker Studio users to create accurate and insightful reports that incorporate percentages of total values.
- Addressing this issue would significantly enhance the platform's capabilities and user experience.
LinkedIn
Twitter
