I'm trying to achieve results as a difference between 2 calculated metrics. Values calculated and displayed on the below metrics are DATE_DIFF
DATE_DIFF(now(),[Update - Timestamp],"nb_of_seconds")
1. Agent to 2nd (secs)
2. 2nd to Agent (secs)
Want difference value from (1-2).
Challenge: My customer metric formula returns value in separate rows if the date/month/week/year changes. How can I compute on explore to get the below result.
IF 2nd-to-agent (secs) is blank/null/empty and Agent-to-2nd (secs) is not empty/blank/null
Then get value from next row of same column and call it Value 2
Value(Agent-to-2nd (secs)) - Value 2
2153149 - 1953239
If I use normal 1 - 2 function, the value is returned on each row and instead I need an answer
2153149 - 1953239 = 199910 displayed in any 1 of the rows.
How can this be achieved in explore queries?
Por favor, entrar para comentar.