topic Data Explorer export to CSV - remove 100 entries limit in Dashboarding

Data Explorer export to CSV - remove 100 entries limit

mariusz_cwiklin — Mon, 12 Jun 2023 09:35:35 GMT

Currently when exporting data from Data Explorer into CSV the result is limited to 100 entries.

Could you add possibility to remove CSV export limit or add possibility to configure higher limit for CSV export.

PS. I know that using API I can export metric values into CSV without limit - but I cannot offer this solution to managers and users without development background.

Re: Data Explorer export to CSV - remove 100 entries limit

AntonPineiro — Fri, 09 Jun 2023 11:21:01 GMT

Hi,

You can remove limit.

Going to advance mode.
Remove ":limit(100)" from query.
Run query again.

Best regards

Re: Data Explorer export to CSV - remove 100 entries limit

Kenny_Gillette — Fri, 09 Jun 2023 11:26:17 GMT

Another option:

Change to table

Add "limit"

Change to "No Limit"

Export to excel

CSV:

Re: Data Explorer export to CSV - remove 100 entries limit

mariusz_cwiklin — Fri, 09 Jun 2023 12:18:23 GMT

I'm on Managed version 1.262.

After removing ":limit(100)" from query still only 100 entries is exported to CSV
There is no "No Limit" option for Limit parameter

Re: Data Explorer export to CSV - remove 100 entries limit

Kenny_Gillette — Fri, 09 Jun 2023 12:24:44 GMT

can you upgrade to 1.266?

https://www.dynatrace.com/support/help/whats-new/release-notes/managed/sprint-266

https://www.dynatrace.com/support/help/whats-new/release-notes/saas/sprint-266

Data explorer and dashboard table enhancements

Platform | Data explorer

We have made the following improvements to the table visualization:

Columns: In the Data explorer table visualization, use the checkboxes in the Columns section to enable and disable the display of columns. These selections are reflected in the resulting dashboard tiles.
Rows: In the Data explorer, you can remove the limit to see more than 100 rows.
Pages: In the Data explorer and resulting dashboard table tiles, tables are automatically paginated. Use the controls under the table to page through tables.

Re: Data Explorer export to CSV - remove 100 entries limit

mariusz_cwiklin — Fri, 09 Jun 2023 12:46:16 GMT

New limit feature is mentioned in SaaS release notes only. Does it mean that Managed will not have possibility to remove limit?

Re: Data Explorer export to CSV - remove 100 entries limit

Kenny_Gillette — Fri, 09 Jun 2023 12:49:23 GMT

Based on what I see:

These release notes relate to Dynatrace Managed specific changes. To learn about general Dynatrace changes included in this Dynatrace Managed release, see:

Dynatrace SaaS release notes version 1.266 and Dynatrace SaaS release notes version 1.265

So appears managed gets SaaS updates for general stuff like this.