Custom field for Remaining Status for Request

[Kundanism]

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.

[Rafal_Bainie]

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

[Kundanism]

Thank @Rafal_Bainie 

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

Mvh

Kundan

[Rafal_Bainie]

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

[Kundanism]

Hi @Rafal_Bainie 

All these are issues, created under a request queue project set up. So, i was trying to create a custom field, for example "Remaining" which is equal to "=(No. cases in status "New" + No. of cases in "In Progress)". The result should be in count. Any idea if you, such text mode to count the numbers from two diferrent statuses (New + In Progress) can summed up and shows as a combined value?

Appreciate if have to share. Have a nice weekend!

Mvh

Kundan.

[Rafal_Bainie]

I realized that to achieve what you are after an issue would have to have 2 categories applied at once and included twice in the same chart. I don't think that WF database will allow for such structure. especially if you want to lay this over timeline
The best I was able to get was this:

formula is simple:

IF({status}!="CLS","Remaining","Closed")

No values - I would have to force recalculation on these issues, so please ignore them

without timeline that would kind of work:

[Rafal_Bainie]

You could build 3 separate reports like the one above:

1. data from 2months back, 

2. data from last month

3. data from current month

lay them out nicely in a row on dashboard...