I'm using graphite to collect data, and I'd like to retrieve the total count of certain events over a period of time. Say, number of logins per week.
However, I just need the total number, and don't need to see how it evolves over time.
When I use something like from=-1w&target=summarize(stats.events.login.success,"1w")&format=json then I still get two datapoints, and not one.
Is there a way to get a single datapoint from the summarize function? or use a different function to return a single datapoint value?
The problem here is that summarize doesn't align to the from field by default.
summarize(seriesList, intervalString, func='sum', alignToFrom=False)
If you do
from=-1w&target=summarize(stats.events.login.success,"1w","sum",true)&format=json
you should get just one datapoint. What it's doing right now is aligning your buckets to dates that don't fit within the week range starting from your from parameter, so you end up with 2 buckets. From the graphite docs on summarize:
By default, buckets are caculated by rounding to the nearest interval.
This works well for intervals smaller than a day. For example, 22:32
will end up in the bucket 22:00-23:00 when the interval=1hour.
Passing alignToFrom=true will instead create buckets starting at the
from time. In this case, the bucket for 22:32 depends on the from
time. If from=6:30 then the 1hour bucket for 22:32 is 22:30-23:30.
So for me it divides the week on Wednesday and the month on the 15th, 16th or 17th. Additionally mine seems to be ignoring the alignToFrom value. Co-worker had the idea that maybe it's based on the install date or when the whispher db is first instantiated. Where I can believe that may be the case for day of the week, I doubt we both installed things mid month.
