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">
Veronika Ellermann on
Hi,
if you want to combine multiple streams you need a "combine stream" operator. When you include that stream, you need to make sure that you have one common column in all streams you want to combine; e.g. Department 3 (?).
However, as far as your aggregated model stream is concerned- for what do you need that? Potentially, you may need to revise the entire structure of your data feed.
Best,
Veronika