Custom field for Remaining Status for Request

Hi

Looking for your expertise, appreciate for recommendation.

Trying to create a custom field name as "Remaining Cases". The field should collect visualise in numbers.

Formalua to understand;

No. of Remaining Cases = No. cases in status "New" + No. of cases in "In Progress".

Any suggestion???

Mvh

Kundan.

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

Community Advisor

With Fusion I got to this:

I got input using 3 API calls along these lines

is this what you were looking for? not sure if that is doable directly in WF

Level 10

Actually, we donot have Fusion. But trying to get this overview, attached for your reference.

Mvh

Kundan

Community Advisor

if you are after such chart than I have no idea how to recreate this chart in Workfront without previously performing calculation I described above.

However, what do you mean by cases? are these tasks or issues?

If these are tasks than Metrics page does summarize this data nicely:

Same is not available for issues unfortunately

Sign up