Skip to main content
Question

Adding aggregations results in a context table

  • December 4, 2025
  • 4 replies
  • 27 views

Rdhernanfr
Compass

Is it possible to add aggregation results in a context table? For example, I would like to have a table with all the cleaning registered in the last month with the resources consume such as water, chemicals, steam, etc. I can calculate the volume of these resources consumed with the integral aggregation, however I cannot add them in a context table. How can I add it. 

Column of water added for explanation proposes. 

 

4 replies

Jef Vanlaer
Community Manager
Forum|alt.badge.img
  • Community Manager
  • December 5, 2025

Hi ​@Rdhernanfr 

I see 2 options to accomplish this directly from within the TrendMiner User Interface:

  • Via Event Analytics: search for your periods of interest (either via a Value Based Search or a Context Item Search, since you already have the items). Once the results are available, add calculations on search results for the parameters you are interested in and then open Event Analytics. The tabular overview available there provides the values in a similar form as a context table.
  • If you want to write these parameters to context items, you can create new context items based on the above search via the actions menu on the search results. Note that this functionality is only available for historical searches at the moment.

You get a lot more flexibility in adding data to context items when using the TrendMiner sdk through scripting. Please reach out to your CSM to discuss this in more detail if you would be interested.

Kind regards,
Jef


Rdhernanfr
Compass
  • Author
  • Compass
  • December 5, 2025

Thank you very much Jef, that means that for the moment if it is not via script, then it is not possible to capture the values automatically in a context table via monitors. correct? To do it via search valued based is of good help, hopefully soon this could also be added with monitors. 

 

Best Regards, 


Jef Vanlaer
Community Manager
Forum|alt.badge.img
  • Community Manager
  • December 5, 2025

Correct. There are a couple of related Product Ideas on this Community already. Feel free to upvote the ones that are relevant to you (or add one if they don’t fully cover your use case):

 


Rdhernanfr
Compass
  • Author
  • Compass
  • December 5, 2025

Maybe complementing the ideas above it would be very good to have in the configuration of the ContextHub to add Statistics data or aggregations.