Issue with time ranges after upgrade to influxdb 2

InfluxDB 2
1

Hi

This morning I realised at 9:30am on 10th May on one of my dashboards when I selected data for last 24 hours I was getting only data for 9th May 9:30am, and that was all. I am not getting data from now - 24h ago which is what is required. I will put the query below for this specific dashboard.

from(bucket: “eBondJMX/one_week_only”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r._measurement == “SwapCurve_FFT_jmx”)
|> filter(fn: (r) => r.CurveName !~ /""/)
|> filter(fn: (r) =>
r._field == “CurveName” or
r._field == “CurveEnabled” or
r._field == “LastCurvePublished” or
r._field == “CurveLogMessage” or
r._field == “ExpectedValue” or
r._field == “Result”
)
|> last()
|> pivot(rowKey: [“MBean”, “host”], columnKey: ["_field"], valueColumn: “_value”)
|> rename(columns: {CurveLogMessage: “ErrorMessage”, Result: “CheckResult”})

Any help would be appreciated.

2

Hello @Niikhiil1997,
So you’re only getting data from May 9th 9:30am-11:59pm when querying on May 10 at 9:30am with -24 hr on the dashboard?
How are you verifying that you have data past 11:59pm?
That’s very odd.
Thanks.

3

Hi

Thank you for your response. I actually spoke to my team and learnt that we should not be getting data from 24hours to now on this particular dashboard for the kind of check that’s being done

So I’d say this is resolved.

Thank you for your reply.

Regards

Nikhil