Dashboard Schema

Field

Fields are the dimensions that you can add and use in your dashboard elements. You can either add from the suggested fields or as a custom field. The suggested fields are based on the last 25 transactions on the app and forms.

  • Label for the field will be shown in the dashboard element.

  • Field is used to map the value field of the world state to a dashboard element.

  • Enclose the key of the world state in {{}}. PostgreSQL syntax can be used in Field. eg. EXTRACT (month FROM age (TO_TIMESTAMP ({{loanApprovedDate}},’YYYY-MM-DD’), TO_TIMESTAMP ({{xldb_createdDTM}}, ’YYYY-MM-DD’)))

  • Standard fields (such as Transaction date or State last-modified-date) are always available for Measures and Dashboard elements and do not need to be added.

  • Quickly add fields using suggestions, which are offered by the Xooa AI. To train or retrain the Suggestions AI, invoke new transactions or directly write to the World State (if using XLDB).

 

Note

Define the correct Data type of each field. This step is necessary to avoid any inconsistencies.

Measures

Measures are the aggregations that you can define and use in your dashboard elements. The aggregations can be defined on the fields and existing measures. Several types of aggregations are available viz. Average, Sum, Number, Count, Count Distinct, Count distinct approx, Min, Max and Running total.

  • A complex query can also be written while defining aggregation queries. eg. COALESCE(student_age (field),0)+COALESCE(employee_age (field),0).

  • Filters can also be added to the aggregation query. eg. employee_type (field)=‘sales’.

  • PostgreSQL syntax can be used in Value Field.