Reporting on Opened vs Completed tasks | Community
Skip to main content
M
MeiganRe
May 17, 2021
Question

Reporting on Opened vs Completed tasks

  • May 17, 2021
  • 1 reply
  • 728 views

I would like to create a report that shows the difference between the number of tasks created and the number of tasks completed.

I have this so far: http://cmegroup.my.workfront.com/report/public/view?publicToken=kAg_d4Cii182DS5q3iiI5Hvrh_s3KjeCVI8LFrbqq77rk9Dq2I7H4zVsljEysjgvuPBLroJEqh5T1K0Hknrcb0707n1bNjBs&endcap

I'm expecting something similar to the attachment (although without the shading)

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

skyehansen
Community Advisor
skyehansenCommunity Advisor
Community Advisor
May 17, 2021

I can't see your report :) -- it tells me to log in to your instance.

My guess is that the most you can do is create a calculated field to indicate whether something is open or closed, and create a column graph with stacked columns to indicate a cumulative total and the split between the open/closed.

M
MeiganReAuthor
May 19, 2021

@Skye Hansen‚ - Do you have recommendation on how to write the calculated field?

Also attached screenshot of my report. I'm using Entry date and Actual completion date and I would like to get those on a comparison chart.

skyehansen
Community Advisor
skyehansenCommunity Advisor
Community Advisor
May 19, 2021

there are always a number of ways you can do it. I would probably say something along the lines of "if the actual completion date field is blank, then it's not complete, otherwise it is complete", so... making it up as I go along and not actually testing this calculation: IF(ISBLANK(Actual Completion Date), CONCAT("INCOMPLETE"),CONCAT("COMPLETE")).

But you can pretty much pick your line in the sand. "if the status is X, Y, and Z, it's complete, otherwise it's not complete" for example, would work. And so on.

Terms & ConditionsAccessibility statement

Loading footer...