Show latest value in chart

I want to have the latest value shown in a chart.

The chart is part of a Report with has the DateTo-Parameter with the Default Value Expression: NOW()

But with this expression is not the latest value shown, but the value from 23:59 the day before. 

Is there a way to show the lates value from the actual day? 

Jannick.Rowedder's picture
Joined: Mar 14 2018 - 5:32am
Last seen: 5 years 6 months ago

3 Answers:

Can you show us your query to retrieve the latest value?

Besides, it is probably because of the time zone setting of Jasper server and DB server are different.

riodavid's picture
2977
Joined: Oct 27 2016 - 1:57am
Last seen: 4 years 10 months ago

Base-URL: /timeSeries/api/assets/$P{AssetID}/aspects/$P{AspectName}/timeseries
Content type: Get Parameters.
Language: WebServiceQuery

Filer is set to limit the value to a time range. DateFrom is a Date and DateTo is NOW().

But if the time zone is different, there would be just a diffrence of some hours, wouldn't it?
But in my case is always 23:59 from the day before the latest value, don't matter which time it is.  

Jannick.Rowedder's picture
Joined: Mar 14 2018 - 5:32am
Last seen: 5 years 6 months ago

Sorry I'm not familar with WebServiceQuery. Have no idea why it is  behaving like this.

riodavid's picture
2977
Joined: Oct 27 2016 - 1:57am
Last seen: 4 years 10 months ago
Feedback
randomness