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?
You can get the absolute value like so:
SELECT abs(count(*)) FROM requests WHERE foo = 'bar' FACET dateOf(eventtime) SINCE 3 days ago