Calculating yearly total of a certain product

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.

As an enhancement, we are extending the Integral operator so that it will not only support /1d, but also other periods such as /1h and /1m. So will not have to apply any conversion factors anymore.

Is there a way you can give me an example of something you’ve calculated like this? ‘Cause when I use this calculation it doesn’t give me the value it actually produced during 24h...