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 did you expect to happen?
the 3 queries would be merged