Is there a way to have this select statement return a whole number only? For example is there a rounding function to round up?
SELECT sum(apmHoursUsed) / 750 as 'Hosts' FROM NrDailyUsage WHERE `productLine` = 'APM' AND `usageType` = 'Host' SINCE 3 months ago FACET consumingAccountName
New Relic Edit
- I want this too
- I have more info to share (reply below)
- I have a solution for this
We take feature ideas seriously and our product managers review every one when plotting their roadmaps. However, there is no guarantee this feature will be implemented. This post ensures the idea is put on the table and discussed though. So please vote and share your extra details with our team.