Skip to main content

Composer (Report Building)
Composer (Report Building)

All about the composer section in DashboardFox and tips and tricks and questions related to building reports (Documents).

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

A lot of this will depend on the structure of your data, but one of the easiest ways to accomplish this is to use a formula function, max(?).

Assuming you have a date field which marks the timestamp of each... (More)

It's not a very useful error message, but it does have a very common reason. The error is most likely caused by one of these errors in the App Builder (and one potentially due to formulas in the Composer):

  • Applying... (More)

DashboardFox allows a report builder to join data between multiple reports (or even apps/data sources). In the Composer section, the Linked Report feature starts the process of combining separate reports into one.

Linking reports together via an in-memory join or... (More)