hi all,
i was asked to migrate some graphite based apache stats to influxdb, the stats are retrieved via mod_statsd in statsd format. i use telegraf as a gateway to influxdb.
measurements look like this:
http.webtest.abstt_my_domain.GET.200
http.webtest.abstt_my_domainGET.302
http.webtest.abstt_my_domain.GET.404
http.webtest.abstt_my_domain.GET.503
http.webtest.abstt_my_domain.POST.200
http.webtest.abstt_my_domain.POST.302
> SELECT count FROM /http.webtest.abstt/ WHERE time > now() - 10m
name: http.webtest.abstt_my_domain.GET.200
time count
---- -----
1583242030000000000 1
name: http.webtest.abstt_my_domain.POST.200
time count
---- -----
1583242130000000000 1
1583242330000000000 1
1583242430000000000 1
the problem is a get the duplicate vhost names in grafana, so how do i get the whole count of requests, (count of abstt_my_domain.GET.200 + count of abstt_my_domain.POST.200) from the example below represented as one name (http.webtest.abstt_sozvers_at count:4)?