Difference between revisions of "Application Conventions"
From dataZoa Wiki
(→Dates) |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 13: | Line 13: | ||
** Used to identify a particular data series as stored in dataZoa. | ** Used to identify a particular data series as stored in dataZoa. | ||
** Globally unique. | ** Globally unique. | ||
| − | ** Composed of user name followed by forward slash followed by eight digits (user_name/12345678) | + | ** Composed of user name followed by forward slash followed by eight digits (e.g '''user_name/12345678''') |
** Maximum number of series keys per user account is one hundred million (100,000,000) | ** Maximum number of series keys per user account is one hundred million (100,000,000) | ||
* SERIES TITLE: | * SERIES TITLE: | ||
| Line 31: | Line 31: | ||
{{Template:MissingValuesTable}} | {{Template:MissingValuesTable}} | ||
| + | |||
| + | ===NA Handling=== | ||
| + | |||
| + | {{Template:NA_Handling_Table}} | ||
===Dates=== | ===Dates=== | ||
| Line 37: | Line 41: | ||
{{Template:Periodicities}} | {{Template:Periodicities}} | ||
| + | |||
| + | {{Template:Date Input Formats}} | ||
===Miscellaneous=== | ===Miscellaneous=== | ||
| Line 45: | Line 51: | ||
[[Category: Advanced]] | [[Category: Advanced]] | ||
| + | [[Category:Intermediate]] | ||
Latest revision as of 08:59, 10 February 2021
Contents
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 (e.g 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 Specified | Year Only | Month, Year Only | Semi-Annual | Quarterly |
|---|---|---|---|---|
| 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
