4 Replies Latest reply on Sep 6, 2018 1:48 PM by Deepak Rai

# Calculating the Percent of One Value to Another In Same Filter?

Very hard to explain. I have a data field called "Email Type" - Email Type has two possible variables. Request and Acknowledged.

I am trying to get a percentage of Request that were Acknowledged in a specific time/hour. I can get each to show me % of the total sent but not one from the other.

For example. At 12:00 AM - 203 Request were sent and 69 were Acknowledged. When trying to calculate % my results will only give me each as a % of the total number of Email Type or of 272.

I am looking for what % of 203 is 69, but instead I get back what % Request and Acknowledged each is of the 272 total.

I think it has to do with the fact that they are the same field but I have tried everything.

Thanks.

• ###### 1. Re: Calculating the Percent of One Value to Another In Same Filter?

Hi John,

Create a calculated field like below

1)

Request:

If ATTR([Email Type])="Request"

then

SUM([Number of Records Column] )or COUNTD([Any distinct column to count])

END

2)

Acknowledged:

If ATTR([Email Type])="Acknowledged"

then

SUM([Number of Records Column] )or COUNTD([Any distinct column to count])

END

3) Acknowledged %

Acknowledged/Request

COUNTD([Any distinct column to count]) - Means countd of any ID Column

If you have only one record for the email type then use SUM(Number of records)

Hope this helps

BR,

NB

• ###### 2. Re: Calculating the Percent of One Value to Another In Same Filter?

Thanks for the help, but it didn't really work. Maybe I don't know how to  add it to my worksheet?

I created the three calculated fields, but it does not show when I add to the worksheet.

• ###### 3. Re: Calculating the Percent of One Value to Another In Same Filter?

Hi John,

Attach a workbook with sample data

it would be easy to decipher whats going wrong

BR,

NB

• ###### 4. Re: Calculating the Percent of One Value to Another In Same Filter?

({Fixed [Your Time]:COUNT(If Email Type="Acknowledged" THEN Email Type END)}  / {Fixed [Your Time]:COUNT(If Email Type="Request" THEN Email Type END)})*100