Setting Granularity for data display in reports and charts
Hi,
I want to generate CPU load report for last 24/72 hours with 10 minutes granularity, so that I can see the values at 10 minutes interval for the server.I am not able to find out the option where I can define the granularity , so the system is taking the default granularity and aggregating values to 15 minutes , 1 hour etc. Just wondering where can we define the granularity at which data is reported or charted.
Anurag
The granularity can be set in the charting options. Unfortunately there is no option for 10 minutes - you can only select from the pre-defined values such as 1m, 5m, 15m, ...
Say for example I want to generate a report with a table that shows 24 hours worth of web requests that shows web request count every 15 minutes? Though I see the option available for charts, its not available for tables, is that right?
I assume you talk about the Table View Option that a chart gives you. The answer is YES. The table on the bottom shows you which measures you are displaying in the chart. There is a column like Min, MAx, Avg Last Value... but these just show that value based on the timerange. If you really want to see how often which URL was executed in a 15 min interval you have to look at the chart where every "dot" will represent your 15 minute observed value.
If you want to display this differently you could look into exporting/extracting the raw data behind the chart through our REST interface. You can query the raw data and get it as XML or JSON and then you can visualize it as you like in external tools
Andi
I'm actually looking at the web request dashlet or the dynamic matrix chart, which doesn't have a chart vs table option, just the table itself?
The Web Requests Dashlet is always analyzing ALL PurePaths to display that table and is not using metrics. Please keep this in mind if you open it up for 24h as this means everytime you refresh it dynatrace needs to analyze 24h worth of PurePaths
The Dynamic Measure Maxtrix is based on Measures that come from the Perofrmance Warehouse. That is the way to go. There is not built-in option though to display values for every 15 minutes
Depending on the use case you have you might need to look into extracting the raw data and display it in an external tool the way you like it
