Skip to main content
Discussion
Latest Updates

🎉 New Updates: DashboardFox v11.4 Build 11.21.09.09

New features and fixes:

The following fixes and improvements apply to DashboardFox v11.4 Build 11.21.09.09

⚡️ New: Custom Hover Overs

⚡️ New: Filter and Criteria Via Defined Report List

⚡️ New: Filter and Criteria Values Sort Order

🔥 Improvement: Ne... (More)

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.

DatatypeDescriptionExample
chaCharacter data type – values can be any text string and are sortable as textString of Words
numNumeric data type – values are expected to be numeric and sortable as numbers4387
udtUnix 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 date4/2/2015 15:35
datSQL Date Time – the underlying data is stored in SQL Date time This is sortable as date4/2/2015 15:35
lnk and ddn and 800This 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 reportshttp://www.google.com
forThis 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) applyn/a
dmyUnix 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 date4/2/2015
tdaThis will convert a numeric representation of seconds to a “days” value86400 = 1
thrThis will convert a numeric representation of seconds to an hours value3600 = 1
tmiThis will convert a numeric representation of seconds to minutes60 = 1
500This field will take a unix date time and subtract it from current time to get duration in days0.56
501This field will  take a unix date time and subtract it from current date to get duration in hours87.26
502This field will  take a unix date time and subtract it from current date to get duration in minutes59.86
503This field will  take a unix date time and subtract it from current date to get duration in seconds78
504This field will  take a unix date time and subtract it from current date to get duration in D:H:M6 days: 10 hrs: 30 min
dhmConvert duration in seconds to get duration in d:h:m6 days: 10 hrs: 30 min
600Display a UNIX date time field in time part only15:35
dpoThis will take an underlying date time value and display it as date part only4/2/2015
curThis will take a numeric value and display it as currency$564.25
tmrThis will display a time span in seconds as a Count Down Timer 
idtUse this data type when the underlying data source stores a date value without a time element4/2/2015

🤩 Check out our latest article "Top 5 Interview Questions for a BI Project Manager"

Finding the right BI project manager is hard to find. In this article, we will discuss the 5 interview questions to ask for prospective BI project managers.

Read the full article here -> https://dashboardfox.com/blog/top-5-interview-questions-for-a-bi-project-manager/

Discussion
Latest Updates

🎉 New Updates: DashboardFox v11.4 Build 11.21.06.02

New features and fixes:

The following fixes and improvements apply to DashboardFox v11.4 Build 11.21.06.02

🚀 New: Map Drill down support

🚀 New: Map Additional maps added for US states

🚀 New: App registration additional connection string parameters

🚀 New... (More)