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?

Ori Marko · Answer 1 · 2021-12-14T08:32:58.123

1

There are 3 options suggested by Andy Cunningham in newrelic discuss

You can, however, access the JSON widget type to get the raw values.
multiply the count() function by 1, like so:

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

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

edited Dec 14 '21 at 08:32

answered Dec 14 '21 at 07:41

Ori Marko

56,308
23
131
233

1

I see. The `*1` didn't work for me. It's a pity those are the only options. – sidney Dec 14 '21 at 14:33

score 1 · Accepted Answer · answered May 24 '22 at 15:57

1

You can get the absolute value like so:

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

answered May 24 '22 at 15:57

Neil

7,861
4
53
74

Show full number on New Relic count column

2 Answers2