topic Re: DQL Entity Label in DQL

DQL Entity Label

TylerBrush — Wed, 05 Jul 2023 21:38:36 GMT

Hi team, I've created a couple posts on #help-dashboards-app and #help-dql but haven't received a response besides a recommendation to post my question here. My customer is currently trying to add a grail query to a dashboard for some information on lambda functions. The query being used is:

timeseries series=avg(cloud.aws.lambda.concurrentExecutionsByAccountIdFunctionNameRegion),by:{aws.region,functionname,aws.account.id}
| filter aws.account.id == "385888483640"
| filter functionname == "eca-permission-translation-service-v2-prod-main" or functionname == "eca-permission-translation-service-v2-prod-userProfile"

and the output is as seen below. In the output chart, the label for the function includes aws.region, functionname, and aws.account.id. Is there a way to make this just the funcitonname value? For example, 'eca-permission-translation-service-v2-prod-main' instead of 'us-east-1•eca-permission-translation-service-v2-prod-main•385888483640•series'.
Thanks!

Re: DQL Entity Label

sinisa_zubic — Wed, 05 Jul 2023 21:47:47 GMT

Hi @TylerBrush

There are different ways of achieving this, but I guess the easiest would be this

timeseries series=avg(cloud.aws.lambda.concurrentExecutionsByAccountIdFunctionNameRegion),filter:{ aws.account.id == "385888483640" and (functionname == "eca-permission-translation-service-v2-prod-main" or functionname == "eca-permission-translation-service-v2-prod-userProfile") }

Best,
Sini

Re: DQL Entity Label

TylerBrush — Wed, 05 Jul 2023 21:59:24 GMT

Hi Sinisa,

This query groups the two functions together under one label "series"

My assumption is that you can't change this without changing the 'by:{...}' values?

Re: DQL Entity Label

sinisa_zubic — Thu, 06 Jul 2023 06:30:14 GMT

I have forgotten to add the function name in the group by, so just add it there and let me know if this is what you are looking for.

Re: DQL Entity Label

TylerBrush — Thu, 06 Jul 2023 13:20:03 GMT

This works great, thank you!