Graphite Percentage Calculation using groupbyNode or averageSeriesWithWildCards

Asked by sourabh sinha

I am trying to create a seyren alert for my page render metric stored in graphite.

My render stats are collected by ststsD and stored in graphite. The structure is following:

stats.counters.renderCompleted.<country>.<placement_id>.<page_version>.count
e.g.

stats.counters.renderCompleted.US.123456.v1_1_03.count
stats.counters.renderCompleted.US.123456.v1_1_09.count

stats.counters.renderCompleted.US.654321.v2_1_05.count
stats.counters.renderCompleted.US.654321.v2_1_07.count

stats.counters.renderCompleted.UK.123456.v1_1_09.count
...
...

I want to create a seyren alert with graphite functions for US whenever the last 2 hour render count average for ANY PLACEMENT ANY VERSION (e.g. group by placement_id, page_version) falls below certain % of its (for that placement's and version's) previous-day-same-time 2 hour window average.

I tried couple of ways, but not getting the the exact result I am intending:

1. using averageSeriesWithWildCards:

asPercent(
    averageSeriesWithWildCards(
        movingAverage(
            scaleToSeconds(stats.counters.renderCompleted.US.*.*.count, 1),
        '2hour'),
      5),
    averageSeriesWithWildCards(
        movingAverage(
            scaleToSeconds(
                timeShift(stats.counters.renderCompleted.US.*.*.count, '1d'),
            1),
        '2hour'),
    5)
)

2. Using groupByNode:

asPercent(
    groupByNode(
        movingAverage(
            scaleToSeconds(stats.counters.renderCompleted.US.*.*.count, 1),
        '2hour'),
    4, 'averageSeries'),
    groupByNode(
        movingAverage(
            scaleToSeconds(
               timeShift(stats.counters.renderCompleted.US.*.*.count,'1d'),
            1),
        '2hour'),
    4, 'averageSeries')
)

Will appreciate some help. Thanks in advance.

Question information

Language:
English Edit question
Status:
Expired
For:
Graphite Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Denis Zhdanov (deniszhdanov) said :
#1

Hello,

Looks like your questions not getting much visibility here, you can try to open issue in github project - https://github.com/graphite-project/graphite-web

Revision history for this message
Launchpad Janitor (janitor) said :
#2

This question was expired because it remained in the 'Open' state without activity for the last 15 days.