Data explorer Table visual - "per day" - "per host" - "metric" last 30 days reporting

[Teodora]

Hello!

I am new to Dynatrace and I am trying to Run a query which would visualize a list with 3 columns:

1) Date 2) Host 3) CPU Max %

I need this query for last 30 days e.g. but when I use Table mode in data explorer, I cannot get the "Date" column, even though I've set the Resolution = 1 day. I see only 1) Host and 2) CPU Max %

I capture all the columns that I need in Graph mode, but unfortunately there is records limitation of 100 (even after I delete the :limit).

Can anyone advise how I can get that query?

Thanks!

[Alejandro]

Hi,

I am afraid what you are trying to achieve is not supported in tables since it is not a timeseries based visualization.
On the other side, Graph has a max limit of 100 results that is applied by default if there is not a explicit limit set.

In order to see if there is any other alternative, could you share more about your use-case? Which date would you expect to see in that first column? And what do you miss when you use the Graph?