Success plans completion rate calculation

  • 16 June 2021
  • 2 replies
  • 196 views

When you are using success plans to track your long term projects, aren’t you always curious to check how much of it is complete and what is the progress made so far?

Of Course yes, and if I tell you that there is a seamless way to track that with just a simple data designer job, won’t you be excited to check how?

 

So here is how you can do it.

  1. Create a design designer to pull theCS Task object. This object contains all the tasks information of any CTA. Specifically to pick the tasks of success plans only, need to apply filter type= Objective as shown in the image and pick the below fields. We are bringing the count of all tasks under a objective and grouping by CTA, company.

ZMY9tvgnbxM7IzO8JRP6jESvx7TuLRGlGAchw34FK02VwVhbGtwnAvTYsz9IXKvokD7pGy7BH10ppd7aUz0JmXbnCIm7KIPUyQwUu6wlGXuyL3QKbUNxchGQ8C7Kdqo3KtVOtvWJ

 

pcCJG4T48cDR7bEG-DpdmmhN4KXWTUPIiGfDyi2bXwkKd1gJ5aarc2cR7dMC25oV_UxlI1QPbfnz1XggD3zH7Ygsmz5CuS4Pp0W4JPYYGYjN3vg9kb4MJSYR_Jc-VcVsNEAzH6J9

 

Note: If you have multiple success plans, then we need to add a success plan template name as well to filter out the required success plan.

 

  1. Then in the other data set just pull the count of only closed tasks similar to the dataset set in step 1 just with the filter extra for status.

bk7hjzNyiMMrPdld9Tqpa4U4KZC8aZGBwiYFWo_B0mAOYRVQyaiBB7OnABcH-0l2Lg9I0FYft7GMvNZlLpA8J8XVw_wBYfWh8YbdwaS5oiG6jhylGYBpJEzwlYPVir9wt-ge-75a

  1. Now we merge both the dataset and do a left join, the dataset with count of all tasks being left dataset to bring in closed task count and open task count into the same transformation.

8mUqOWMMp1kxBNhMrcL4LvMvkbrZVq76lWbQObHjHVbsQZC9tkt8vc7avImpWk6GdhJLuYsdROc5xLX7BCqnPUzvDYW75TrSQEFUN0tAwTQiOJc7N9QzAsOqPTFU-kpvqAAxyqYP

 

8fJ8XhKi9PyjkAp5Gfi--2su3XVPLDqYdVwybkuqleBWlMk8g_P2B2jZ9xxrb4nnDFkkfHtGjj19-sup1Q64isY8g4FWriD8RMS15t4uxzqNkbDeP81FJx0jpA3bv002lGghMH76

 

  1. In the next transformation, create a formula field to calculate the rate of completion using the task counts.

qojasX2ipa4BbLGXXIe2T75nHGTPzxEQvJBvuYGOdNdssm9FuKzDO2AoB1ziWCp82jDWVSAC7EPAvn2AthHSelC1FqS7cN7kxrvr1OoyjRgvns-mZHIcgnIBgYSH6mipsxhr4ESn

 

  1. Once you save you can click and preview the final data set how it looks like, to check the percentages.

_zH4y8LpZkKDQSUYDt9wSsu35MS0sPBhqNdFkuI-RCEHTR3nyN1TAyfmocsntsQlEbCicR9poheeM_kXmXvTB98Zi_8DMmKXOD13p5M_kgVvIvTXBEgVe8-PTzo4qY3RVP-1PwN4

 

Then run this job and schedule it to run daily, and you can see this dataset will be available as a data space in report builder on which you can build reports like any other dataset. Incase if you the data set to be available as an object, this option will be available in the configure section.

 

4Xt0V2UqsMz5OCnSxywuh_zzq4LUum5RyGnzMpXMpr09B6tlecegfBAYLy5T061keo4-I5aiW6C9n2J0sKmHwpPQ-1dmdcXbf9Ex_G8OuR1H1pdmQqDyWokLh-fSDcxpiOw5pOXx

 

Also, there is one more way to do this directly from the report builder, pulling the Call to action object and using the Closed Task Count and ALL tasks count fields in formula field.

But the catch here is you cannot apply any filters on tasks let’s say if you want to exclude tasks that are on-hold or not applicable for a particular company. If you don’t have any such filters, just directly use this overall counts to calculate easily.

 

 

Hope this helps, if you have any questions let me know in the comments.

 


2 replies

Userlevel 5
Badge +1

Thanks for sharing @Jyothsna . We are looking into boosting the use of Success Plans later this year and this definitely is a good way to measure (part of) the traction.

Userlevel 7
Badge +1

@Jyothsna awesome! thanks for sharing this content here.

Reply