Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA charts are shown in weeks in bars instead of days

DPA charts are shown in weeks in bars instead of days

Table of contents

Updated November 18, 2016

Overview

This article will cover why a DPA  would  group as weeks not days. In the trend view charts 

Questions are like the following:

"Some of my views for specific instances are setup in a daily view and the others are grouped by week, I want to be able to see daily no matter what instance I am monitoring and I cannot find the settings anywhere. "

Daily example chart

Weekly example chart

Environment

All DPA versions

Detail

DPA uses a formula to determine if we are going to group by day or by week. This mostly has to do with the retention settings for DPA.

Here is the formula:
startTime - earliest time in CONTT_X
endTime - latest time in CONTT_X

difference = endTime - startTime 

(The difference is in days rounded up)

You can get start and end times from CONTT_X or you can look at the "Days" dropdown on the Trend page to get the number of days.

Logic for trend chart granularity:
If difference *24 < 73 then HOUR granularity // 3 days or less than HOUR
If difference <= 95 then DAY granularity // 95 days or less than DAY
If difference / 7 <= 104 then WEEK granularity // 104 weeks or less WEEK
Otherwise MONTH granularity