Snapshots created by API are shifted by time which they are viewed

[alessiopietro]

Hi,
iam creating daily snapshots by Grafana API. Works well so far, snapshots are in the time-range from 7am to 22pm. So it shows the last 15hours.
If i open a snapshot, lets say at 11:07am. The range is from 11:07 minus 15 hours.
Why is that? Do i need to change a certain value in json?

best regards,
alessio

[alessiopietro]

Has anyone an idea?
best regards,
alessio

[alessiopietro]

Heres a solution for everyone who has the same problem:

Time not static in snapshot api

Figured out… found another post indicating that I needed to insert the data into my code. Found an example of a coded snapshot api with the snapshotdata and modified it with my dashboard and inserted data ( via variables after parsing it in the proper format), with in a bash script and all is working now. sample code ( needs some additional tuning): psql -h $PGHOST -U $PGUSER -d $PGDATABASE -w -L PANID2.$$ -p $PGPORT << EOF SELECT S._qmf_update_time,((S.“msgReceives” - LAG(S.“msgReceives”,…

unfortunately i dont get it running. Hopefully someone has an easier way to solve that. Otherwise i dont see the advantage of taking snapshots by API.

best regards,
alessio