Variables in grafana

Hi

We have a drop down with list of client names from graphite db. However the metric client name is down the hierarchy. assets.provider.count.subscriptionid.locationid.clientname. We select client name but what I really want to do is graph by subscription id and not client name . So how can I get the subscription id given the client name or somehow aggregate by subscription id given the client name
Thanks
Lipika

Give it a try on the below metric in your graph,

assets.provider.count.*.locationid.$client_Name_Variable

that will just give datapoints for that client name not for the subscription id that is few levels above it. Also location_id is not known … location id is a number not a directory name