AnsweredAssumed Answered

Conditional rollup analysis

Question asked by CBBakke on Jul 18, 2019
Latest reply on Oct 1, 2020 by sraposo

I currently have a Rollup analysis that sums an attribute of an element's children and stores that value in a PI point.  I would like to modify this analysis so that the attribute value of the child element is only summed when a certain condition is true.  

 

Current rollup is for a site, and it sums the sqft (metadata attribute value) of each building that is a child of the site and stores that in a site sqft attribute (PI Point).   Now, I would like to only include the sqft of a building if it meets certain qualifications, such as metered or occupied.    

 

How can I do this with asset analytics?

Outcomes