Getting data from Dynatrace into Excel



Getting data from Dynatrace into Excel an API token.Extract the applicationid from the url. Excel and add data from web.Click on “Record” in tabel.Click on record in table again.Click on List.Click To Table.Click on OK.Click on Extract ValuesSelect semicolon and click ok.Click on Split Column by Delimiter.Select Semicolon and click ok.Rename the columns.Add a custom column.#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [TimeSpanEPOCH]/1000)Add the formula to convert epoch time to normal time.Rename column.Click close & Load.Convert time column format to time.Now you can chart data, do whatever you want with the data in Excel. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download