Hello everyone,
I’m trying to implement a custom bonus calculation in Looker Studio (formerly Data Studio) and keep running into a roadblock:
Business logic:
If an employee works 10 or more driver shifts, they get the full bonus defined in the field Bonus for 10.
If they work fewer than 10 driver shifts, their bonus should be prorated:
I expected to solve this with a Table Calculation using a CASE formula
What I’ve tried:
Switched my chart to type Table.
Clicked + Add metric in the Metrics panel.
Scrolled to the bottom of the list, looking for an entry called Table calculation (calculator icon).
…but there is no “Table calculation” in my metrics menu. I’m connected via the native Google Sheets connector.
Questions:
Where exactly should the Table calculation option appear in the UI?
Under what circumstances is this feature disabled or hidden?
If it’s not available for my connector, what is the recommended workaround to implement this prorated bonus logic in Looker Studio?
Thanks in advance for any guidance!
LinkedIn
Twitter
