0

Example on Rollup

Can someone please show me how to use Rollup function in Calc

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi adand ,

    The Rollup function is specifically an asset-based calculation. If you have not created a virtual view with assets, then this function is of no use. Also, it can only run on a Periodic frequency, not on Value Change.

    If you have a virtual view that has assets, you will want to pick that view using the Asset Path. Then you will want to select a parent asset type from the Asset Type drop-down. In my screenshot, the PumpingStation is a parent asset of a Pump asset.

    The first parameter in the function is the source path which is the 'Asset Path + %Asset%'. We use %Asset% as a wildcard as each asset has a unique path. The second parameter is one of the Rollup operations. In my example, I am using Average. The third parameter is the child asset type. In this example, the Pump asset is a child asset of the PumpingStation. The fourth parameter is a tag of the child asset. In this case, each Pump has a Flow tag.

    So every hour this calculation will average the Flow tag of each Pump and roll that value up to its parent PumpingStation.

    The output must contain the wildcard, %Asset%, as is the case for all asset-based calculations.

    Each PumpingStation will now have an hourly [PumpFlowAvg] tag.

    Like
    • adand
    • adand
    • 1 mth ago
    • Reported - view

    Thanks for the help

    Like
print this pagePrint this page
Like Follow
  • 1 mth agoLast active
  • 2Replies
  • 42Views
  • 2 Following

Support Center