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.
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.