Q: How can I perform this calculation in ARIS Data Feed? Given that these values are from different streams?
Calculation: (Model Count 3 “Total Models per Department” / Model Count 2 “Aggregate Total Models”) e.g. ("Design Build" Department = 10 total models /41 "overall" total models)
Steps Taken:
- I tried using Data Feed>Operator>Combine: Not feasible because I don’t have a "primary key" column to combine all steams (1,2, & 3).
- I also tried using Data Feed>Operator>Concatenate: I was able to successfully connect and add streams (2 & 3) to my main stream. However, I still can’t perform the desired calculation for it just appended the (model count 2) and (model count 3) as extra rows in my main table.
Perhaps this is not the best solution to perform this calculation, and so I'm also open for any alternative solutions. Thanks in advance!
Stream 2
Description automatically generated" width="283" height="215">
Stream 3
Description automatically generated" width="279" height="276">
