aso1124
commented
2 weeks ago @himanshudangre Thanks for opening this - we'll follow up toward the end of next week.
Open himanshudangre opened 2 weeks ago
aso1124
commented
2 weeks ago @himanshudangre Thanks for opening this - we'll follow up toward the end of next week.
Description
1)As a part of POC we tried to check the health of URL's using a ping monitor and tried to visualize it using the status timeline widget. 2)In the status timeline widget , when we tried to get the result of each minute of a synthetic monitor using 'minuteOf(timestamp)' , We are getting an inconsistent timestamp view as in the [image a) ] 3) We had received some suggestion from the Newrelic support team , we had used timestamp instead of monuteof9timestamp) but then it was giving the timestamps in Epoch format , so we converted the Epoch time to human redable form but that seems to inconsistent as well as shown in the [image b) ]
Steps to Reproduce
1) Create some sample Ping monitors and add it with a tag ('Api_poc' in our case). 2) Use the following query in Status Timeline widget to fetch the result of the monitors. a) "From SyntheticCheck select latest(result) where tags.type = 'Api_poc' facet monitorName,minuteOf(timestamp) with TIMEZONE 'Australia/Brisbane' SINCE 7 days ago LIMIT MAX" b) We have also tried out this query: "From SyntheticCheck select latest(result) where tags.type = 'Api_poc' facet monitorName,toDatetime(timestamp, 'yyyy-MM-dd HH:mm', timezone:'Australia/Brisbane') SINCE 7 days ago LIMIT MAX " .(but the order of the timeline is coming in Jumbled order)
Expected Behaviour
The status timeline widget should show the values of Timeline in a proper order with a proper timestamp (DD-MM-YYYY HH:MM)
Relevant Logs / Console output
a)
b)
