topic Average, maximum, percentile response time in the dashboard in Dashboarding

Average, maximum, percentile response time in the dashboard

Malaik — Wed, 31 May 2023 11:58:25 GMT

Hello Dear Community

I want to chart "average", "maximum"... for all my services (for a specific application).

My problem (as shown on the screen below), some services have the "average", but not the "maximum" and vice versa...

Also, the list is not complete, I want the whole services.

Do you have any information about this mistake?

Thanks and have a good day.

Re: Average, Maximum, Percentile response time...

Julius_Loman — Wed, 08 Sep 2021 19:39:49 GMT

I'm almost sure it's the cardinality limit you have hit. By default the data explorer limits 10 dimensions, see default generated code:

If you have more than 10 services, you need to limit the scope or increase the limit. The issue here is the queries are limited and then joined in a table, so that's why you can see mostly either avg or max values only.

FYI - the limit is 100 per metric selector.

Re: Average, Maximum, Percentile response time...

Malaik — Thu, 09 Sep 2021 05:24:12 GMT

Thanks a lot @Julius_Loman for your feedback and time.

I explored the code side but didnt take a time to analyse and understand what its writen, i was searching an option but not a code.

Good day man.

Re: Average, Maximum, Percentile response time...

Malaik — Thu, 09 Sep 2021 05:32:34 GMT

Other thing

I opened a RFE since some weeks

Look at the column names, different aggregations with the same column names.

Re: Average, Maximum, Percentile response time...

Julius_Loman — Thu, 09 Sep 2021 07:05:07 GMT

@Malaik this looks like a bug. Maybe @zietho can provide an answer.
Renaming of the columns should be available in 1.226 (very soon) in Data Explorer.

Re: Average, Maximum, Percentile response time...

zietho — Thu, 09 Sep 2021 08:06:44 GMT

passed it to the team, yes I believe it does! Thanks @Julius_Loman for tagging me!

Re: Average, Maximum, Percentile response time...

Malaik — Thu, 09 Sep 2021 10:42:38 GMT

Hello @zietho

We really need an export option.

This result was asked me to be shown on an excel sheet, I spent a lot of time to make it in the right format.

Re: Average, Maximum, Percentile response time...

zietho — Thu, 09 Sep 2021 10:44:31 GMT

we are currently planing for smaller but important additions for q4 and the export known from CC is def. one of the items on the plate and also with a high priority. will let you know when i can comm. a version.

Re: Average, Maximum, Percentile response time...

zietho — Thu, 09 Sep 2021 11:43:30 GMT

update: it's a bug and with the ability to rename we also removed this buggy automatic differentiation which we put there in the first place to aid the cases with the same name.