How to create data explorer with metric request count total, splity by host and services

[andra_nosa]

Hi All,

I want create dashboard to export data report csv from there

The question how to create request count total with split by host, services and filter by process group

I have try but still failed :

Please help me

Regards,

Andra

[AntonPineiro · Accepted solution]

Hi,

I think multidimensional analysis might be helpful this time:

You can split per service instance to see in which hosts is running, and filtering by process name.

You can export it as CSV also (right down corner):

If this is not viable to you, maybe DQL can be what you are looking for.

Best regards

[andra_nosa]

Hi AntonPineiro,

I used dynatrace managed version and i cannot see menu DQL

Yes, previously i try on multidimensional but its not clear

My customer want like this :

Split by Service | Dimension as Service - Instance think is right | and for process group from info my customer they want break 3 process group

On multidimensional only can used 1 filter on 2 filter you can't add same, how ??

How to create like that?

Regards,

Andra

[AntonPineiro]

Hi,

I would tag all process groups you are interested in advance. And then, I would filter for that tag, it can be number or process groups you want.

Best regards

Best regards

[andra_nosa]

Hi AntonPineiro,

Is there any other way besides creating tags, to output services, hosts, and tps?

Regards,

Andra

[AntonPineiro]

Hi,

Maybe using DQL instead but you need a SaaS tenant with Grail enabled.

Best regards

[PacoPorro]

DQL won't be an option right now. Your approach is the best one.

[Julius_Loman]

If you need built-in service metric displayed and split by instance, then you have just two solutions - MDA as suggested by @AntonPineiro  or defining calculated service metric having service instance as a dimension. For a dashboard - it must be a calculated service metric.

[andra_nosa]

Hi All,

Thanks its solved, i have confirm about it to my customer

My customer accept it using MDA and split by services:instance used filter by per process group tag

Regards,

Andra