9 Replies Latest reply on Feb 1, 2019 1:35 PM by Deepak Rai

# How to calculate the rate or percent of a measure using a criteria?

So I am attaching a workbook where I have my city, my customers , their episode Ids (customer ID), the period of time that had a service, service type and number of cases.

I like to calculate the rate by city of customers that had a broken car  (where the case is equal to 1) during the post period. all customers had a Car service during trigger(that's the basic and i can use the car purchase during trigger as my denominator) but not all of them had a broken car during Post period. they might have other services as well. so for example for my city of Chicago, they had one customer ID that had a broken car during Post period so their broken car rate is 50% because they had two customer IDs, but one had a broken car in the post period. so the denominator for them is 2 and the numerator is 1. I like to use calculations to do that and not table calculations.

My final view would be a  column that shows the city and Broken car rate.

Tony

• ###### 1. Re: How to calculate the rate or percent of a measure using a criteria?

Can you reattach as 10.5 Version  from File Menu>Export as Version

• ###### 2. Re: How to calculate the rate or percent of a measure using a criteria?

Hi Deepak, I just reattached it. Thanks!

• ###### 3. Re: How to calculate the rate or percent of a measure using a criteria?

You have Spelling Mistake for Vegas. I Corrected it so now you have this:

Thanks

Deepak

If it Helps, Pl Mark it Helpful and CORRECT to Close Thread

1 of 1 people found this helpful
• ###### 4. Re: How to calculate the rate or percent of a measure using a criteria?

Thanks Deepak. This is what I needed! Amazing

Tony

• ###### 5. Re: How to calculate the rate or percent of a measure using a criteria?

• ###### 6. Re: How to calculate the rate or percent of a measure using a criteria?

Hi Deepak, one last question, what about if i wanna limit the Car broken rate to the Post Period only and not the trigger?

• ###### 7. Re: How to calculate the rate or percent of a measure using a criteria?

I knew you would Come back for this, I was just waiting, when:

Thanks

Deepak

• ###### 8. Re: How to calculate the rate or percent of a measure using a criteria?

Great, but whenever I put the Period field in the filter and I filter on Trigger, the percentages change. I don't want the percentages to change regardless of the Period filter.

Any way around it?

Thanks for the help

• ###### 9. Re: How to calculate the rate or percent of a measure using a criteria?

Here if You would add FILTER to CONTEXT , The view will Change so you should not Add it to CONTEXT as In that Case Filteration is Done beforehand.

Thanks

Deepak