Skip to main content
Question

Implement hourly totalizer in Charts

  • October 4, 2024
  • 5 replies
  • 107 views
F
Committed

 

Let’s say I have a time series with the behavior seen above. This is a tag that represents the water consumption in my house (it’s a hypothetical).

 

Occasionally I manually reset the sensor measuring it and it goes back to zero as you can see in the curve, but otherwise this sensor works more or less like your water meter: it measures the total volume of water consumed since the beginning of times until the meter reaches 999,999 and it resets itself to 000,000 automatically

 

How do I implement a scheduled calculation in Charts that will compute the hourly water consumption at my house? I want to start calculating this at 00:30:00 of today, and the calc should run every hour after that (i.e. 01:30:00, 02:30:00, 03:30:00, 04:30:00, etc indefinitely)

 

Thanks.

Sofie Haug
Seasoned Practitioner
Forum|alt.badge.img+7
  • Sofie Haug
  • Cognite Academy Instructor
  • October 7, 2024

Hi @fabioterasaka 

Have you tried taking a look at this documentation? 
https://docs.cognite.com/cdf/charts/about_monitoring

 

Sofie | Cognite Academy
F
Committed
Sofie Haug wrote:

Hi @fabioterasaka 

Have you tried taking a look at this documentation? 
https://docs.cognite.com/cdf/charts/about_monitoring

 

Hi Sofie, thanks for the link. I understood it to be describing how to configure monitoring / alerts, but it doesn’t mention any approaches for how to perform scheduled minute-by-minute computations of a sawtooth-wave time series

Am I missing something in what the article is trying to convey?

F
Committed

Hello, it appears we can achieve the totalization use case from my original post using the “differentiation” operator in Charts.

 

You can configure a calculated tag like this:

 

And have it scheduled to run every 1 hour.

 

The only part missing is the flexibility on the scheduler to allow me to choose to start executing this at a timestamp of my choosing (e.g. 00:30:00)

N
Practitioner

Hi ​@fabioterasaka, 

Unfortunately, this is not available for scheduled calculation at the moment. This is a very good feature suggestion that would improve flexibility of our scheduler in Charts. 

cc:  ​@Arun Arunachalam 

 

Arun Arunachalam
Seasoned Practitioner

Hei ​@fabioterasaka we will try to get this out in Q3. This involves a lot of work with regards to changing the backend and how it works with respect to this use case. We are focused in Q2 on improving the search experience when it comes to helping users find their data in Charts. We will so be working on providing activities support for CDM data models which is a key value differentiator for charts today .

Reply


Terms & ConditionsCookie Settings

Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings