Login: displays projects where to connect

Login:

• Projects: List of available projects
• Open projects: Open file explorer to select a project *.xml
• +New project: Create a new project
• Reset projects: Reset the list to project stored in \storm.project
• Clear registery: Clear all users choices
• Documention: contextual documentation
• User: User ID
• Password: Authentication password
• Sign in: Attempt to login

Start: display a menu with dashboards

Start:

• Start: Get the drop down menu
• Arrow: Open/close a group
• Fold/Unfold: Fold/unfold all groups
• Find: Search dashboards with few characters
• Reset DB connection: Reset connection
• Clear registry: Get back Load default parameters

Speed dial: is a clone of Start menu

Speed dial:

• Tabs: Display dashboard according to business logic
• Recent dashboards: List of recent opened dashboards
• Clear recent dashboard: Clear the list
• Find: Search for a dashboard
• Image: To change backgroud image

Dashboard: Multipage document displaying loaded data into widgets

Dashboard:

• Left side bar:
  • Name: dashboard name
  • Load: Load dialog
  • Table of content: page navigation
  • Find: Search data in widgets
  • Edit: Edit menu
  • + Widgets: Add widgets
• Current page: displaying widgets with loaded data
  • KPI
  • List
  • Pivot
  • PivotList
  • Chart
  • …

Load: Select parameter values for real-time data loading.

Load:

• Load: Load data in real-time
• Clear: Deselect items from all parameters
• Reset: Restore default params
• Fold/Unfold: Group of params
• Find: Search through all params list
• Param scroll bar: Scroll show params
• Item scroll bar: Scroll items list
• Item selection: Ctrl-click to add or Shift-click to create a selected list since previous click
• Find: (item) Search through the list
• Logical operator: Define loading condition operator
• Date editor: Enter a valid date, manually or with calendar
• Text field: Enter a text as condition
• X: Hide a show param

Side bar: display Load button and the table of content

Side bar:

• Load: Get loading dialog
• Page name: Display as current page
• Edit: Context menu
• +Widget: Add a widget

Side bar context menu:

• Print: Print menu
• Add page: Add a page
• Duplicate page: Duplicate current page
• Remove page: Remove current page
• Add widget: Add a widget
• Align to grid: Align unpin widgets to grid
• Pin/Unpin widgets: Pin/unpin widgets
• Cascade widgets: Display widgets in cascades
• Unload data: Unload data
• Save as: Save dashboard with loading parameters in a repository

Select: Create a Context by clicking on widgets elements

Widget:

Rows: Select one or several rows of a list

Cells: Select one or several cells of a pivot

Areas: Select one or several areas of a chart

Context menu: is for data navigation, printing , resizing and copy/past.

Context menu:

Object editing:

• Edit: Customize current object

Export:

• PDF: Exporting widget data into *.pdf
• Excel: Exporting widget data into *.xlsx

Data navigation:

• Drill down: Tree with possible navigations to connected data
• Snapshot: Standalone widget with selected data
• Dashboard: Dashboard with selected data
• Details: Details windows with selected elements

Copy screen:

• Screenshot: Copy screen to clipboard

Size and position:

• Maximize: Display widget in full page
• Pin: Pin / Unpin widget

Find:

• Find: Search a value

Context sub-menu:

• Resize columns: Depending on data width
• Resize header: Depending on header width
• Copy selection: Copy selected rows to clipboard
• Copy cell text: Copy selected cell text to clipboard
• Copy cell value: Cotpy selected cell value to clipboard

Object menu: Select an Object to be visualized.

Widget toolbar: Set of icons for data navigation, printing, resizing and copy/past, for the selected contact.

Widget toolbar

• Widget menu: (Hamburger menu) Get the list of objects to be selected
• Edit: Customize current object
• PDF: Exporting widget data into *.pdf
• Excel: Exporting widget data into *.xlsx
• Drill down: Tree with possible navigations to connected data
• Snapshot: Standalone widget with selected data
• Dashboard: Dashboard with selected data
• Details: Details windows with selected elements
• Screenshot: Copy screen to clipboard
• Maximize: Display widget in full page
• Pin: Pin / Unpin widget
• Find: Search a value

PDF: is exporting widget data into *.pdf

Excel: is exporting widget data into *.xlsx

Drilldown: Tree with possible navigations to connected data.

Snapshot: create a standalone widget with selected data

Dashboard: Create a dashboard with selected data

Widget editor: Features a common icon bar

Widget editor: common icon bar

• Object ID: Unique object identifier.
• Alias: Object name for user. When a new object is created, the alias is used to generate the Object ID.
• Description: Object description, displayed on the Tips.
• Parent ID: The object may belong to a dataset. It will then only be available for this data set.
• Icon: An icon can be selected.

List widget: Displays data in list form, with rows, columns and a totals row.

List edit: Editor of list object

Editor for defining column sequence, row sorting and totals

Factor:

• Factor: Available factors to become a visible column

Columns:

• Drag & Drop: Factor to Columns to add
• Del key: Remove a column
• Drag & Drop Up/Down: Change column sequence

Sorting:

• Sorting: Rows by columns value
• Drag & Drop Up/Down: Change sorting sequence
• Drag & Drop: Factor to Sorting to add a sort
• A0→Z9: Reverse sorting
• Sorted by code: Sorting by internal code
  
• Total break: Display total line

Options:

• Show total for single line: Add total also for single line
  
• Show grand total row: Add a grand total
  
• Total on top: Display total first
• Show row number: As first column
  
• Show column names: Display column header
  
• Stretch all columns: Maximize number of visible columns
  
• Stretch last column: On available space
  
• Header height: Number of line. ‘0’ provide default
  
• Row height: Number of line. ‘0’ provide default

Script:

• JavaScript code: Executed before visualization

Pivot: Display values in a tree, with distributed columns and an associated chart.

Pivot edit: Editor of pivot object

Factor:

• Factor: Available factor to become a pivot dimensions or value

Dimensions – Rows:

• Drag & Drop: Factor to Rows to add
• Del key: Remove a row
• Drag & Drop Up/Down: Change row sequence
• Sorting: Current row by selected sort type
• Limit: Number of rows for current level. An “Other” node will group together the other

Dimensions – Columns:

• Drag & Drop: Factor to Columns to add a distributed column
• Del key: Remove a distributed column
• Drag & Drop Up/Down: Change distributed column sequence
• Sorting: Current column by selected sort type
• Limit: Number of column for current level. An “Other” node will group together the other

Values:

• Drag and Drop: Factor to Factor value to be distributed
• Alias: May override factor name
• Mode of column:
  • Blank to display value
  • delta from previous column
  • % delta from previous column
  • % Row
  • % Column
  • % Total
  • % parent
• Show in chart: Display the value in chart

Chart:

• Enable chart: Chart pivot data
• Chart type: Type of chart
• Chart levels: Number of pivot level to chart 
• Stack type:
  • Blank for no stack
  • normal to stack value
  • percent to stack value in % 
• Use rows as axis: Swap pivots axis
• Show legend: Of each category
• Color by point: One color per category
• Merge values axes: Only one axes
• Reversed order:
• Connect nulls:
• 3D: 
• Debug mode:

Options:

• Tree width: Number of visible chars
• Tree name: Specific name
• Value width: Number of visible chars
• Header height: Number of rows
• Visible level: Expend tree up to 
• Hide columns: Column numbers to hide
• Widget stretch:

Script:

• JavaScript code: Executed before visualization

Pivotlist: Display data and values as a Pivotlist, a combination of a pivot and a list, with a tree structure, distributed columns and a connected list under each last node..

Pivotlist edit: Editor of pivotlist object

Chart: Display data as chart

Chart Edit: Editor of chart object

Factor:

• Factor: Available factor to become a chart dimensions, series or value

Axis X:

• Dimensions:
  • category
  • datetime
  • linear 
• Drag & Drop: Factor to Dimension
• Sort: Select a sort type for the X axis

• Parse factor as: Double click to get the list
• Show title: Dimension factor will be display
• Title text: Specific text title
• Show labels: category
• Allow decimals:

Charts:

• +Add: Add a new type of chart
• Drag & Drop: Factor to Value
• Drag & Drop: Factor to Split
• <chart>: Chart editor

Chart editor

• Chart type: Type of chart
• Show chart name on value axis: Specific text
• Value: Factor value to chart

Split

• Split: Split factor
• Stack:
  • blank for no stack
  • normal to stack value
  • percent to value in %  
• Limit: Number of category. An “Other” node will group together the other

Flag:

• Cumulative:
• Show labels:
• Show legend: Of each category
• Color by point: One color per category
• Connect nulls: 
• Allow decimals: 
• Axis on the right: Left is default
• Activate pareto:

Pie:

• Size: 
• Inner size:
• Center X:
• Center Y:
• Start angle:
• End angle:

Appearance:

• Title
• Layout
• Align
• Vertical align

Options:

• Merge values axes
• Reversed order
• Date range selector
• Rotate chart
• Show model
• Debug mode

Annotation:

• See example

Script:

• JavaScript code: Executed before visualization

KPI: Display Key Parameter Indicator

KPI Edit: Editor of KPI object

Value:

Factor: to be displayed as a KPI

Expression: Function or Javascript code

Options:

Style: 

Smart formatting: 

Format: 

Left pad:

Right pad: 

Background: 

Foreground: 

Geomap: World map

Geomap edit: editor for world map

Filter: loaded data are filtered at widget level

Filter:

• Factor: to filter data on this widget
• Compare: logical operator
• Expression: list of values

Script: Executed before data visualisation

In this Demo – StormToOdoo, this widget is calling AlaSQL to display the last movement of each months.

https://www.w3schools.com/js/

https://alasql.org

Script:

• JavaScript code: Executed before visualization