# How to Match Percentile value for Data explorer and Multidimensional Analysis(MDA) for Calculated service metric?

**URL:** <https://community.dynatrace.com/t/how-to-match-percentile-value-for-data-explorer-and-multidimensional-analysis-mda-for-calculated-service-metric/40018>\
**Category:** Troubleshooting\
**Tags:** dynatrace-managed, data-explorer, multidimensional-analysis\
**Created:** [June 1, 2023, 6:15am UTC](https://community.dynatrace.com/t/how-to-match-percentile-value-for-data-explorer-and-multidimensional-analysis-mda-for-calculated-service-metric/40018 "2023-06-01T06:15:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![chiranjitdutta](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/chiranjitdutta/32/29757_2.png) [@chiranjitdutta](https://community.dynatrace.com/u/chiranjitdutta)\
**Post date:** [June 1, 2023, 6:15am UTC](https://community.dynatrace.com/t/how-to-match-percentile-value-for-data-explorer-and-multidimensional-analysis-mda-for-calculated-service-metric/40018/1 "2023-06-01T06:15:50Z")

</div>

## Self Service Summary

Issue:

Unable to view Percentile value for Calculated service Metric in Data explorer.

Solution:

Understand the concept of Percentile value in Data explorer. Percentile value works for the Inbuilt metrics which are preloaded with environment. For e.g. AWS, Kubernetes, Azure, Vmware etc will have a percentile value in data explorer but if you&nbsp; have Calculated Service metric it will not directly show Percentile value but you would need to change the Visualization from Graph view to either TOP LIST/HoneyComb/Table View. Then on the right side you will find “FOLD TRANSFORMATION” Drop down, from there you can change it to PERCENTILE.

TASKS:

Please see below steps to check

- Create a Calculated metrics based on (Metric source) that you want to calculate
- Once you start seeing the data(at least 2hrs of data for percentile value) in data explorer change the Visualization to Top view or HoneyComb or Table view.
- Next click on FOLD transformation drop down and select Percentile and click RUN query.

You can now see that, the percentile value is calculated for the Merged Data points.  
([Configure a top-list visualization in Dynatrace — Dynatrace Docs](https://www.dynatrace.com/support/help/shortlink/visualization-top-list#fold-transformation))

**BEFORE Changing** :

Here is a short demo of the service Not showing any Percentile data in Graph, Stacked visualisation

![Troubleshoot-2.gif](https://global.discourse-cdn.com/dynatrace/original/3X/2/0/2087c17b4751043f8bfdce4133e519e609a1755f.gif)

- In this, I created a Calculate service metric(Authentication service) and selected Split by Service

- After running the query, it the default aggregation shows Auto(avg) for response time.

- Now if you observe it carefully, I am changing the aggregation to Percentile but the values are not changing in Graph.

- This is because the Calculated Service metric doesn’t support Graph, Stacked visualization or visualization that has multiple data points.

- Percentile will only work for combined or merged data points like, PIE/Honeycomb/Table/TOP list.

- Below you will find the alternate workaround for getting percentile value for Calculated service metric.

---

<div class="post-metadata">

**Author:** ![Romanenkov\_Al3x](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/romanenkov_al3x/32/36257_2.png) [@Romanenkov\_Al3x](https://community.dynatrace.com/u/Romanenkov_Al3x)\
**Post date:** [June 1, 2023, 2:31pm UTC](https://community.dynatrace.com/t/how-to-match-percentile-value-for-data-explorer-and-multidimensional-analysis-mda-for-calculated-service-metric/40018/2 "2023-06-01T14:31:45Z")

</div>

Thanks for sharing!