2 Replies Latest reply on Sep 4, 2018 11:39 AM by Swara S

how to find the percentage of the sum total of metric values

Hi,

I have a requirement as below:

I have four metrics.  the percentages of the metric values are to be shown below the sum total of the metric values and should be calculated as

% metric B =(sum total of metric B/ Sum total of metric A)*100

% metric C =(sum total of metric C/ Sum total of metric A)*100

We can show the sum total of the metris easily..but can can we show he percentages as well.

• 1. Re: how to find the percentage of the sum total of metric values

Swara,

You can not show this on next row as you want on same sheet. what you can do is you can create this calculation on another sheet and then on Dashboard you can align it with your original sheet.

% metric B = sum(sum total of metric B)/sum(metric A )

% metric C = sum(sum total of metric C)/sum(metric A )

• 2. Re: how to find the percentage of the sum total of metric values

Thanks Ankit.. but the problem here is that the report height may vary from time to time depending upon the data..Is there a way such that the report height increases or decreases on it own without affecting the row heights in the reports?