Calculating a Percentage Based on Filtered Item Type Counts

I am attempting to calculate a percentage based on a total task count sorted by total item types. The logic is something like this: (ItemType1+ItemType2+ItemType3)/(ItemType4)=%.

Basically, I am trying to calculate an error rate. Tasks in item types 1-3 are production units, whereas tasks in item type 4 are rework units. I would like to return this percentage for each employee. Here is my current set up. What am I doing wrong?

Find more posts tagged with

Comments

Elizaveta Bogdanova

Hey @Ali Moses, I've asked our Wrike Analyze Support specialists to look into this for you 👍

Ali Moses

@Elizaveta Bogdanova Thanks so much!

Renee Tibedeau

Was there a resolution on this?

Herine Kniazian

Hello @Renee Tibedeau and @Ali Moses!

Wrike Analyze doesn't allow summing non-numeric values, so you need to use filters with IDs instead.

In this particular case, you need to count Task IDs and filter them by Task Item Type. To filter, just click the dimension and select the option "Filter", then select the value that you need:

(COUNT([Task ID]),[Task Item Type])

You would need to repeat these steps for every item type. The final formula would look like this:

((COUNT([Task ID]),[Task Item Type])
 +
 (COUNT([Task ID]),[Task Item Type1])
 +
 (COUNT([Task ID]),[Task Item Type2]))
 /
 (COUNT([Task ID]),[Task Item Type3])

Although you can copy my formula, text isn't carried out and you still need to select the data pieces from Data Browser manually. However, once you do it for one data pieces, other will be read automatically. In the example below, I deleted the text [Task ID] and added [Task ID] from data browser only in the first line, everything else got adjusted automatically. Then I'd need to repeat the same steps with [Task Item Type] and add filters to every block:

Please note that parentheses are needed for every function on three levels:

COUNT: [Task ID] must be wrapped in parentheses
filtered blocks: every filtered block must have parentheses
sum of the filtered blocks: additional parentheses for the summed part are necessary

Finally, you can change the output type to Percentage by clicking the 123 icon of the formula:

I hope this helps!

Ali Moses

Thanks @Herine Kniazian! I'll give this a go!

Rhunda Armstead

Did this method work? I was not able to view percentages. I'm looking to get the percent of the grand total

Basudha Sakshyarika

Hey @Rhunda Armstead! 🙋🏻‍♀️ Apologies for the late reply—your comment was accidentally overlooked. Were you able to figure out the provided solution? If not, feel free to reach out to our support team here, or let me know if you’d like me to raise a ticket on your behalf. Thank you! 😊