CODEWITHSUNDEEP
sqlpostgresqlsubquerynewrelicnrql
Siddhanth S
Siddhanth S

Reputation: 11

To view percentage change for time periods in NRQL

can we use two since and until clause in NRQL using subquery?

i need to obtain the change percentage of present week data with the previous week data in NRQL

i am not able to get the right query.

[i want to get the change percentage only to be displayed. (https://i.sstatic.net/N4KVc.png)]

I tired using this formula

Percentage Change = ((( Present Value − Past Value Past Value )) / Past value ) x 100

but i am not able to get the right NRQL.

I got suggestions to try UNION and Subqueries,yet to try them.

Upvotes: 1

Views: 247

Answers (1)

Axel
Axel

Reputation: 59

I don't think you can use two since, but you can try using the COMPARE WITH, these are the docs

Upvotes: 1

Related Questions