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:
-
Conduct a value‑based search on when the TM_year* tag is constant.
-
Set your context bar to “All” to get results over multiple years.
-
Hit Search, then click “Add calculation” on the search results.
-
In the calculations panel, apply the integral calculation on the consumption tag. That gives us the total value consumed for each year.
-
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.