Application Conventions

From dataZoa Wiki
Revision as of 15:16, 27 January 2017 by SNC (Talk | contribs) (Missing Data Values)

Jump to: navigation, search

This is a collection of conventions, rules and limitations employed in dataZoa

Account Attributes

  • USER NAME:
    • Must start with a letter, contain only letters, numbers, and underscores (“_”), and have at least 6 characters.
    • Not case-sensitive.
  • PASSWORD:
    • Any combination of between 6 and 25 characters.
    • Case sensitive

Series Attributes

  • SERIES KEY:
    • Used to identify a particular data series as stored in dataZoa.
    • Globally unique.
    • Composed of user name followed by forward slash followed by eight digits (user_name/12345678)
    • Maximum number of series keys per user account is one hundred million (100,000,000)
  • SERIES TITLE:
    • Up to 400 characters long,
  • MAXIMUM NUMBER OF SERIES PER EXPORT:
    • 200


GroupList Attributes

  • MAXIMUM CHARACTERS IN NAME:
    • 127
  • MAXIMUM NUMBER OF GROUPLIST NAMES SHOWN:
    • 2500
    • This does not limit the actual number of grouplists, only the number displayed in the User Interface dropdown list.

Missing Data Values

Non-Numeric Type Meaning String to enter as Input String displayed as Output
No Data Data point is known not to exist ##ND## ND
Non-Disclosed Data Data point exists but is not being shown ##NDD## NDD
Not Available Data may exist but is not available ##NA## NA

NA Handling

In calculations, NA values in the inputs yield NAs as outputs by default. Optionally, you can fill the inputs with their neighboring values before they are evaluated. In particular:

  • Fill forward
  • Fill backward
  • Fill forward, then backward
  • Fill backward, then forward
  • For example: Fill Forward, then Backward of NA, 2, NA, 4, NA yields2, 2, 2, 4, 4

Dates

  • EARLIEST DATE:
    • Because of the calendar discontinuity introduced at the Gregorian transition, the earliest year that can be stored accurately to the day is 1753.
    • Non accurate dates can begin as early as 1/1/1000.
  • LATEST DATE:
    • 12/31/9999
  • PERIODICITIES (FREQUENCIES):
    • Daily
    • Weekly
    • Monthly
    • Quarterly
    • Semiannual
    • Annual
    • Irregular


Both American-style mm-dd-yyyy dates and International Style dd-mm-yyyy date formats are supported.

Supported date formats include:

Fully SpecifiedYear OnlyMonth, Year OnlySemi-AnnualQuarterly
01-15-2011
01-15-11
01/15/2011
01/15/11
15-01-2011
15-01-11
15/01/2011
15/01/11
15-Jan-11
15JAN2011
2011-01-15
20110115
Jan 15 2011
January 15, 2011
Sunday, January 15, 2011
110115
2011 1/11
1/2011
01-2011
2011m01
2011 Jan
2011Jan
Jan 2011
Jan2011
2011H1
2011h1
2011Q1
2011q1

Miscellaneous

  • WORKBENCH PAGESIZE:
    • The number of series titles listed in the Workbench view can range from 5 - 500, as set in Account Controls Preferences tab.
  • DZBOARD CAPTION STRINGS:
    • Maximum 32,000 characters