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

4db1ee8b-dd6a-4a45-b770-ec4b61f262bf.png

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:

2891812c-e95b-4d69-9a62-74aca12ae1ac.png

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? 

Solved Solved
0 1 825
1 ACCEPTED SOLUTION

Worked this out. 

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

View solution in original post

1 REPLY 1

Worked this out. 

  1. Created another measure for total orders. 
  1. Created individual table calculations for each day / total orders.
  2. Formatted as a percentage.
Top Labels in this Space
Top Solution Authors