Skip to main content

Is there a way where you can calculate the total production of a certain product. What I mean is that you consume this certain product numerous times a year. But every time the totaliser gets reset and starts again at zero. 

I want a way where you can combine all the totalisers so you know how much you consumed during the whole year.

Example:

Product A: 0 to 10000
Product A: 0 to 150000
Product A: 0 to 20000

End total 2025 Product A: 180000 kg

 

Hi,

 

If you want to totalize the amount, you can use Event Analytics for this. In Event Analytics, we can use calculations on search results to compare different search results and their KPIs.

In your case, we would:

  1. Conduct a value‑based search on when the TM_year* tag is constant.

  2. Set your context bar to “All” to get results over multiple years.

  3. Hit Search, then click “Add calculation” on the search results.

  4. In the calculations panel, apply the integral calculation on the consumption tag. That gives us the total value consumed for each year.

  5. In Event Analytics, you can then compare the different years with each other.

If you want to compare periods based on other frequencies we also have TM_month and TM_day tags available and in this article we explain how you can import your own time tags aswell.

Important side note: the “Integral (/1d)” operator computes the area under the curve—perfect for getting a total from your consumption rate—just be aware that TrendMiner assumes your tag is in units per day; otherwise, apply a conversion factor accordingly.


Reply