Calculating a Percentage Based on Filtered Item Type Counts

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

Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover

Lisa Wrike Team member Become a Wrike expert with Wrike Discover

Lisa Thanks so much!

Was there a resolution on this?

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!

Herine Community Team at Wrike Wrike Product Manager En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online

Herine Wrike Team member En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online

Thanks Herine! I'll give this a go!