{
    "name": "HTTP Analytics Latency Over Time",
    "id": "HTTPAnalyticsLatencyOverTime",
    "thumbnailURL": "",
    "configs": {
        "pubsub": {
            "types": [
                "subscriber"
            ]
        },
        "providerConfig": {
            "configs":{
                "type":"SiddhiStoreDataProvider",
                "config":{
                    "siddhiApp":"@App:name(\"HTTPAnalytics\") define stream ProcessedRequestsStream(timestamp long, serverName string, serviceName string, serviceMethod string, responseTime double, httpRespGroup string, userAgent string, requestIP string); @store(type=\"rdbms\",datasource=\"HTTP_ANALYTICS_DB\") define aggregation RequestAggregation from ProcessedRequestsStream select serverName, serviceName, serviceMethod, httpRespGroup, count() as numRequests, avg(responseTime) as avgRespTime group by serverName, serviceName, serviceMethod, httpRespGroup aggregate every sec...year;",
                    "queryData":{
                        "query":"from RequestAggregation {{filterCondition}} within {{from}}L, {{to}}L per \"{{per}}s\" select AGG_TIMESTAMP, {{groupBy}}, {{filterBy}} avg(avgRespTime) as avgRespTime group by AGG_TIMESTAMP, {{groupBy}}"
                    },
                    "publishingInterval":60,
                    "timeColumns":"AGG_TIMESTAMP"
                }
            }
        }
    }
}
