Count days in timeseries range

[zmiguelb]

Hello,
I am trying to get the number of days in the time range to multiply and add to a value.
Basically, the graph on the left is my energy in kWh but the one on the right should be it translated to $$, and it is based on energy used plus a day rate tariff. Is it possible to get a select that return the number of days in the time range.
@anon349787 @torkel

image|690x366

[grant2]

Does this post help (it’s almost 4 years old, but it may still be relevant).

[reisenrich1]

Yes I have the same question

I think

Calculate days between time series and today

Hi all, I have a data series that includes the time in seconds: [image] I want to: use the most-recent captured data point THEN subtract the time() THEN divide by 86400 (to get number of days) THEN display the number of days I can get (1) and (2) working, but I’m not sure how to add additional expressions to my query for (3). Can anyone point me in the right direction? Query inspector currently set to: Expr: date_expiry - time() Step: 20s

May have a working solution for getting the number of days in the time window

[grant2]

Welcome. What is your data source?