Show full number on New Relic count column

Question

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?

Answer 1

You can get the absolute value like so:

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

Answer 2

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 

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