2 Replies Latest reply on Sep 26, 2018 5:08 AM by Vishant Nayak

# Calculate the completion rate for the said duration with distinct count and also have % of completion

Hi Team,

Please can you help in resolving the below issue.

I am unable to get the below calculations. Attached sample workbook

1. How to calculate distinct count of completion per duration . For ex..here I am calculating number of user updating <10 days, <20 days. The issue, if the user is updating twice for different dates then the count of user should be taken with the latest update date.

In the below calculation

a. DATEDIFF('day',[Date Updated],today())

b. if [Date Diff]<=10 then "10" else "Not Updated" END

for ex: <10 days although the total distinct is "62" her total of <10 days is 8 - Updated and 60 - Not Updated = "68"

2. Also want to display % of update v/s not updated user's for above view said duration and also for region wise.

Thanks,

Vishant

• ###### 1. Re: Calculate the completion rate for the said duration with distinct count and also have % of completion

Hi Vishant,

Is this what you are looking for?

IF yes, you can use the same logic for remaining groups.

~Tushar

• ###### 2. Re: Calculate the completion rate for the said duration with distinct count and also have % of completion

Hi Tushar,

The logic works ...can you also show how to display the completion %.

Thanks,

Vishant