5

When I search for SELECT count(*) FROM requests WHERE foo = 'bar' FACET dateOf(eventtime) SINCE 3 days ago in New Relic, it gives me the following table:

DATE OF EVENTTIME COUNT
December 9, 2021 1.76 M

However, I want to know what numbers I have after 6 but New Relic doesn't show it. How can I make New Relic show the entire number?

Improve this question

2 Answers 2

Reset to default
5

You can get the absolute value like so:

SELECT abs(count(*)) FROM requests WHERE foo = 'bar' FACET dateOf(eventtime) SINCE 3 days ago

Improve this answer
1

There are 3 options suggested by Andy Cunningham in newrelic discuss

  1. You can, however, access the JSON widget type to get the raw values.

  2. multiply the count() function by 1, like so:

SELECT count(*)*1 AS 'Total' FROM

  1. you may want to look at using the Query API instead. This will allow you to get the query results in JSON format

Improve this answer
1
  • 1
    I see. The *1 didn't work for me. It's a pity those are the only options.
    – m26a
    Commented Dec 14, 2021 at 14:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.