Fusion: Getting Project Count by Status

Question

Hi,

I am trying to find an easier way to do this, my current solution works, but intermittently results in empty values. I am looking at the number of projects in each status and then pushing it back to Workfront for daily reporting.

I am searching for a list of projects, then using a numeric aggregator module to get the number of projects in each status (this works perfectly). The aggregator module gives me an array of collections, with each collection containing Status and the count. Then I use an Arrar Aggregator module to combine all the statuses and counts into a single array. Finally, a Set Multiple Variables module will be used to set the count of each status to a matching variable that can be used in the workfornt update call. The Set Multiple Variable is where empty values are recorded intermittently.

Sven-iX · Accepted Answer

I'm not clear on what you have in the setvalue module.

If all you want is a count per status, this is what I would do: For each unique status in the collection, it'll use map() to create the list and get the list's length.

retrieve the status count e.g. for CUR with {{ get( 155.statuses ; "CUR" ) }}

Lawson02 · Answer

Edit: You do not need the 1 in the value space in screenshot 1. I thought you did but I guess not.

I get results from set multiple vars CPL: 110 and DED: 17

I used sort on array so that I could hard code the get() function's values 1, 2. If you don't want to do this you don't need to sort and can just use conditional logic to get each value in the right spot.

Sign up

Login with SSO

Login to the community

Login with SSO