Solved

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

  • 20 November 2022
  • 1 reply
  • 79 views

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? 

icon

Best answer by pete-1651452632 23 November 2022, 01:43

View original

This topic has been closed for comments

1 reply

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.