Card Item

Name

Each item can be renamed by the user

X

Description

This feature allows you to add a description to a specific item. A description will appear below the item's data.

Value

The field on which the card item will perform the calculation. It is possible to select only one value. The default option will not be available.

Summary type

The value will have different types of summary/total calculation.

• The different types are: Count distinct, Sum, Average, Min, Max.
  

• The value field type (numeric/textual/ date) will affect the valid options for the summary type:

  • Numeric - Count distinct, Sum, Average, Min, Max

  • Textual - Count distinct

  • Date - Count distinct, Min, Max
    

• The user must choose a value before choosing a summary type (the summary type drop down will be disabled before choosing the value).
  

• After choosing the value, the default summary type will be selected automatically (according to the field type). The user can change the summary type, but only the relevant summary types will be shown (according to the field type). If the user changed his selection and chose a value with a different type, the summary type will change to the type's default state. The defaults:

  • Numeric - Sum

  • Textual - Count distinct

  • Date - Count distinct

Format type

Can include the number ,percent and currency.

Number - show the value as a number

Percent - multiply the value by 100 and show as percent. example: if value is 0.8, show 80%

Currency – show the value with $. example: if value is 0.8, show 0.8$

for each format type, the user can define precision - any number between 0-3. default will be 0.

If the user chose textual or date field type for the value, the format type drop down will be disabled.

Filter

The “Filter” can be used to filter out elements from the chosen value, only for the specific data item. As default, no filter will be defined. The filter will have predefined options based on the chosen field type:

• Numeric - equal to, not equal to, greater than, less than, between

• Textual - equal to, not equal to, contains.

• The conditions can be concatenated by And, Or functions

• For example, L/H < 10 Or Generator KVA != 0.