I would like to have some sort of widget in my web app (using AGOL web app builder) that I can perform a query like "find users who have a calibration date in the past day but who do not have a last known location in the last day". Calibrations and last known locations are two different layers in my map.
Does anyone have any ideas of how I might do this? Essentially I need to perform a join.
See this link for how to join layers in AGOL: