This table describes the most data-types used internally to DashboardFox. These data types were configured to allow for custom post-processing of data before it is displayed in the client.
| Datatype | Description | Example |
|---|---|---|
| cha | Character data type – values can be any text string and are sortable as text | String of Words |
| num | Numeric data type – values are expected to be numeric and sortable as numbers | 4387 |
| udt | Unix Date-Time – The underlying data is stored as unix date time (number of seconds since 1970) The UDT data type tells Yurbi to convert this value to a date time display. This is sortable as a date | 4/2/2015 15:35 |
| dat | SQL Date Time – the underlying data is stored in SQL Date time This is sortable as date | 4/2/2015 15:35 |
| lnk and ddn and 800 | This is an internal data type where the field is processed into a hyper link. ** This datatype is deprecated and should be replaced with Ad-hoc field builder feature when creating reports | http://www.google.com |
| for | This is when a formula is applied to the field used in the builder. Specifically if none of the base data types (cha, num, dat, udt) apply | n/a |
| dmy | Unix date time display as date part only. This will convert a unix date time stamp into a date part only string that is sortable as a date | 4/2/2015 |
| tda | This will convert a numeric representation of seconds to a “days” value | 86400 = 1 |
| thr | This will convert a numeric representation of seconds to an hours value | 3600 = 1 |
| tmi | This will convert a numeric representation of seconds to minutes | 60 = 1 |
| 500 | This field will take a unix date time and subtract it from current time to get duration in days | 0.56 |
| 501 | This field will  take a unix date time and subtract it from current date to get duration in hours | 87.26 |
| 502 | This field will  take a unix date time and subtract it from current date to get duration in minutes | 59.86 |
| 503 | This field will  take a unix date time and subtract it from current date to get duration in seconds | 78 |
| 504 | This field will  take a unix date time and subtract it from current date to get duration in D:H:M | 6 days: 10 hrs: 30 min |
| dhm | Convert duration in seconds to get duration in d:h:m | 6 days: 10 hrs: 30 min |
| 600 | Display a UNIX date time field in time part only | 15:35 |
| dpo | This will take an underlying date time value and display it as date part only | 4/2/2015 |
| cur | This will take a numeric value and display it as currency | $564.25 |
| tmr | This will display a time span in seconds as a Count Down Timer | Â |
| idt | Use this data type when the underlying data source stores a date value without a time element | 4/2/2015 |
