I have a NRQL which is giving me desired result. On top that, I want to restrict data based on time frame (i.e. only show me data which is > 24 hrs old). Below query and result shows my current output. Now I just want to show the data which is in online or offline state for more than 24 hours (i.e. only first two data which is highlighted). I don’t know how to add condition based off hours using timestamp.
SELECT latest(status), filter(max(timestamp), WHERE status !='onlineAndReady') AS TimeStamp FROM `store:storeStatus` HERE tenantName='Smashburger' FACET storeNumber SINCE 1 week ago UNTIL NOW LIMIT max