Dashboard Schema

Field

Fields are the dimensions that you can add using dashboard schema and use in your dashboard elements. You can either add field from the suggestions or as a custom field. The fields from suggestions 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.

  • Quickly add fields using suggestions, which are offered by the Xooa AI.

  • Set the most appropriate data type of a field, for the best data formatting and filter operands availability.

  • We have predefined fields configured under dashboard schema which are

    • token Id: unique token ID
    • token type (i.e. ERC 721 token, ERC 721 subtoken etc.):type of token standard
    • subtoken Id: Token ID + tile + sub token ID
    • transfer dtm (NFT transfer date and time): Date and Time of token transfer
    • token price: Sum of the price of all the tokens

Refer to the screenshot given below
Fields

 

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.

  • We have predefined measures configured under dashboard schema which are

    • countTokens: Count the total token IDs
    • Subtoken_Count: Counts the subtokens of a token
    • Token_Price: Sum of the price of all the tokens

Refer to the screenshot given below
Measures