Dear all,
Data is indexed from a CSV file.
I am trying to calculate the amount of seconds between a couple of timestamps.
The dates are in %d %m %Y %H:%M:%S %Z format and I am trying to do it this way:
...x | eval compliance_time=strptime("first_date", "%d %m %Y %H:%M:%S %Z")- strptime("second_date", "%d %m %Y %H:%M:%S %Z") | eval compliance_time=compliance_time/60 | eval compliance=if(compliance_time<900, "Compliant", "Non-compliant") | timechart avg(compliance_time) |gauge avg(compliance_time) 1 5 10 15
I've checked current answers already, but unfortunately, I might be missing something.
first_date="21 10 2015 11:16:16 UTC"
second_date="21 10 2015 11:18:46 UTC"
but compliance_time is empty.
Let me know if you need more details.
Thank you,
... View more