Data transform by 3 queries

Hi, I’m new to the application and trying to do some discovery for a product I am making, the end result will be a location reporting system for if there is a fire. On site users will check in to the assembly point and if they haven’t checked in then their location should be displayed

  • What Grafana version and what operating system are you using?

Grafana 10.2.3 OSS, hosted in a docker container on Linux

  • What are you trying to achieve?

I have 3 different tables I am querying and trying to merge and format into 1 table

Table 1 (Users) has User_ID, User_Name, Location_ID | Table 2 (Locations) has Location_ID, Location_Name | Table 3 (Assembly_Point) has User_ID, checked_in

Previously I combined table 1 and 2 using merge series to display User_ID, User_Name and Location_Name, now I am looking to combine all 3 to now display Checked_In value (The aim will be to display all users not checked in to a fire assembly point, and include their location in case people need to look for them)

  • How are you trying to achieve it?
    Merge series/tables but only appears to take in 2 queries not 3

  • What happened?

  • What did you expect to happen?
    the 3 queries would be merged

Many thanks

Incase anyone comes across this and needs a solution:

I ended up combining my 2 first queries by writing an SQL join statement to get them as one query, and then did a merge with the other 3rd query

1 Like