Data visualizer card
Last updated
Was this helpful?
Last updated
Was this helpful?
The Data visualizer card portlet allows visual representations of data with different types of cards. The usage of this portlet allows the user to get an easy overview of performance figures by viewing live data. Currently there are three different types of cards that can be used with this Portlet; Default, Process Card and Speedometer. These three layouts are shown below.
Default Style
Process Style
Speedometer Style
Internal name - unique string to identify this portlet. Portlet title - title of the portlet, does not have to be unique.
Enables the portlet to refresh the data every SS:second.
Commands enables the portlet to listen for events sent by other portlets to execute specified commands. The portlet will listen to the following commands
onRowSelected
onRefresh
onFilter
The portlet will listen to the following portlets Specify which portlet the commands above will trigger from. The portlets that appears will be shown with their unique internal name.
As in all other data based Portlets there are two options to retreive data to the portlet; Database and Workflow. To use Database as data source, select a database from the Database connector drop-down and then write your query in the Your query textbox. The data retrived from the database should match what is needed in the Output Datasource Configuration section, which is described below.
This configuration defines what information to show in the Cards.
Description - The column in the table that represents the KPI name.
Description Default - If there is no value chosen in Data, this will replace that text
Data - The column that represents data, can be used for e.g. "Amount of orders picked".
Unit - The kind of unit the Data is measured in.
Priority Value - A field that can represent the level of priority the card represents.
Trend Value - The current trend of the KPI, value needs to be between -2 and 2.
There are three different card styles that can be used for displaying data; Default, Process Card and Speedometer. Select the one that should be used. Depending on style, the Display Configuration offers different possibilities.
For the Default or Process Card styles, the following configuration can be made.
Background - Color of the background in the card.
DefaultColor - If no other criteria is fulfilled this will be the default color.
Color Rules - A color which will be used as background when criteria is fulfilled.
First Value - A value which will be used for comparison.
Func - A function that will used for the comparison calculation. e.g. "Greater than" "Less than" "Equals"
**Second Value* - The value that will be compared to the first value using "Func"
Text - Color of the text in the card.
For the Speedometer Card style, the following configuration can be made.
Thickness - The thickness of the speedometer line.
Min - Minimum value for the speedometer. Scale will start on this value.
Thickness - Maximum value for the speedometer. Scale will end on this value.
Line foreground color - Default color on the speedometer line. Will be applied if none of the line color rules is matched.
Line foreground color rules - Color for the speedometer line will be set according to these rules. The top-most rule has the highest priority and will be applied first.
Pos - Drag and drop to change the order of the color rules.
Colour - Select which colour should be applied with this rule.
First Value - A value which will be used for comparison. Use "{}" for expressions, e.g. {INV_AMOUNT} to use the value from the column INV_AMOUNT coming from the applied query or workflow.
Func - A function that will used for the comparison calculation. e.g. "Greater than" "Less than" "Equals"
**Second Value* - The value that will be compared to the first value using "Func". Same expression as in First Value can be applied here.
Line background color - Default color on the background of the speedometer line. Will be applied if none of the line color rules is matched.
Line background color rules - Color for the speedometer line background will be set according to these rules. The top-most rule has the highest priority and will be applied first.
Pos - Drag and drop to change the order of the color rules.
Colour - Select which colour should be applied with this rule.
First Value - A value which will be used for comparison. Use "{}" for expressions, e.g. {INV_AMOUNT} to use the value from the column INV_AMOUNT coming from the applied query or workflow.
Func - A function that will used for the comparison calculation. e.g. "Greater than" "Less than" "Equals"
**Second Value* - The value that will be compared to the first value using "Func". Same expression as in First Value can be applied here.
Background color - Default color on the background of the entire Card. Will be applied if none of the color rules is matched.
Background color rules - Color on the background of the entire Card will be set according to these rules. The top-most rule has the highest priority and will be applied first.
Pos - Drag and drop to change the order of the color rules.
Colour - Select which colour should be applied with this rule.
First Value - A value which will be used for comparison. Use "{}" for expressions, e.g. {INV_AMOUNT} to use the value from the column INV_AMOUNT coming from the applied query or workflow.
Func - A function that will used for the comparison calculation. e.g. "Greater than" "Less than" "Equals"
**Second Value* - The value that will be compared to the first value using "Func". Same expression as in First Value can be applied here.
Text color - Default color on the texts in the Card. Will be applied if none of the color rules is matched.
Text color rules - Color on the texts in the Card will be set according to these rules. The top-most rule has the highest priority and will be applied first.
Pos - Drag and drop to change the order of the color rules.
Colour - Select which colour should be applied with this rule.
First Value - A value which will be used for comparison. Use "{}" for expressions, e.g. {INV_AMOUNT} to use the value from the column INV_AMOUNT coming from the applied query or workflow.
Func - A function that will used for the comparison calculation. e.g. "Greater than" "Less than" "Equals"
**Second Value* - The value that will be compared to the first value using "Func". Same expression as in First Value can be applied here.
For more information how to set up a Workflow Data Source, please read this section: The data retrived from the workflow should match what is needed in the Output Datasource Configuration section, which is described below.
