Skip to main content

I know that I can perform a Value-Based search for a condition and analyze search results to get the duration of any given event. For example, if I want to know for how long a process temperature  was below 120’ over the last month, the search results will tell me that one of the durations was 5 days, others may be 5 minutes and so on. 

i also know that I can create context items and use a context view to show the duration and even apply conditional formatting on the duration

However, my question is: Is there a way to save the duration in a reusable calculated tag so that I can apply some logic based on the duration e.g. increase severity of an excursion the longer the duration was. or even plot the duration on a time-based trend?

Hi Yves - thanks for your question!

Unfortunately, there is not a way to store the duration of your search results as a tag or time-based trend.

However, we can analyze search results based on aggregated values (including duration) of each search results using our Event Analytics feature. You can apply filters on the aggregated values using refinement in the histograms as well as investigate multivariate relationships using the parallel coordinates plot. You can find more information about Event Analytics and how to access the feature here: https://userguide.trendminer.com/en/event-analytics.html.

Alternatively, you can export the value-based search search results along with the duration data to Excel.

I hope this helps and please let me know if you have any other questions Yves!

KL


I would like to add that converting event durations into a tag directly would be relatively simple with the new custom calculation feature. Using Python custom calculations, you perform the value-based search in the Python formula, and output the duration as the tag values.

The custom calculations are an expert feature that requires an additional license. Typically someone from TrendMiner should be able to support you with the Python logic for your use case though. Could definitely be worth reaching out to your CSM or account manager if this is a high value use case or if cases like this come up more often!


Wouter,

This is excellent. We do have an ML-Hub license and one of our Python-experienced Information Services specialists has the license assigned to him. I will make sure him and I tackle this together. 

Thank you very much for the hint


Reply