search

newrelic / nr1-workshop

Self-paced training workshop for the NR1 CLI/SDK
Apache License 2.0
85 stars 68 forks source link

Questions about Lab7 #90

Open cmnorman opened 4 years ago

cmnorman commented 4 years ago

I'm trying to modify the NRQL to pull information from the OrderDetails table and having issues displaying it.

What I'm trying to do is a Year over Year revenue comparison and what happens is that nothing displays in the graph...just a line at the bottom. We have this working in insights but would like to see a breakdown in NR1 for each application.

The NRQL I'm trying is: query={SELECT sum(orderTotal - tax) FROM OrderDetails WHERE appName = '${entity.name.replace("'", "\\'")}' TIMESERIES SINCE ${durationInMinutes} MINUTES AGO COMPARE WITH ${durationInMinutes*2} MINUTES AGO}>

but nothing is being graphed. Is this possible and I'm just missing something? Also, not sure if this is the right place to ask for help.

jaesius commented 4 years ago

Hi @cmnorman, I'm making the assumption that your 'OrderDetails' is something you've custom instrumented into Insights and would get better support visiting Programmability Office Hours. Details about offer hours can be found here: https://discuss.newrelic.com/t/programmability-office-hours-update/94062

I'd also check the account you selected when making your API key is correct and has the OrderDetail data you're trying to add to your New Relic Application.