# Export the data from a multi-analysis view to excel

**URL:** <https://community.dynatrace.com/t/export-the-data-from-a-multi-analysis-view-to-excel/33277>\
**Category:** Open Q&A\
**Tags:** multidimensional-analysis\
**Created:** [November 15, 2021, 8:39am UTC](https://community.dynatrace.com/t/export-the-data-from-a-multi-analysis-view-to-excel/33277 "2021-11-15T08:39:38Z")\
**Posts on this page:** 17\
**Page:** 1

<div class="post-metadata">

**Author:** ![jcamps](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/jcamps/32/6791_2.png) [@jcamps](https://community.dynatrace.com/u/jcamps)\
**Post date:** [November 15, 2021, 8:39am UTC](https://community.dynatrace.com/t/export-the-data-from-a-multi-analysis-view-to-excel/33277/1 "2021-11-15T08:39:38Z")

</div>

Hi all,

maybe it’s a stupid question but, is there an **easy way** to export the data from a multi-analysis view to excel?

Regards, Josep Maria

---

<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:** [November 15, 2021, 11:15am UTC](https://community.dynatrace.com/t/export-the-data-from-a-multi-analysis-view-to-excel/33277/2 "2021-11-15T11:15:51Z")

</div>

Hi&nbsp;[@jcamps](https://community.dynatrace.com/user/16448)

No way to export directly data to Excel,

But you can use API to get data in json format (or csv for certain case) and convert to excel if you want.

We are using this method.

Have a good day.

---

<div class="post-metadata">

**Author:** ![jcamps](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/jcamps/32/6791_2.png) [@jcamps](https://community.dynatrace.com/u/jcamps)\
**Post date:** [November 16, 2021, 7:19am UTC](https://community.dynatrace.com/t/export-the-data-from-a-multi-analysis-view-to-excel/33277/3 "2021-11-16T07:19:48Z")

</div>

Hi [@Malaik](https://community.dynatrace.com/user/23195)&nbsp;,

and with the API how can I get the information from a multi-analysis view? For one fixed service we want the median, percentile 90, avg and sum **splitted** by all the request names…

do you have some API call example showing how to do this?

With this call:

_/api/v2/metrics/query?metricSelector=builtin%3Aservice.response.server%3A%28median%2C%20avg%2C%20percentile%2890%29%2C%20sum%29&resolution=Inf&from=2021-11-11T08%3A00%3A00%2B01%3A00&to=2021-11-11T09%3A00%3A00%2B01%3A00&entitySelector=entityId%28%22SERVICE-6A7A221E0D50BB4F%22%29_

we get all the data for a global service but not splitted by request…

Regards! Josep Maria

---

<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:** [November 16, 2021, 7:49am UTC](https://community.dynatrace.com/t/export-the-data-from-a-multi-analysis-view-to-excel/33277/4 "2021-11-16T07:49:27Z")

</div>

Hi [@jcamps](https://community.dynatrace.com/user/16448)

I dont have an exact example

but I think you can use&nbsp;/metrics/query in the API V2

Or for this specific case, I proceed like this.

I create 2 metrics (for avg and sum, but unfortunately not available for median and percentile)  
After that I call a API for those metrics.

Or just specify the service in the entity selector with the aggregation…

---

<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:** [November 16, 2021, 8:03am UTC](https://community.dynatrace.com/t/export-the-data-from-a-multi-analysis-view-to-excel/33277/5 "2021-11-16T08:03:54Z")

</div>

A short answer is - you cannot do that in general. MDA has much stronger options and is calculated on the flight from service request data.

Some “simpler” MDA filters such as request count without splitting on the dimension of course match some of the built-in metrics and you can request them.

I really wish there would be an MDA API. There is already an [RFE for it](https://community.dynatrace.com/post/154088).

---

<div class="post-metadata">

**Author:** ![Yann\_Buccellato](https://avatars.discourse-cdn.com/v4/letter/y/97f17d/32.png) [@Yann\_Buccellato](https://community.dynatrace.com/u/Yann_Buccellato)\
**Post date:** [November 22, 2021, 12:52pm UTC](https://community.dynatrace.com/t/export-the-data-from-a-multi-analysis-view-to-excel/33277/6 "2021-11-22T12:52:19Z")

</div>

[@jcamps](https://community.dynatrace.com/user/16448) I might have a solution to this, but I don’t like it myself 😄

Let’s assume you have Notepad++ [we will use this knowledge kindly provided by the internet [https://stackoverflow.com/questions/45969411/notepad-rows-to-columns-in-groups](https://stackoverflow.com/questions/45969411/notepad-rows-to-columns-in-groups)]

Let’s say that you ctrl+C, from the word “Dimensions” on the screen you shared to the bottom of the page:

 ![y_buccellato_0-1637583288752.png](https://global.discourse-cdn.com/dynatrace/original/3X/2/e/2e51b1b586ab66aaecd15dac49909aa6a176fd29.png)

Let’s say that you ctrl+V the copy content in a notepad++ page. Here you manually remove the line where you find “Actions”:

 ![letsassume.png](https://global.discourse-cdn.com/dynatrace/original/3X/7/3/735fca630413e81019202390081aa0b57eb4a72b.png)

Now, while on notepad++, blindly press ctrl+H (Find and Replace) and insert the following:

- Find what: (?:[^\r\n]+\R){3}
- Replace with: $0\n

and click on “replace all” \> this will add a white line after each group of 3 line.

 ![y_buccellato_1-1637583819702.png](https://global.discourse-cdn.com/dynatrace/original/3X/0/6/06e9fe52e6810d55d721da5e4412e4d047a01214.png)

and now proceed again by filling the “find and replace” form with those value:

- Find what: (\R)(?!\R)|(\R\R)
- Replace with: (?1|:\n)

and press on “replace all” \> this will separate your data correctly in column divided by |

The end result will look like this:

 ![letsassumeagain.png](https://global.discourse-cdn.com/dynatrace/original/2X/a/a13c7105aa76ba9a8b3ef723df3a33f0cd07a2b2.png)

Now your data look good enough to be in an excel sheet (where you can use this function to divide the data into columns); for example:

 ![y_buccellato_3-1637585209259.png](https://global.discourse-cdn.com/dynatrace/original/2X/5/53854f1b97f182ab4d875b85b404593f751c83ac.png)

Wrapping up: this solution is horrible but is also why it kinda make me smile 🙂 it’s not the easy way, but it gets the data into our beloved excel.

Regards!

---

<div class="post-metadata">

**Author:** ![jcamps](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/jcamps/32/6791_2.png) [@jcamps](https://community.dynatrace.com/u/jcamps)\
**Post date:** [November 23, 2021, 3:43pm UTC](https://community.dynatrace.com/t/export-the-data-from-a-multi-analysis-view-to-excel/33277/7 "2021-11-23T15:43:32Z")

</div>

Hi&nbsp;&nbsp; [@y\_buccellato](https://community.dynatrace.com/user/4804) ,

this owful solution is now my solution too 😞

Regards! Josep Maria

---

<div class="post-metadata">

**Author:** ![Yann\_Buccellato](https://avatars.discourse-cdn.com/v4/letter/y/97f17d/32.png) [@Yann\_Buccellato](https://community.dynatrace.com/u/Yann_Buccellato)\
**Post date:** [November 23, 2021, 4:26pm UTC](https://community.dynatrace.com/t/export-the-data-from-a-multi-analysis-view-to-excel/33277/8 "2021-11-23T16:26:55Z")

</div>

Yayyy!

---

<div class="post-metadata">

**Author:** ![rodrigo\_alvare1](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/rodrigo_alvare1/32/1927_2.png) [@rodrigo\_alvare1](https://community.dynatrace.com/u/rodrigo_alvare1)\
**Post date:** [November 23, 2021, 9:46pm UTC](https://community.dynatrace.com/t/export-the-data-from-a-multi-analysis-view-to-excel/33277/9 "2021-11-23T21:46:20Z")

</div>

Hi,

Probably what you need for this scenario is to create a metric with those conditions ([Calculated metrics for Services — Dynatrace Docs](https://www.dynatrace.com/support/help/how-to-use-dynatrace/transactions-and-services/service-monitoring-settings/calculated-service-metric/)) and after the metric is created you will be able to char, alert and pull that data.  
Regards

---

<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:** [November 24, 2021, 5:59am UTC](https://community.dynatrace.com/t/export-the-data-from-a-multi-analysis-view-to-excel/33277/10 "2021-11-24T05:59:58Z")

</div>

Hi&nbsp;[@y\_buccellato](https://community.dynatrace.com/user/4804)

Th second action didnt make anything for me

- Find what:&nbsp;(\R)(?!\R)|(\R\R)
- Replace with:&nbsp;(?1|:\n)

I will check more.

---

<div class="post-metadata">

**Author:** ![theharithsa](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/theharithsa/32/16236_2.png) [@theharithsa](https://community.dynatrace.com/u/theharithsa)\
**Post date:** [November 24, 2021, 7:11am UTC](https://community.dynatrace.com/t/export-the-data-from-a-multi-analysis-view-to-excel/33277/11 "2021-11-24T07:11:39Z")

</div>

Adding to rodrigo’s suggestion,

When you plot the same on to Dashboards, if you have dashboard powerups extension, you can directly export the data to excel.

---

<div class="post-metadata">

**Author:** ![Yann\_Buccellato](https://avatars.discourse-cdn.com/v4/letter/y/97f17d/32.png) [@Yann\_Buccellato](https://community.dynatrace.com/u/Yann_Buccellato)\
**Post date:** [November 26, 2021, 4:13pm UTC](https://community.dynatrace.com/t/export-the-data-from-a-multi-analysis-view-to-excel/33277/12 "2021-11-26T16:13:20Z")

</div>

Remember to Check the “Regular Expression” field when you are in the Replade window!

Asta la vista

---

<div class="post-metadata">

**Author:** ![zietho](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/zietho/32/41733_2.png) [@zietho](https://community.dynatrace.com/u/zietho)\
**Post date:** [December 18, 2021, 11:32am UTC](https://community.dynatrace.com/t/export-the-data-from-a-multi-analysis-view-to-excel/33277/13 "2021-12-18T11:32:01Z")

</div>

[@tom\_rothschaedl](https://community.dynatrace.com/user/8742)&nbsp;fyi

---

<div class="post-metadata">

**Author:** ![lawrence\_cuneaz](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/lawrence_cuneaz/32/1053_2.png) [@lawrence\_cuneaz](https://community.dynatrace.com/u/lawrence_cuneaz)\
**Post date:** [December 18, 2021, 8:31pm UTC](https://community.dynatrace.com/t/export-the-data-from-a-multi-analysis-view-to-excel/33277/14 "2021-12-18T20:31:39Z")

</div>

Link to the Chrome Extension Dashboard Powerup to export to excel:&nbsp;[https://chrome.google.com/webstore/detail/dynatrace-dashboard-power/dmpgdhbpdodhddciokonbahhbpaalmco](https://chrome.google.com/webstore/detail/dynatrace-dashboard-power/dmpgdhbpdodhddciokonbahhbpaalmco)&nbsp;and github instructions:&nbsp;[GitHub - dynatrace-oss/DynatraceDashboardPowerups: Chrome Extension to boost DT dashboards · GitHub](https://github.com/dynatrace-oss/DynatraceDashboardPowerups#Installation)

Happy Holidays!

---

<div class="post-metadata">

**Author:** ![Yann\_Buccellato](https://avatars.discourse-cdn.com/v4/letter/y/97f17d/32.png) [@Yann\_Buccellato](https://community.dynatrace.com/u/Yann_Buccellato)\
**Post date:** [December 19, 2021, 8:09am UTC](https://community.dynatrace.com/t/export-the-data-from-a-multi-analysis-view-to-excel/33277/15 "2021-12-19T08:09:09Z")

</div>

Looks like Grafana and Kibana graphical tile 😄 very good job.

Still doesn’t cover the multidimensional use case that our beloved community member was asking 🙂

---

<div class="post-metadata">

**Author:** ![zietho](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/zietho/32/41733_2.png) [@zietho](https://community.dynatrace.com/u/zietho)\
**Post date:** [June 13, 2022, 8:04am UTC](https://community.dynatrace.com/t/export-the-data-from-a-multi-analysis-view-to-excel/33277/16 "2022-06-13T08:04:37Z")

</div>

Please use the related product idea to vote:&nbsp;[https://community.dynatrace.com/t5/Dynatrace-product-ideas/Export-to-CSV-option-throughout-the-UI/idi-p/181354](https://community.dynatrace.com/post/181354)

EDIT/UPDATE: export to CSV is planned for Multidimensional analysis for services ;).

---

<div class="post-metadata">

**Author:** ![kankit8084](https://avatars.discourse-cdn.com/v4/letter/k/a88e57/32.png) [@kankit8084](https://community.dynatrace.com/u/kankit8084)\
**Post date:** [November 26, 2023, 10:47am UTC](https://community.dynatrace.com/t/export-the-data-from-a-multi-analysis-view-to-excel/33277/17 "2023-11-26T10:47:04Z")

</div>

hi

could you please help me to write the automation for this

we will do all the function in single click
