Skip to main content
Menu

Questions & Answers

Ask your question and receive an answer from other TrendMiner users or the TrendMiner team

  • 56 Topics
  • 106 Replies
56 Topics
Jef Vanlaer
Community Manager
Jef VanlaerCommunity Manager
published in Questions & Answers
How to ask a question?

Do you have a TrendMiner question? Then the Community Category Questions & Answers is the right place to be. Here, you can ask your question to be answered by other TrendMiner users or our TrendMiner experts.How to ask a question?Make sure you are registered and logged into the Community. Create your account or log in via the LOGIN button top right or the links in the previous sentence.  Create a new topic using the CREATE NEW TOPIC button top right or this link. Pick Question as the topic type. Provide a good title and description for your question. Make sure to add enough detail, so others will understand the question. If possible, add a screenshot. Hit the CREATE button to post your question.Has your question been answered?If your question has been answered, make sure to mark the best answer. This will help other TrendMiner users with similar questions in the future.Other resourcesOur TrendMiner user guide provides a lot of information on the functionality available to end-users

920
Jef Vanlaer
Community Manager
R
Innovator
Roger PalmenInnovator
asked in Questions & Answers
TM_ tags for date&time: documentation?

I just found these tags in TM: TM_hour_UTC, etc. Is there any documentation on these? This is a builtin set of tags, or a specific datasource? And why do we have hour, but not minute? Because of the 1m index resolution this might not make sense?

131
R
Innovator
yracette
Pioneer
yracette
asked in Questions & Answers
Checking for Bad Tag(s) in Formula Builder

I used Formula Builder to create a calculation that is the Max of six (6) temperature tags to derive the peak temperature for monitoring.Is there a function or method that I can use to filter out tags that are reported with a Bad status by the source data historian system?As it stands, my peak temperature calculation stopped updating because one of the 6 tags is Bad in the Aspentech IP.21 data source

291
K
Employee
yracette
Pioneer
yracette
asked in Questions & Answers
Context Field Formatting

I configured Context Fields that are mapped to calculations associated to a value-based search . Once I search, then select results to create context items and map my calculations, I can see the fields in a Context Hub view.The Context fields I created get mapped to calculations that represent peak temperatures in the range of 1200 to 1400 ‘F. On the Context Hub view, I see results for my context fields with 3 or more decimal places and that is unnecessary. How can I format the values tied to the context fields / value-based search calculations to use 0 decimal places? 

202
F
Community Manager
yracette
Pioneer
yracette
asked in Questions & Answers
Monitor using Value-Based Search with Context Fields

I configured a value-based search and added calculations to the search. I created context items based on the search results and assigned a context type with associated context fields mapping to the value-based search calculations. Question is: if I configure a monitor using that value-based search and get the monitor to create context items with this specific context type , I see the context fields being listed with optional drop-down boxes. What do I do with these? Will the context item automatically fill-in the results of the calculations to the context fields?

221
F
Community Manager
R
Innovator
Roger PalmenInnovator
asked in Questions & Answers
Sharing to all users?

How to share a datasource to all users? I can't really find a good way to do that.We have an SSO-integration setup towards (A)AD, but have little control over that. Not sure if i could use the local identity provider and create a group that includes all (domain and/or local ) users.

444
R
Innovator
B
Explorer
brleonelleExplorer
asked in Questions & Answers
Event Counter on Custom Calculations

Hi,  I have been trying to set up an event counter using custom calculations, but the values coming up are not the correct ones and they do not match with the context item I have also created. Any tips of where I could be going wrong?  The event counter for the custom calc (in blue) and clearly starts before the event of the tag (>0.02) is happening.   I appreciate any inputs you can give me. 

313
F
Employee
G
Explorer
Groot12Explorer
asked in Questions & Answers
alarm when there is no signal

I want to get an email notification via the monitoring when a tag has no value (connection lost).Any idea how to do this?

292
Jef Vanlaer
Community Manager
P
Explorer
parnaz.salimovaExplorer
asked in Questions & Answers
Dashoard does not get updated

The trends in dashboard do not get updated.

271
Stijn Agten
Employee
Rdhernanfr
Navigator
RdhernanfrNavigator
asked in Questions & Answers
Identifying & contextualizing anomalies based on duration

After doing a cleaning of one equipment, in an aseptic system, it requires to flush it with steam to sterilize it for 10 minutes, if the time is higher than 10 minutes, then that time (the differential) is considered as an anomaly or waste of energy. If I create a Value Based Search it detects all the events with highest duration of 10 minutes, but I can’t consider the whole time detected, to be considered as a waste it has to last more than 10 minutes, therefore the time detected requires a subtraction of 10 minutes in the duration. Is there any function in a formula to create a conditional based in time duration to create a soft-sensor, something like if Sterilization step > 10 minutes then 1, otherwise, 0

122
Rdhernanfr
Navigator
R
Innovator
Roger PalmenInnovator
asked in Questions & Answers
Where can i find a list of demo tags?

I could not find a list of the tags in the demo datasource in the documentation, nor a description of what data is in these tags over what time period. Is that available in some way? And these tags are available to all users, right? Reason to ask is to build localized training materials that are not dependent on user's permissions to ‘real’ tags

32
R
Innovator
Shams92
Pioneer
Shams92Pioneer
posted in Questions & Answers
Golden Batch Master Mind Group

Hello,what do you think about setting up a master mind group for the Golden Batch topic? My first idea is a peer-to-peer mentoring group where we can exchange about all topics around golden batch and share our experiences for all experience levels. Looking forward to hearing from you. BestSören

412
Pelinsu
Community Manager
M
Navigator
mkotheNavigator
asked in Questions & Answers
IFERROR function

Hi,sometimes a tag has a “bad” value.Is there an option similar to the iferror function in Excel, so that i can specify a fixed value if the tag is bad?Cheers,Marvin

575
K
Employee
B
Navigator
benjamindavisNavigator
asked in Questions & Answers
Downtime Dashboard

I was able to follow the instructions on another thread on how to create an aggregation tag for an integration over 24 hours of a binary tag for line running or not and it will give me the downtime over the last 24 hours at any specific point. Is there a way to lock in a time so that on any given day at 7 am, it will show me the downtime over the last 24 hours to the previous day at 7 am? We have a few metrics like that that we report out on over the 7 am - 7 am window and that feature would be very helpful.

331
K
Employee
Shams92
Pioneer
Shams92Pioneer
asked in Questions & Answers
Insights about dashboard usage

Hey TrendMiner Team,we are looking for a way to check the usage of our dashboards. We would like to know which are the most frequently used dashboards and how many different users are using the dashboards daily, weekly or monthly. We are not looking for the usage of individual individual users but rather for an usage overview so that we can check adoption of the dashboards and see whether we need to push some dashboards more to our users. I am wondering which options we have to analyse the usage. Ideally, we would be able to do this ourselves within the software (ConfigHub). Best wishesSören 

362
Shams92
Pioneer
M
Navigator
MattNavigator
asked in Questions & Answers
Fingerprints Duplicating or giving opposite results

I have a system with 2 fingerprint monitors active. The fingerprints are copies of each other, and one monitor checks for matches while the other checks for deviations. They have the same detection threshold. Frequently, the “match” fingerprint gives 2 match alerts (I have the monitors generate context items) a ~2 minutes apart for the same event. The length of the fingerprint is ~30 minutes and there are 3 tags involved. Other times, the “match” fingerprint and the “deviation” fingerprint will both detect and give conflicting context items. How far apart do the detection thresholds need to be to avoid this (ie can it be 84 and 85% or does it need to be more like 80 & 85%)

432
Jef Vanlaer
Community Manager
A
Navigator
Alberto.MartinezJoaristiNavigator
asked in Questions & Answers
Time shift calculation

I am interested to know which product is being produced in chemical reactor in series… I know the current product at the exit of production, but not which product is being run in each reactor. I know the residence time in the different reactors. Is there any possibility to create a formula indicating which product is being produced in each reactor by applying a variable time shift which depends on the residence time? 

503
Wouter Daniels
Employee
B
Navigator
benjaminNavigator
asked in Questions & Answers
How can I share a dashboard?

Hello, is it possible to share a monitoring dashboard with another user so they can access and modify it as well ?

492
B
Navigator
yracette
Pioneer
yracette
asked in Questions & Answers
Tags Indexing/Re-Indexing (or update)

I have  a connection to a PI system that includes, amongst other things, lab data (originating from LIMS) and PI-AF calculations. I have a PI-AF calculation that is making use of a lab tag. This week, an invalid entry was made in LIMS for the lab tag and the value was subsequently substituted/updated in PI. I recalculated/backfilled the associated PI-AF calculation and trends of both the lab and PI-AF calculation is correct/accurate in PI. The configuration of the lab tag was also  modified to force the step attribute to 1, so that values appear in a staircase format in PI.I would like these changes to be reflected in Trendminer, so I tried refreshing the index for both the lab tag and the calculation and that did not appear to do the job. Incorrect values that had been recalculated in PI are still showing in Trendminer. And the lab tag still is not represented in staircase format.What am I missing?

682
yracette
Pioneer
S
Explorer
sajanExplorer
asked in Questions & Answers
Formula that gives Operating hours

Hello there, I am wondering if it is possible to write a formula or a way to find out, how to combine a Tag which gives out binary values (1 and 0) and the number of hours it is in operation provided in the formula a fixed starting date and current date and time? we would like to create a dashboard using pump ON/Off Tag to calculate the operating hours i.e., how long is pump in operation. Thank you so much for your inputs. Best REgards,Sajan

531
K
Employee
B
Navigator
Beatriz VedovatoNavigator
asked in Questions & Answers
How can I get a Expert License?

Hello, I need to build a tag using a custom calculation, and for that I need an Expert License. What I have to do to get one? Thanks,Beatriz.

381
Jef Vanlaer
Community Manager
B
Navigator
Beatriz VedovatoNavigator
asked in Questions & Answers
How to create a graph of accumulated energy consumption for the month?

Hello,I need to create a graph of accumulated energy consumption for the month, how do I do this? I have the energy consumption information active, but I'm having trouble creating the accumulated energy for the entire month. Thanks

711
F
Employee
S
Navigator
Stefan.TubbenhauerNavigator
asked in Questions & Answers
Export Data to Excel

Is it possible to access the expoert of tags in Excel directly via Excel? Instead of going into the Trendminer and exporting a tag view, would it be possible to load the data of different tags directly into Excel via API connection and a PowerQuery in Excel?

401
F
Employee
J
Navigator
Jörg KunkelmoorNavigator
asked in Questions & Answers
Interpolated Data Scatter Plot

Is it possible to filter by data points and not display the interpolated data in a scatter plot?

603
F
Employee
S
Explorer
si.hu
asked in Questions & Answers
Creating a custom totalizer using formulas and aggregations?

We are investigating if there is a way to create a tag that would sum the totalizer and/or flow indicator? I have read through this article but not exactly the answer I am looking for: https://community.trendminer.com/functional%2Dtips%2Dtricks%2D48/optimizing%2Ddaily%2Dproduction%2Dtracking%2Dfour%2Dmethods%2Dfor%2Daccurate%2Dmonitoring%2D351

1021
F
Employee
Terms & ConditionsCookie settings