← Back to team overview

graphite-dev team mailing list archive

Re: [Question #172502]: SELECT COUNT(*) functionality

 

Question #172502 on Graphite changed:
https://answers.launchpad.net/graphite/+question/172502

Nicholas Leskiw proposed the following answer:
A more detailed example:

You need to get the # of sales per hour for the past 7 days and report
it to business.

The metric is called "Acme.Clothing.Boots.RocketPowered"

Using a web browser, wget or curl, pull the following URL:

http://graphite.walgreens.com/render/?&target=summarize(Acme.Clothing.Boots.RocketPowered,"1h")&from=00%3A00_20110929&until=23%3A59_20110929&rawData=true

You'll get the following response:
summarize(Acme.Clothing.Boots.RocketPowered, "1h"),1317272400,1317362400,3600|19.0,12.0,13.0,17.0,19.0,12.0,13.0,17.0,19.0,12.0,13.0,17.0,19.0,12.0,13.0,17.0,19.0,12.0,13.0,17.0,19.0,12.0,13.0,17.0

Use your favorite CSV parser to get your data out.

Split on the pipe, and you

-- 
You received this question notification because you are a member of
graphite-dev, which is an answer contact for Graphite.