3 Replies Latest reply on Sep 12, 2018 9:25 AM by Kelly C

How to do a count distinct based off another calculation

Hi,

I'm  having some trouble trying to write the correct LOD calculation.  I have so many calculations upon calculations that I'm not sure how to connect them, but essentially what I'm trying to do is write two formulas:

1) The first formula is something like this:  Where I want to COUNT DISTINCT by Case ID the times that "In - Process - Untimely" appears in the calculation Calc Combined ack Timeliness.  Currently, this formula that I have attached does a count distinct by case ID but not specific to "In Process - Untimely"  I'm wondering what revision I need to make to this field without dragging the Calc Combined Ack Timeliness to the Filter and selecting "In Process - Untimely"

THEN my second calculation should do this

2)  Once I get the above calculation to work, I will apply that same logic to 2 other field names replacing the "In Process  - Untimely" with "Untimely" and "Timely".  Then want to be able to add the 3 calculations to look like the below, with all 3 fields adding to a distinct count by case ID of the three.

My apologies if that was confusing - I'm frustrated and confused with this.  I've attached the workbook with all the calculations I've been using.

All help is much appreciated!

Thanks!

• 1. Re: How to do a count distinct based off another calculation

I also forgot to add another snapshot.  Make this 3 calculations:

3)  my final goal is to get this final calculation using all the steps above:  where only the "timely" over that entire step 2 is calculated into a percent.

• 2. Re: How to do a count distinct based off another calculation

{Fixed Case ID:COUNTD( if Calc Combined=In Process  UnTimely" THEN case ID END)}

{Fixed Case ID:COUNTD( if Calc Combined=Timely" THEN case ID END)}

{Fixed Case ID:COUNTD( if Calc Combined=UNTimely" THEN case ID END)}

Then SUM The above as:

SUM(Calc1)+SUM(Calc2)+SUM(Calc3)

Thanks

Deepak

• 3. Re: How to do a count distinct based off another calculation

Thank you Deepak!  Again, you've been so helpful!