search cancel

Time Scale Values Settings in Classic Clarity

book

Article ID: 28482

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

How are the Time Scale Values (TSV) settings expected to work in Clarity?  

Resolution

Modern User Experience

It's recommended to consider using the Modern User Experience (UX) where there are no boundaries on TSV per-period metrics. 

See: Clarity: Staff a Project Team for more information.

External and Internal Slices

There are external and internal slices that exist in Clarity. Internal slices are not exposed in the Administration > Data Administration > Time Slices page, due to potential performance issues. The internal slices feed various grid (time-varying) portlets in Clarity. By design, there will be a limited window of data to view, i.e

  • Quarterly: 12 periods (4 quarters in the past, start of current quarter + 8 quarters into the future)
  • Monthly: 36 periods (12 months in the past, start of current month + 24 months into the future)
  • Weekly: 16 periods (2 weeks in the past, the current week + 13 weeks from the current week)
  • Daily: 28 periods (7 days in the past, start of current day + 21 days into the future)

These data ranges may not be changed by end users. See "The time periods requested do not exist" Warning when moving to future or past periods on a TSV field for one approved extension that can be implemented. 

Note: Make sure that the Datamart Extraction job runs on a nightly basis in order for the calendar-based portlets to populate.

Classic Clarity 

  1. Go to the Configure > Time-scaled value link



     2. The start date that is chosen, be it rolling or specific, must fall within the system-restricted date ranges. The current start date determines the total date range to view

     3. From the Configure > Time-scaled value page, provide/review the following:

    • What is the "Start Date" field set to? (Specific Date, Rolling Date, Other Date)
    • What is the "Number of Time Periods" (total to view in the scale) ?
    • What is the "Time Period Offset" (to shift from the 'Start date')?

     4. Use the following link as a reference to a calendar calculator:
https://www.timeanddate.com/date/dateadd.html

An example, using the weekly time-scaled view is: Given current start of week is: Monday, July 23, 2018

  • What is the "Start Date" field set to? Monday, July 23, 2018
  • What is the "Number of Time Periods" (total to view in the scale) ? 12 weeks
  • What is the "Time Period Offset" (to shift from the 'Start date')? 0

Clarity will calculate the viewable weekly range to be 2 weeks in the past, the current week + 13 weeks from the current week

which translates to the range: Monday, July 23, 2018 to Monday, October 21, 2018

An example, using a weekly time-scaled view with an offset is:

  • What is the "Start Date" field set to? Monday, July 23, 2018
  • What is the "Number of Time Periods" (total to view in the scale) ? 12 weeks
  • What is the "Time Period Offset" (to shift from the 'Start date')? -8

Clarity will calculate the viewable weekly range to be 2 weeks in the past, the current week + [offset]  + 13 weeks from the current week which translates to the range:

[Monday, July 23 , 2018] + [-8 weeks] + 13 weeks into the future

which is [Monday, May 28, 2018] to [Sun, August 26, 2018]

Regarding aggregated totals, the data will  automatically be set into the periods designated by the periods set in the Configure > Time-scaled Value menu.
The results will be automatically converted. In the example below, the weekly hours 40 + 40 + 40 + 40 + 16 = 176

Weekly

 

Monthly

Additional Information

See "The time periods requested do not exist" Warning when moving to future or past periods on a TSV field for one approved extension that can be implemented. 

Attachments