


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.
Views
Replies
Sign in to like this content
Total Likes
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
Views
Replies
Sign in to like this content
Total Likes
Thank @Rafal_Bainie
Actually, we donot have Fusion. But trying to get this overview, attached for your reference.
Mvh
Kundan
Views
Replies
Sign in to like this content
Total Likes
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
Views
Replies
Sign in to like this content
Total Likes
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.
Views
Replies
Sign in to like this content
Total Likes
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:
Views
Replies
Sign in to like this content
Total Likes
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...