Fusion: Getting Project Count by Status

[SuryaLakhani]

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. 

[Lawson02]

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.

[SuryaLakhani]

Thanks for sharing! Sort definitely would be an upgrade, but it still relies on 1.result/2.result, and I wanted to get away from that as I have seen intermittent failures with that. Or maybe the failures resulted from the conditional logic that I have in there. 

Will try this!

[Lawson02]

Add a null check. if(get(4.array; "2.result") = null; 0)

[Sven-iX]

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" )  }}