Using in the Metric column "tx_call" instead of "tx_id" at least gave me some query results. Although I did a different search, as KPH is currently offline.
However it takes extremely long for this simple query!!! 2min waiting is normal ????
Thank you for your kind comments on the documentation. I found Grafana a little tricky in places and had to look in many places for the information that I thought a guide was needed if wsprdaemon users were to make their own dashboards.
Thank you for spotting two errors, I have corrected them.
I have found the pull down selection graphs do take quite some time to appear, especially if asking for say 7 days to look at trends.
How can one connect to the data of the spots really ?
When I try to select any received wspr signal from anyone (tx_call) to check their SNR at my receiver (rx_id=on5kq) it says in red alert: "pq: column "on5kq" does not exist"
when I try to search for my call (Expr: rx-id=....) in the drop down menu.... only the first couple of calls are shown... it stops with DK4RW/1... all other calls further down the alphabet (sorted by alphabet) are not shown ...
Because callsigns are in upper case then postgreSQL needs them to be in single quotes, see bottom of page 3 of the guide, for example, where it says:
"Click on the first value and select rx_id (may not always 'take', if so try selecting again, if still nothing, type in 'KPH', the single quotes are needed)."
It is these small matters of detail that made me write the guide, as it it really is not obvious, so try typing 'ON5KQ'
single quotes and upper case.
Without the single quotes it tried to find lower case on5kq and of course there isn't one, just ON5KQ.
Only use wsprdaemon_spots if you are sure that the receiver(s) you want to look at are wsprdaemon v2.9 users, as this is the Table for direct upload.
Everybody will be in the Table spots, as this Table contains data scraped every few minutes from wsprnet.org - but of course that makes it much slower to access data as there are many many more receivers. So it may look as if it is not working with spots, but it should be, just slower.