How to display grouped values as a percentage of that group?

Looker Q&A Looker
, , ,
1

Hello!

Here I have the number of orders grouped by market where each column represents the number of days it took to fulfil an order.

I created individual fields for each ‘day to fulfil’ using the following custom filter logic:

Instead of showing absolute values, I’d like to show a percentage of total orders, for each market.

Could someone please help me understand how this is possible?

2

Worked this out.

  1. Created another measure for total orders.
  2. Created individual table calculations for each day / total orders.
  3. Formatted as a percentage.