# Average, maximum, percentile response time in the dashboard

**URL:** <https://community.dynatrace.com/t/average-maximum-percentile-response-time-in-the-dashboard/32629>\
**Category:** Dashboarding\
**Tags:** services-classic, dashboards-classic\
**Created:** [September 8, 2021, 1:50pm UTC](https://community.dynatrace.com/t/average-maximum-percentile-response-time-in-the-dashboard/32629 "2021-09-08T13:50:50Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Malaik](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/malaik/32/32673_2.png) [@Malaik](https://community.dynatrace.com/u/Malaik)\
**Post date:** [September 8, 2021, 1:50pm UTC](https://community.dynatrace.com/t/average-maximum-percentile-response-time-in-the-dashboard/32629/1 "2021-09-08T13:50:50Z")

</div>

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&nbsp;vice versa…

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

Do you have any information about this mistake?

 ![Malaik_0-1631108776294.png](https://global.discourse-cdn.com/dynatrace/original/3X/4/b/4b2ae33bf29fdcdd0b31adcf02caa93eef1426b6.png)

Thanks and have a good day.

---

<div class="post-metadata">

**Author:** ![Julius\_Loman](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/julius_loman/32/51_2.png) [@Julius\_Loman](https://community.dynatrace.com/u/Julius_Loman)\
**Post date:** [September 8, 2021, 7:39pm UTC](https://community.dynatrace.com/t/average-maximum-percentile-response-time-in-the-dashboard/32629/2 "2021-09-08T19:39:49Z")

</div>

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

 ![Julius_Loman_0-1631129847694.png](https://global.discourse-cdn.com/dynatrace/original/3X/5/3/53c669daf8d627909185344b3815523d4e56ae90.png)

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.

---

<div class="post-metadata">

**Author:** ![Malaik](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/malaik/32/32673_2.png) [@Malaik](https://community.dynatrace.com/u/Malaik)\
**Post date:** [September 9, 2021, 5:24am UTC](https://community.dynatrace.com/t/average-maximum-percentile-response-time-in-the-dashboard/32629/3 "2021-09-09T05:24:12Z")

</div>

Thanks a lot&nbsp;[@Julius\_Loman](https://community.dynatrace.com/user/3364)&nbsp;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.

---

<div class="post-metadata">

**Author:** ![Malaik](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/malaik/32/32673_2.png) [@Malaik](https://community.dynatrace.com/u/Malaik)\
**Post date:** [September 9, 2021, 5:32am UTC](https://community.dynatrace.com/t/average-maximum-percentile-response-time-in-the-dashboard/32629/4 "2021-09-09T05:32:34Z")

</div>

Other thing

I opened a RFE since some weeks

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

 ![Malaik_0-1631165466946.png](https://global.discourse-cdn.com/dynatrace/original/2X/1/14a75dceb4619e4427fe4e609e793d23d98be331.png)

---

<div class="post-metadata">

**Author:** ![Julius\_Loman](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/julius_loman/32/51_2.png) [@Julius\_Loman](https://community.dynatrace.com/u/Julius_Loman)\
**Post date:** [September 9, 2021, 7:05am UTC](https://community.dynatrace.com/t/average-maximum-percentile-response-time-in-the-dashboard/32629/5 "2021-09-09T07:05:07Z")

</div>

[@Malaik](https://community.dynatrace.com/user/23195)&nbsp; this looks like a bug.&nbsp; Maybe&nbsp;[@zietho](https://community.dynatrace.com/user/23400)&nbsp;can provide an answer.  
Renaming of the columns should be available in 1.226 (very soon) in Data Explorer.

---

<div class="post-metadata">

**Author:** ![zietho](https://avatars.discourse-cdn.com/v4/letter/z/94ad74/32.png) [@zietho](https://community.dynatrace.com/u/zietho)\
**Post date:** [September 9, 2021, 8:06am UTC](https://community.dynatrace.com/t/average-maximum-percentile-response-time-in-the-dashboard/32629/6 "2021-09-09T08:06:44Z")

</div>

passed it to the team, yes I believe it does! Thanks&nbsp;[@Julius\_Loman](https://community.dynatrace.com/user/3364)&nbsp;for tagging me!

---

<div class="post-metadata">

**Author:** ![Malaik](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/malaik/32/32673_2.png) [@Malaik](https://community.dynatrace.com/u/Malaik)\
**Post date:** [September 9, 2021, 10:42am UTC](https://community.dynatrace.com/t/average-maximum-percentile-response-time-in-the-dashboard/32629/7 "2021-09-09T10:42:38Z")

</div>

Hello&nbsp;[@zietho](https://community.dynatrace.com/user/23400)

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.

---

<div class="post-metadata">

**Author:** ![zietho](https://avatars.discourse-cdn.com/v4/letter/z/94ad74/32.png) [@zietho](https://community.dynatrace.com/u/zietho)\
**Post date:** [September 9, 2021, 10:44am UTC](https://community.dynatrace.com/t/average-maximum-percentile-response-time-in-the-dashboard/32629/8 "2021-09-09T10:44:31Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![zietho](https://avatars.discourse-cdn.com/v4/letter/z/94ad74/32.png) [@zietho](https://community.dynatrace.com/u/zietho)\
**Post date:** [September 9, 2021, 11:43am UTC](https://community.dynatrace.com/t/average-maximum-percentile-response-time-in-the-dashboard/32629/9 "2021-09-09T11:43:30Z")

</div>

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.
