Only this pageAll pages
Powered by GitBook
Couldn't generate the PDF for 168 pages, generation stopped at 100.
Extend with 50 more pages.
1 of 100

Governed Dashboards

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

About Dashboard Designer

BDB’s Designer module is a web browser-based application used to build governed dashboards and design analytics.

Getting Started

BDB’s Designer module is a web browser-based application used to build governed dashboards and design analytics.

Left Menu Panel

The Designer Homepage contains a menu panel on the left side. This section aims to explains the options provided under that panel.

Why is it used?

Right side Panel

Action Menu

The Actions menu contains some more options like Preview, Export to Local Disk, Rename and Move to that can be applied on the dashboards Action.

Create New Workspace

Create New Dashboard

Connecting to a Data Source

This section explains how to access the various data connector options and step-by-step process to create a connection by using all the available data connectors.

Establishing a Data Connection

This page displays steps involved in establishing various choices of Data Connectors available inside the Designer module.

Exit

  • Navigate to the Designer homepage.

  • Click the Exit option.

  • If work is not saved, the user gets an option while closing to leave or cancel the action of exit. Select the Cancel option if you require to save the work, or else choose Leave to close the designer.

  • The user gets directed to the Platform homepage.

Please Note: The user can also click the Close icon (the 'x' icon on the right edge) of the Designer tab to leave/close the designer tab.

Accessing the Designer Module

This section covers steps to access the Designer module from the Platform Apps menu.

  • Navigate to the Homepage of the platform.

  • Click the Apps menu icon.

  • Click the Designer module.

  • The Designer homepage opens.

Chart Container

The Designer canvas page offers an icon to access the supported charting components for the dashboard creation.

  • Navigate to the Dashboard canvas.

  • Click the Component Library icon.

Workspace Creation: Complete Flow

A Workspace is a placeholder where users can save multiple dashboards.

Workspace once created under the Designer module works as a placeholder for multiple dashboards. If you compare a dashboard with a document/file, then the Workspace created to store them is like a folder. The creation of a new Workspace and understanding the various credited options to an available Workspace under the Designer module are aimed to be explained through an illustration. Check out the given walk-through on the complete flow of Workspace creation.

Workspace once created under the Designer module works as a placeholder for multiple dashboards. If you compare a dashboard with a document/file, then the Workspace created to store them is like a folder. The creation of a new Workspace and understanding the various credited options to an available Workspace under the Designer module are aimed to be explained through an illustration.

Check out the illustration to understand the Workspace creation and apply various actions to a created Workspace.

Associate the Dataset

  • Right click on the dragged component.

  • Select the Dataset property option.

  • Select the created connection from the list.

Dashboard Creation: Basic Workflow

To create a dashboard the user needs to go through multiple pages and use various options provided under the Designer module. It begins with adding a new Dashboard and goes all the way to create a data connection, drag multiple charting components, associate the created data connections with the dragged charts, preview the dashboard data, and finally save the created dashboard.

Please check-out the given walk-through on the complete flow of dashboard creation under the designer module.

New

This option directs users to create a new workspace or dashboard.

  • Navigate to the Designer homepage.

  • Click the New drop-down menu.

  • The user gets two options:

Export to Local Disk

The Export to Local Disk option exports the selected dashboard to the local disk.

  • Select a dashboard using the Manage option.

  • Choose the Export to Local Disk option from the More Actions context menu.

Overview of Designer Module

This section aims to give an overview of the Dashboard Designer focusing on the two main screens that appear under the Designer module: Homepage and Designer Canvas.

Check out the following walk-through to get an overview of the Designer module.

Help

Help

  • Navigate to the Designer homepage.

  • Click the Help option.

Preview the Dashboard

  • Navigate to the Dashboard canvas page.

  • Click the Preview icon.

  • The selected Dashboard opens in the Preview

Adding a New Dashboard

This section covers two ways to add a new Dashboard.

  • Navigate to the Designer homepage.

  • Click the New drop-down menu and select Dashboard.

Or

A panel opens displaying various charting options to choose from.
The panel with various charting options

Refer the Charts Gallery section for the further details on the charting components.​

Accessing the Component Library icon on the Designer canvas page
Drag the required fields.
Associating a Dataset with the dragged chart

Workspace: Clicking this option redirect the users to create a new workspace/place holder for the dashboard.

  • Dashboard: By clicking this option, the users get redirected to the Designer Canvass to create a new dashboard.

  • Options provided under the New menu option

    The selected dashboard gets exported to the local disk.

    The selected dashboard gets exported.
    Accessing the Export to Local Disk option for a dashboard

    The Help content gets displayed to understand the Designer plugin.

    The Help section of the Designer.
    mode.

    Click on the ‘+’ icon, the users get redirected to the Designer Canvas.

    Accessing the Add Dashboard or Dashboard option under the New menu
    Using the Exit option for a Designer
    Accessing the Designer module from the Apps menu
    Homepage of the Designer Module​​
    Dashboard Creation Basic Workflow​​

    Guided Tour

    The user gets guided across various important sections of the Designer plugin. The tour begins from the Designer Homepage.

    • Click the Take a tour option provided on the top right side of the Designer homepage.

    The Take a tour icon
    • A new dialog box opens initiating the landing page tour.

    • Click the Next option to move ahead in the guided tour.

    • Click the Prev option to go back to the guided tour.

    • Click the End Tour option if you want to end the tour at any given point (The End Tour option will get highlighted by default at the end of the guided tour).

    ​

    Connection Page

    The Designer canvas page offers an icon to access the supported connectors page to establish a data connection for the dashboard creation.

    • Navigate to the Dashboard canvas.

    • Click the Data Connectors icon.

    Accessing the Data Connectors icon
    • A page opens displaying various options to establish data connections.

    Refer the pages given under the section for the further details.​

    Homepage

    It is the landing page for the Designer module.

    The Designer homepage displays a list of tasks in the left panel that users can perform on a dashboard.

    The Designer Homepage also contains Guided Tour.

    Manage

    This option helps to manage the created Workspaces or Dashboards inside a user account.

    • Navigate to the Designer homepage.

    • Click the Manage option.

    • The user gets directed to manage the following tasks for a Workspace or Dashboard:

    Tasks for a Workspace

    • Search in Workspaces: Searches for a specific Workspace.

    • Reload Workspaces: Reloads all the Workspaces.

    • New Workspace: Adds a new Workspace.

    ​

    Tasks for a Dashboard

    To access the options, the users need to select a dashboard from an existing workspace as displayed in the following image:

    • Search: Searches for a Dashboard

    • GIT Export: Export a dashboard to GIT and get a pushed version from the GIT repository (Push to VCS and Pull from VCS)

    • Open in Designer: Opens the dashboard in Designer to Edit or modify

    The users get the following options while clicking the More Actions icon provided for a Dashboard.

    1. Preview the dashboard

    2. Export to Local Disk

    3. Rename the Dashboard

    4. Delete Dashboard

    ​

    Manage Window

    Learn about the Dashboard Objects and manage them using this option.

    Every component in the dashboard is considered as an object. The Designer canvas page offers an icon to access the Dashboard Objects and the various related properties to manage the dashboard components.

    • Navigate to the Dashboard canvas.

    • Click the Manage Dashboard Components icon.

    Accessing the Manage Dashboard Components on the Designer Canvas page
    • A panel opens displaying various icons for the used dashboard objects (The following image displays empty dashboard, so no objects are mentioned).

    Refer the pages given under the section for the further details.

    Script Window

    The Designer module offers a scripting mechanism in the Designer plugin to help the users experience the next level of customization in dashboard creation.

    Pre-requisite: The users require basic scripting knowledge to use the Component Variable and Script option for creating interactive governed dashboards using the Designer module.

    The scripting mechanism makes the creation of complex dashboards easy and quick. The users get an icon to access the scripting window on the Designer Canvas page.

    • Navigate to the Dashboard canvas.

    • Click the Component Variable and Script icon.

    • The user gets redirected to the scripting window displaying the Components and Connections tabs to open the related panel for the each option. The Components tab opens by default.

    Refer the description given under the section for the further details.

    Save As

    • Navigate to the Designer homepage.

    • Open the Manage option.

    • Open an existing dashboard from the list of available dashboards (You can find the list of dashboards inside a Workspace).

    Opening a dashboard
    • Click the Save As option from the left panel.

    • The Save As window appears to confirm the action.

    • The original dashboard name appears with the “Copy_Of” prefix (the users can edit the name as per their wish).

    • Select a workspace from the drop-down menu.

    • A copy of the selected dashboard gets saved in the chosen workspace.

    Guided Tour

    It covers the major options provided on the Designer Canvas page through a guided tour pop-up window.

    The user can avail a guided tour to the Designer canvas page using the Guided Tour icon provided on the right side panel.

    • Navigate to the Designer Canvas page.

    • Click the Guided Tour icon.

    Accessing the Guided Tour icon on the Designer Canvas page
    • A dialog box appears next to the major options of the Designer Page. It begins from the .

    • Click the Next option to move forward.

    • It redirects the users on the icon to open the Dashboard Canvas page.

    • Click the Prev option to go to the back page.

    • Click the End tour option to close the guided tour window at any given point.​

    Please Note:

    • The Dashboard canvas page opens for the selected dashboard while navigating to the Dashboard option using the Guided Tour window.

    Open Dashboard

    • Navigate to the Designer homepage.

    • Click the Open option from the given options.

    • The Open from Local Disk appears.

    Accessing the Open from Local Disk
    • The user gets directed to open the downloaded files (.bvzx) from the local disk.

    ​

    • The selected dashboard (.bvzx file) opens inside the designer workspace.

    Please Note: By clicking the Templates option the user gets redirected to the Dashboard Templates page as displayed in the below-given image. Refer the to understand more on this functionality.

    Renaming a Workspace

    • Select a workspace from the Workspaces list.

    • Click the Rename icon.

    • The Rename window appears to assure the action.

    • Provide a new name for the dashboard.

    • Click the Rename to save the new name.

    ​

    • A message appears to assure the success of the renaming action.

    • The selected workspace gets saved with the new name.

    ​

    Open Dashboard in Designer

    Go through the given illustration on opening a dashboard from the Manage options.

    Opening a Dashboard in Designer

    The users can open the desired dashboard into the designer workspace once they have created and saved it to a workspace.

    • Click the Manage option on the Designer homepage.

    • Select and click on a workspace from the list of Workspaces.

    • Select a Dashboard from the list of all the saved dashboards under the selected workspace.

    • Click the Open in Designer icon.

    • The selected dashboard opens in the designer workspace.

    Please Note: The users can also open a dashboard in the designer canvas by using double clicks on the dashboard name from the list of saved dashboards.

    Preview Dashboard

    The Preview action option opens the selected dashboard in the preview mode.

    • Navigate to a saved dashboard using the Manage option.

    • Select a dashboard and click the More Actions icon.

    Accessing the More Actions option for a dashboard
    • Choose the Preview action from the context menu.

    ​

    • The selected dashboard opens in Preview mode.

    Please Note: The user gets the Preview icon on the Designer canvas header as well.​

    What is Dashboard Designer?

    The designer module is a complete package to create governed dashboards with pre-built charting capabilities that make it simple enough for business users to understand their business data, yet robust enough to accommodate complex custom scripting. High-level visualizations backed with accurate predictions and real-time updates are available at seamless speed to provide precise insights to users and help them make informed business decisions.

    The Designer module comes preloaded with a wide range of charts, features, and data integration capabilities that empower the users to create informative and appealing visual representations of their data.

    ​

    Create Connection

    • Click the Data Connectors icon to display all the available data sources.

    • Click the Create New Connection icon provided next to the Data Service connector.

    • A new connection gets added under the Data Service connector type.

      • Name: Name the connection.

      • Data Connectors: Select a data source from the drop-down menu.

      • Data Sets: Select a data service from the drop-down menu.

    Please Note: The connection creation part based on all the available data sources is described under the .

    Accessing the Data Connectors

    This page guides you on how to access the Data Connectors icon and navigate to the Data Connectors page.

    • Click the Data Connectorsicon using the Designer canvas.

    Accessing the Data Connectors icon on the Designer Canvas
    • A new screen opens, displaying the following data connection options:

    • Select a data connection type and click the Create New Connection icon.

    • A new connection appears below.

    • Configure the required details to create a data connection.

    Information Icon

    • Click the Manage option from the Designer Homepage Left Menu Panel.

    • Select a Workspace from the list of available Workspaces.

    • A list of available Dashboards inside the selected Workspace opens.

    • Select a Dashboard from the list.

    • Click the Action menu icon for the dashboard.

    • Click the Info icon from the Action menu.

    • The Dashboard Info window opens displaying the related information such as Last Updated Date and Last Updated By.

    User Alert Notification

    This page provides step-by-step process to understand the User alert notification functionality provided for a shared Dashboard.

    Pre-requisite: To avail this functionality on any dashboard it is required to be shared across multiple users (minimum 2 users).

    Check out the below-given demonstration on the User Alert Notification functionality.

    Drag and Drop Charts

    • Click the Component Library icon from the right edge of the window.

    • Various categories of the available charting components get displayed (The Charts category gets selected by default).

    • Select and drag a component on the canvas.

    Creating a Workspace

    This section explains the steps on how to create a new Workspace in the Designer module.

    • Navigate to the Dashboard Designer homepage.

    • Click New or click the Add option.

    • Click Workspace from the context menu.

    Excel Connection

    Steps to develop a data connection based on the Excel file.

    Check out the given illustration on how to create an Excel connection and associate it to a charting component.

    • Click the Data Connectors icon to display all the available data sources.

    Dashboard Version Control

    Check out the walk-through on how to use the Version Control functionality for the Dashboards.

    Pushing a Dashboard to VCS

    Rename

    Previously created dashboards can be renamed using this option. This part provides steps on how to rename an existing dashboard.

    • Select a dashboard using the Manage option.

    • Click the Rename icon from the More Actions context menu.

    Data Service Connection

    Steps to develop a data connection based on the Data Service.

    Check out the given illustration on how to create a Data Service connection and associate it to a charting component.

    • Click the Data Connectors icon to display all the available data sources.

    Data Store Connection

    Steps to develop a data connection based on the Data Store.

    Check out the given walk-through on how to create a Data store connection and associate it to a charting component.

    • Click the Data Connectors icon to display all the available data sources.

    Moving a Dashboard

    The users can move the created dashboards from one workspace to another using this option. This section explains the steps to move dashboards.

    • Select a dashboard using the Manage option.

    • Click the Move to icon from the More Actions context menu.

    Charts

    Rename: Renames the selected workspace.
  • Remove: Removes the selected workspace from the list and move to the Trash Workspace.

  • Share: Shares the selected workspace to a user or user group. The rights to access an already shared workspace can be excluded by using the same option.

  • Empty the Trash: Removes all the workspaces from the Trash workspace.

  • Publish to Portal: Publishes the Dashboard to the portal
  • Remove: Deletes the Dashboard

  • Actions: Applies the various actions on a dashboard

  • Move the Dashboard from one Workspace to another Workspace

    Options provided for a Dashboard
  • Click the Save option.

  • The Save As Dialog box
    The dashboard gets saved as with the copy of the original one.
    The user can choose the Next option from the Dashboards guided tour window to move ahead on the various options on the Designer Canvas page.
    Homepage
    Guided Tour window focusing on the Designer Homepage
    The Guided Tour window indicating the Dashboards tab.
    User Alert Notification functionality

    The users will get the alert notification when multiple users are working on the same dashboard. The alert message will pop-up while one of them would like to save the updates on the same dashboard.

    The user who gets the Alert Notification has two choices:

    Accept the Alert

    If the user accepts the Alert notification, then his dashboard gets closed and it gets reopened displaying the updates saved by another user.

    Deny the Alert

    If the user denies the Alert notification, then he can continue to work on the same dashboard and his updates will overwrite the updates of the another user.

    Please check out the following scenario to understand how the User Alert Notification functionality works.

    • A dashboard is shared to multiple users.

    • If more than one users are working parallelly on the same dashboard and one of the users i.e., User-A saves the dashboard to save the updates added by him in the dashboard. A notification message appears and all the updates committed by the User-A gets saved.

    • All the other users (i.e., User-B and User-C) who are working still on the same dashboard will receive an alert notification as displayed in the below-given image.

    • They can either accept it by clicking the Yes option or deny it by using the Cancel option.

    • If the User-B accepts the alert, then User-B's dashboard will get closed.

    Please Note: The User-B can reopen it only with the updates provided by the User-A.

    The Dashboard reflects the saved changes by User-A for the User B
    • There is a User-C who has cancelled the alert option. So, User-C can continue the work on the same dashboard.

    Please Note: If User-C saves the dashboard after updating it, that will overwrite the updates given by User-A in the same dashboard.

    The Dashboard as overwritten with the changes committed by User-C
    Accessing the Workspace option to create a new Workspace
    • A dialog box appears.

    • Workspace Name: Enter a title for the Workspace in the given field.

    • Click the Save option.

    Creating a New Workspace
    • A confirmation message appears to inform the creation of a new Workspace.

    • The newly created workspace gets saved under the list of the existing Workspaces (The list of the Workspaces can be seen under the Manage option).

    Click the Create New Connection icon provided next to the Excel option.

  • A new connection gets added under the Excel connection type.

  • The connection-specific details get displayed on the right side of the page.

  • Creating an Excel Data Connection
    • Configure the following information:

    • Name: Name the connection.

    • Browse: Click the Browse icon to browse an Excel file.

    • Sheet Name: Select a specific sheet using the drop-down menu.

    • Load at Start: Enable this option to get the updated data from the data source before loading it into charts.

    • The Field Set tab displays all the fields after establishing the data connection.

    Configuring the connection and getting the data

    Select the Condition tab and provide a condition to be applied as a filter on the selected data by putting checkmarks in the given boxes. E.g., The selected Conditions for the Category field is Catalog.

    The Condition tab

    Please Note: Click on the Script on Load icon provided next to the connection to navigate to the Script tab where the user can trigger a script to produce some action on the connection.

  • Click the Manage option.

  • Select and open a Workspace from the list of Workspaces.

  • Select a dashboard from the dashboard list.

  • Click the Push to VCS icon for the selected dashboard.

  • Accessing the Push to VCS icon for a dashboard

    • The Push into Version Controlling System dialog box opens.

    • Provide a commit message.

    • Select a Push Type out of Dashboard Versioning and GIT Export

    • Click the Push option.

    Providing the Commit message and Push Type for a dashboard push
    • A Confirmation message appears and the selected dashboard version gets pushed to VCS.

    ​​

    Pull from the VCS

    • Click the Manage option.

    • Select and open a Workspace from the list of Workspaces.

    • Select a dashboard from the dashboard list.

    • Click the Pull from VCS icon for the selected dashboard.

    Accessing the Pull from VCS icon for a dashboard
    • The Pull from Version Controlling System dialog box opens.

    • Select a Version by using the given checkbox.

    • Click the Pull option.

    Selecting a Version to pull from the VCS
    • A confirmation message appears and the selected version of the dashboard gets pulled.

    ​​

    Push to and Pull from VCS

    The Rename window appears.

  • Enter a new name for the selected dashboard.

  • Click the Rename option to save the new name.

  • ​

    • A success message appears.

    • The selected dashboard gets renamed.

    Accessing the Rename icon for a dashboard

    Click the Create New Connection icon provided next to the Data Service connector.

  • A new connection gets added under the Data Service connector type.

  • Creating a new connection using the Data Service source
    • The configurable connection-specific fields display on the right side of the page as explained below:

      • Name: Name the connection.

      • Data Connectors: Select a data source from the drop-down menu.

      • Data Services: Select a data service from the drop-down menu.

      • Load at Start: Enable this option to get up-to-date data / pull the updated data from the data source before loading it into charts.

      • Timely Refresh: Enable this option to get the refreshed data.

      • Refresh Interval: Set the time for refresh interval. (This field appears when the Timely Refresh the field has been enabled.)

      • The Field Set tab displays all the fields after establishing the data connection.

    Please Note:

    • Click the Reload Data Sources icon to reload the existing data connectors.

    • Click the Refresh Service icon to refresh all the available data services.

    • The users can filter the targeted data set using the Condition option.

    Click the Create New Connection icon provided next to the Data Store connector.

  • A new connection gets created under the Data Store connector type.

    • The configurable connection-specific fields display on the right side of the page as explained below:

      • Name: Provide a name for the connection.

      • Data Store: Select a datastore from the drop-down menu.

      • Load at Start: Enable this option to get up-to-date data / pull the updated data from the data source before loading it into charts.

      • Timely Refresh: Enable this option to get the refreshed data.

      • Refresh Interval: Set the time for refresh interval. (This field will appear only when the Timely Refreshed field has been enabled.)

    • The Field Set tab displays all the fields after establishing the data connection.

    Please Note:

    • Click the Refresh Data Stores icon to refresh the selected Data Store data connection.

    • The users can filter the targeted data set using the Condition tab.

    ​

    The Move to Another Workspace window appears.

  • Select a Workspace from the drop-down menu.

  • Click the Move option to move the selected dashboard into the desired workspace.

  • ​

    • A success message appears.

    Notification message after the Dashboard gets moved
    • The dashboard gets moved to the selected Workspace.

    The dashboard gets moved to the selected Workspace.
    Accessing the Move to option for a dashboard
    Dashboard Connections
    Data Connectors page
    Dashboard Objects
    The Objects window
    Script Window
    Accessing the Component Variables and Script icon in the Designer Canvas page
    Component Connections page
    Dashboard as Template
    The Dashboard opens in the Designer canvas.
    Establishing a Data Connection
    Creating a data connection
    CSV
    Excel
    Data Service
    Data Store
    Data Sheet
    WebSocket
    Merged Data
    The Data Connectors page for the Designer module
    The left panel on the Designer Homepage
    Accessing the Open in Designer option for a Dashboard
    The dashboard opens in Designer canvas page
    Accessing the Information Icon

    Preferences

    Preferences

    • Navigate to the Designer homepage.

    • Click the Preferences option from the left panel.

    ​

    • The Preferences for a dashboard canvass appear.

    • Set the desired preferences either by enabling it through a checkmark or selecting it from the provided menus.

    • Click the Save option.

    • The selected preferences get applied to the dashboard canvass.

    • The available preferences for a dashboard are as described below:

    Dashboard Canvas Page

    Dashboard Designer space can be understood as a folder that contains Data Source connections, Components, Dashboard Objects, and Component Attributes.

    Dashboard Canvas Page

    • Navigate to the Designer homepage.

    • Click the Add Dashboard icon on the homepage.

    or

    • Click the New drop-down icon on the homepage.

    • Select the Dashboard option.

    • The Designer space/Canvas opens with a Designer Canvas space, header menu panel, and a right-side menu panel.

    The user can access wide range of charting components, filters, and Grid components available in the Designer module from the Designer canvas page to create a dashboard.

    Refer to the following image to understand the various components provided on the Designer Canvas:

    1. Tab: Place where dashboard design takes place. Drag and drop charts and components here to create dashboards.

    2. Mobile : Displays Dashboard screen like a Mobile device.

    3. Tablet : Displays Dashboard screen like Tablet.

    Please Note:

    • The users will be redirected to the Designer homepage by clicking the Home option.

    • Use the Save As

    Context Menu Properties

    This section describes properties applied to multiple components when dragged into the designer canvas and selected.

    This page describes the steps to access the Context Menu Properties:

    • Drag multiple components into the designer canvas (At least three components to avail all the properties).

    Dragging multiple components to the Canvas
    • Select multiple components from the canvas(at least three).

    • Use right-click to open the context menu.

      • The following properties will be listed in the context menu:

        • Align Left: All the selected components get aligned to the left.

    Deleting a Workspace

    This section describes steps to delete an existing Workspace and restoring the deleted workspace.

    Removing a Workspace

    • Select a workspace from the Workspaces list.

    • Click the Remove icon.​

    • The Remove dialog window appears to confirm the deletion.

    • Click the Remove option.

    ​

    • The selected workspace gets removed from the list.

    • The removed workspace gets added to the Trash Workspace.

    Restoring a Deleted Workspace

    • Click the Manage option.

    • Navigate to the Trash workspace created under the list of all the workspaces.

    • Select a deleted workspace that you want to restore and click the Restore icon.

    Please Note:

    • Removing a workspace causes the default removal of all the dashboards saved under it into the Trash workspace.

    • Click the

    Dashboard as Template

    This page provides steps to save a dashboard template using the Designer module.

    The Save as Template option has been provided under the More Actions menu for each saved dashboard. By clicking this option it will create the selected dashboard as a Card in the Templates section.

    Check out the given illustration on how to create and use the Dashboard Templates inside the Designer module.

    Dashboard Templates

    • Navigate to the saved Dashboards list using the Manage option.

    • Select a Dashboard from the list.

    • Click the More Actions icon for the selected dashboard.

    • Click the Save as Template option from the More Actions context menu.

    • The Save as Template dialog box opens.

    • Provide the Template Name in the given space.

    • Click the Save option.

    • A notification message appears to inform the completion of the action.

    • Click the Templates option provided under the Open option from the Designer homepage.

    • The Dashboard Templates page opens listing all the available dashboard templates.

    • The recently saved dashboard template gets listed under the Dashboard Templates page.

    Please Note: The saved Dashboard template gets two icons to perform actions.

    1. Open as dashboard

    2. Preview Template

    Open as Dashboard

    When the users click on the Open as Dashboard icon, they will get all dragged charting components in the Designer canvas view without the inserted scripts and mapped data connection for that dashboard.

    Preview Template

    When the users select the Preview Template icon, they will get the preview mode of the selected dashboard. It allows the inserted functionality together with the mapped dataset for the preview.

    Save the Dashboard

    The Designer module contains three types of Save options for a Dashboard. They are as explained below:

    Saving a Dashboard

    • Click the Save icon from the Designer canvas header menu.

    • A pop-up window appears with the following details:

    • Dashboard Name: The name of the selected dashboard gets displayed.

    • Workspace: Select a workspace via the drop-down menu.

    • Click the Save option.

    • A success message appears to assure the same.

    ​

    • The dashboard gets saved to the selected workspace.

    Save As: Save to Another Workspace

    • Click the Save to Another Workspace icon from the Designer canvas header menu.

    • The Save As pop-up window appears asking to save a copy of the selected dashboard.

    • Name: The dashboard name gets displayed as Copy_of_ the original Dashboard Name.

    • Two consecutive notification messages appear.

    ​

    • A copy of the selected dashboard gets saved in another workspace.

    Save to Local Disk

    A dashboard can be saved to a local disk via the Save to Local Disk option.

    • Click the Save to Local Disk icon from the Designer canvas header menu.

    • The selected dashboard gets saved to the local system.

    ​

    Delete

    This page explains the steps to Delete a dashboard and restore a deleted dashboard.

    Deleting a Dashboard

    Users can delete a dashboard by following the steps explained over here.

    • Select a dashboard using the Manage option.

    • Click the Delete icon from the More Actions context menu.

    • A pop-up window appears to confirm the deletion.

    • Select the Remove option from the pop-up window.

    ​

    • A message appears to notify the completion of the action and the selected dashboard gets removed from the list.

    ​

    Restoring a Deleted Dashboard

    By default, the dashboard gets moved to the Trash Workspace. The users can open the Trash Workspace and restore the dashboard to the desired workspace.

    • Click the Manage option from the Designer homepage.

    • Navigate to the Trash workspace created under the list of all the workspaces.

    • Select a deleted dashboard that you want to restore Click the Restore icon.

    • The Restore window appears.

    • Select a workspace using the drop-down menu.

    • Click the Restore option.

    ​

    • A success message appears to assure the restoration.

    ​

    • The dashboard gets restored to the selected workspace.

    Dragging a chart to the canvas

    Global Properties

    Align appearance of various dashboard components from one place by using the Global level properties for a dashboard.

    The Global Properties feature in the Dashboard canvas empowers users to apply appearance properties at the dashboard level. These properties facilitate the seamless alignment of various dashboard components, ensuring a consistent and visually harmonious display.

    Accessing the Global Properties Icon

    • Navigate to a Dashboard within its canvas framework.

    Sharing a Workspace

    Sharing a Workspace

    Check out the illustration on sharing a workspace.

    Data Sheet Connection

    Steps to develop a data connection based on the Data Sheet.

    Check out the given walk-through on how to create a Data Sheet connection under the Designer module and associate it to a charting component.

    • Click the Data Connectors icon to display all the available data sources.

    WebSocket Connection

    Steps to develop a data connection based on the WebSocket.

    Check out the given walk-through on how to establish a WebSocket Connection using the Designer module.

    • Click the Data Connectors icon.

    Filters

    Grids

    Charts Gallery

    Overview of the Designer Module

    Redirects to select a color to display when any component when dragged to the canvass

    Selection Thickness

    Set (increase/decrease) the thickness of the component border

    Show Border

    Enable this option to display a border on the dashboard

    Border Color

    Redirects to select a border color to display in the Dashboard

    Background Color

    Redirects to select a color to display in the dashboard background

    Hide Shadow

    Enable this option to hide the shadow of the components

    Sync Component Property

    Enable this option to synchronize the component property

    Enable Multiple Drag

    Enable this option to select multiple charts and then move them together in the dashboard

    Fixed Dimension

    Enable this option to set the fixed height & width of the dashboard

    Property Name

    Description

    Show Grid Lines

    Enable this option to display grid lines in the designer area

    Snap to Grid Size

    Select an option to display the grid size (None/5/10/15)

    Notify on Success

    Enable this option to get a notification of success

    Block Notification

    Enable this option to block the notification message

    Show Settings Button

    Enable this option to display the toolbar when any component is selected

    Selection Color

    Large Screen
    : Displays Dashboard screen like Desktop.
  • Save to Local Disk : Saves the created dashboards to your local disk.

  • Save to Another Workspace (Save As) : Saves a copy of the original dashboard to another workspace or the same workspace.

  • Save (Dashboard) : Saves the created dashboards in a workspace.

  • Preview : Displays the preview mode of the dashboard.

  • Full Screen : Maximizes the dashboard for a better view.

  • Data Connectors : Connects to a wide range of data sources.

  • Component Library : Includes a compelling range of charts, filters, and data grids.

  • Manage Dashboard Components : Option used to lock, hide, and order the layout of the components on the dashboard.

  • Component Variables and Script : Option used to define component scripts.

  • Guided Tour : Begins the guided tour for the Designer canvas.

  • option to save a dashboard in the same workspace with a different name. The user can save the dashboard in a different workspace.
    Clicking the Add Dashboard icon from the Designer homepage
    Selecting the Dashboard option from the New menu
    The Designer Canvas Page
    Various options provided on the Designer canvas page

    Align Right: All the selected components get aligned to the right.

  • Align Top: All the selected components get aligned to the top.

  • Align Bottom: All the selected components get aligned to the bottom.

  • Align Horizontal: All the selected components get aligned horizontally.

  • Align Vertical: All the selected components get aligned vertically.

  • Equal Space (Horizontal): All the selected components get equal space horizontally.

  • Equal Space (Vertical): All the selected components get equal space vertically.

  • Equal Height: All the selected components get an equal height.

  • Equal Width: All the selected components get an equal width.

  • Manage Group: The user gets redirected to manage the group.

  • Lock Selected: All the selected components get locked.

  • Unlock Selected: All the selected components get unlocked.

  • Delete Selected: To delete the selected components.

  • Duplicate Selected : To duplicate the selected components.

  • ​

  • Each dragged component gets some Context Menu Properties as shown in the below image:

  • Selecting the dragged component
    Context Menu Properties for a single dragged component
    Reload Workspaces
    icon provided next to the Workspaces list to load all the workspaces again.
  • Click the Restore icon from the Trash workspace to restore deleted workspaces.

  • Click the Remove Permanently icon from the Trash workspace to delete a workspace or dashboard permanently.

  • Confirmation message after a Workspace gets deleted
    Restoring the Deleted Workspace

    Workspace: Select a workspace from the workspace drop-down menu.

  • Click the Save option.

  • Saving a Dashboard
    The dashboard gets saved in the selected Workspace
  • Use right-click to get the Dashboard context menu.

  • Click the Properties option from the context menu.

    • The Dashboard Properties gets listed in a context menu.

    • Select the Global Font and Themes option.

    • The Global Properties icon can be accessed within it.

    • By clicking on the Global Properties icon, the Global Properties Selection window opens displaying a list of the Global Properties that can be set or modified at the dashboard level.

    The Global Property Selection window

    Various Global Properties

    The Global Properties feature streamlines the design process and saves time by providing a single point to manage appearance settings for the entire dashboard.

    A dashboard is provided with the below-given Global Properties:

    Enable Global Property for Background

    Apply a border for all the dashboard components and set color and radius of the border for all components enabling the Global Property for Background.

    Enable Global Property for Title

    The Global Properties for the dashboard title ensure consistent branding and visual coherence throughout the entire dashboard. It helps the user to effectively convey the purpose behind the selected dashboard by aligning the Title display together with Title Bar height, Font color, Font Size, Font Style, font Weight, and Font family. It also allows to enable decoration for the inserted Title text.

    Enable Global Property for Sub Title

    The Global Sub-title Properties feature in the Dashboard application enables users to apply appearance properties at the dashboard level for sub-titles. By utilizing Global Sub-title Properties, users can ensure consistency and visual harmony across all sub-titles in the dashboard.

    Enable Global Property for X Axis

    By utilizing Global Properties for the X-axis, users can ensure consistency and visual coherence across all charts and graphs in the dashboard that use the X-axis. It helps to bring in uniformity for all the dashboard components containing X-Axis in terms of Label appearance and readability.

    Enable Global Property for Y Axis

    Ensure consistency and visual coherence across all the charts in the dashboard by utilizing Global Properties for the Y-axis. It helps to standardize all the dashboard components containing Y-Axis in terms of Label appearance, readability, and text decoration.

    Enable Global Property for Legend

    The Global Properties for Legend allows the user to customize the appearance properties of the legend to align with your design preferences.

    Enable Global Property for Formatter

    The Global Properties for Formatter allows the user to standardize various formatter related properties .

    The user must click the Save option after setting or modifying the desired set of Global Properties to apply them on the selected dashboard.

    Please Note:

    • While Global Properties offer convenience, users can still override specific properties for individual components if required.

    • It is recommended to define Global Properties at the beginning of the dashboard design process to establish a consistent visual identity from the outset.

    Open the Manage option.

  • Navigate to the Workspaces section.

  • Select a Workspace from the list.

  • Click the Share Workspace icon.

    • The Manage Access window opens.

    • Select permissions using the Grant Permissions.

    • The Users, User Groups, and Exclude Users tabs will be displayed. Choose users or user groups tabs to share the workspace.

    • Search specific users or user groups using the Search bar.

    • Select a user or user group using checkboxes.

    • Click the Share option.

    • A notification message appears.

    • Re-open the Manage Access window.

    • The selected user/ user group gets listed under the Granted Permissions section.

    Revoking Privileges for a Shared Workspace

    Check out the illustration on revoking privileges for a shared workspace.

    • Open the Manage Access window for a shared Workspace.

    • Navigate to the Granted Permissions section.

    • Select a user/ user group from the Granted Permissions section.

    • Click the Revoke icon.

    • The Revoke dialog box opens.

    • Click the Yes option to revoke the permission.

    • A notification message appears and the privileges get revoked.

    Excluding Users from Accessing a Workspace

    Check out the illustration on excluding users from a user group to access the privileges for a shared workspace.

    • Open the Manage Access window for a Workspace.

    • Select permissions using the given checkboxes for the Grant Permissions.

    • The Users, User Groups, and Exclude Users tabs display. Select the User Groups tab to share a workspace.

    • Search a specific user/ user group using the Search bar.

    • Select a user group by using a checkbox.

    • Navigate to the Exclude Users tab.

    • Select users using the checkboxes.

    • Click the Share option.

    • A notification message appears.

    • Re-open the Manage Access window.

    • The excluded user(s) will be listed under the Excluded Users section.

    Please Note: An excluded user can be included to access the privileges for a shared Workspace by using the Include User icon.

    Click the Create New Connection icon provided next to the Data Sheet connector.

  • A new connection gets created under the Data Sheet connector type.

    • The configurable connection-specific fields display on the right side of the page as explained below:

      • Name: Provide a name for the connection.

      • Data Sheet: Select a Data Sheet from the drop-down menu.

      • Load at Start: Enable this option to get up-to-date data / pull the updated data from the data source before loading it into charts.

      • Timely Refresh: Enable this option to get the refreshed data.

      • Refresh Interval: Set the time for refresh interval. (This field will appear only when the Timely Refreshed field has been enabled.)

    • The Field Set tab displays all the fields after establishing the data connection.

    Click the Create New Connection icon provided next to the WebSocket connector.

  • A new connection gets created under the Web Socket connector type.

  • The configurable connection-specific fields display on the right side of the page as explained below:

    • Name: Provide a name for the connection

    • URL: Enter a URL link

    • guid: Provide the guid.

    • Ingestion ID: Provide the ingestion id.

    • Ingestion Secret: Provide the ingestion secret key.

    • Load at Start: Enable this option to get up-to-date data / pull the updated data from the data source before loading it into charts.

  • The WebSocket connection gets established.

  • Accessing the Delete Icon from the More Actions context menu
    Accessing the Restore option for a dashboard
    The dashboard gets restored in the selected Workspace

    Publish a Dashboard

    ​The below-given illustration will help you to understand how to publish a Dashboard.

    Dashboards need to be published for end-users to access them. This section explains the steps to publish dashboards.

    Publishing to Portal

    • Click the Manage option on the Designer homepage.

    • Select and click on a workspace from the list of Workspaces.

    • Select a Dashboard from the list of the saved dashboards under the selected workspace.

    • Click the Publish to Portal icon.

    • The Publish dialog box appears to assure the action with the dashboard name and description.

    • Select Folder Location using the drop-down icon.

      • The supported folders are My Documents and Public Documents.

    • Two consecutive notification messages appear to assure the completion of the action.​

    • The selected dashboard gets published at the desired place.

    Republish

    • For the published dashboard, the below-given dialog box appears while clicking the Publish to Portal icon.

    • Select an action option out of Re-Publish or Publish as New.

      • The Republish option if selected displays the following details:

    Publish as New

    • The Publish as New action allows the user to publish the selected dashboard as new.

    • Select Use(s) or User Group(s) using either USER LIST or USER GROUPS tab.

    • Select the desired user(s) or user group(s) using check marks in the given check boxes.

    ​

    Please Note:

    • Click the Publish option to complete the action of republishing a dashboard or Publishing a Dashboard as New.

    • Click the

    Dashboard Themes

    Access the pre-defined dashboard themes to instantly change the visual display of your dashboard.

    The Designer module provides visually captivating and appealing themes under the Dashboard Properties, so that the users can effortlessly and instantly transform their dashboard’s appearance. The user can seamlessly switch between different themes with an intuitive drop-down menu.

    Steps to Apply Various Themes on a Dashboard

    • Navigate to a Dashboard within its canvas framework.

    • Use right-click to get the Dashboard context menu.

    • Click the Properties option from the context menu.

    • The Dashboard Properties gets listed in a context menu.

    • Select the Global Font and Themes option.

    • Click the Designer Themes icon.

    • The Dashboard Theme Selection window opens.

    • Click the Theme List drop-down option to access the list of all the available dashboard themes.

    • Select a theme from the drop-down list.

    • The selected theme appears in the Theme List field.

    • Click the Save option.

    • The selected theme gets applied to the dashboard.

    Available Pre-defined Themes

    The supported themes are as given-below (Click on each tab to open the embedded theme display).

    Share a Dashboard

    Sharing a Dashboard

    Check out the walk-through on how to share a Dashboard.

    • Open the Manage option.

    • Open a Workspace from the list of workspaces.

    • Select a dashboard from the list of dashboards.

    • Click the Share Dashboard icon for the selected dashboard.

    • The Manage Access window opens for the selected dashboard.

    • Select permissions using the checkboxes provided for the Grant Permissions.

    • Use the User List or User Groups option to select user(s)/user group(s) to share the dashboard.

    • Search for the user or user group using the search bar.

    • Use the checkboxes to select the user(s) or user group(s) you want to share the dashboard. ​

    • Click the Share option.

    • A success message ensures that the dashboard is shared successfully. ​

    • Open the Share Dashboard window again for the same dashboard, the user to whom it has been shared will be listed under the Granted Permissions section.

    • Navigate to the target user's account, and access the Designer module. Open the Manage section. The shared dashboard gets notified by the letter 's' next to the dashboard name. Even the workspace will be notified with 's' next to it indicating that it is a shared workspace.

    Excluding Users

    Check out the illustration on excluding the users while sharing a dashboard with a user group.

    • Navigate to the Share Dashboard window.

    • Choose permissions from the Grant Permissions section.

    • Go to the User Groups tab.

    • Search for a specific user group using the search bar.

    • Open the Exclude User tab.

    • Select users whom you wish to exclude by using the checkboxes.

    • Click the Share option.

    Please Note: The excluded users can be included to have the privileges of the shared dashboard by using the Include user option.

    Revoking the Privilege(s)

    Check out the illustration on revoking the shared dashboard privileges for a user/ user group.

    • Navigate to the Manage Access window for a shared dashboard.

    • The user(s)/ user group(s) to whom the dashboard has been shared appears under the Granted Permissions section.

    • Select a user or user group from the Granted Permissions section.

    • Click the Revoke icon.

    • A notification message appears.

    • The selected user or user group's privileges would be revoked for that dashboard. The selected user or group will be removed from the Granted Permissions section.

    Please Note: The shared dashboards can be opened only in the Designer module by the users with whom they are shared. The users do not get any further managing options credited to a shared dashboard.

    Data Sheet Enhancements

    This page lists all the enhancements that are released for the Data Sheet.

    Please check out the given walk-through to understand the enhancements for Data Sheet.

    Data Sheet Enhancements

    The following enhancements are provided for Data Sheet as a Data source connection:

    Add Row

    Provided the Add Row (+) option to add a new row in the Data Sheet.

    Ability to Freeze Columns

    The Freeze Column option can be enabled from the Properties tab provided for the Dataset.​​

    Edit the Frozen Column

    • Navigate to the Dataset Properties and select a column.

    • Enable the Frozen Column option from the Properties tab of the Dataset.

    ​​

    • The selected column gets frozen and becomes non-editable in the Preview mode.

    • Add a new row using the Add new Row option, the cell added under the frozen column is editable.

    Pagination Property

    Provided pagination within the General Properties option. By enabling the Pagination option from the General properties, the page number gets displayed on the Data Sheet component.

    Delete Row

    Introduced the Delete Selected Row option with a confirmation message before a row gets deleted in the Preview mode.

    Save Option Update

    The Save option gets updated in red color when something is edited in the datasheet.​​

    Please Note: Other than the above listed enhancements the below given enhancements are also provided to the Data Sheet data source.

    • Updated the JExcel DataGrid and JSuites library with the latest stable version (4.6.1).

    • Able to retrieve more records of data.

    Merged Connection

    Steps to develop a data connection based on the Merged data.

    Check out the given walk-through on how to create a data connection based on the multiple merged connections and associate it to a charting component.

    The user needs to specify a user or user group using the following options:

    • User List: To select a user or multiple users by using a checkmark in the box.

    • User Groups: To select a user group or multiple user groups by using a checkmark in the box.

    • Exclude User: To exclude a user or multiple users by using a checkmark in the box.

  • Click the Publish option.

  • The available version(s) of the published dashboard. The user can select a version to republish.

  • The selected user(s) or user group(s) gets appeared in the dialog box.

  • ​

    ​

    Publish
    option even to Exclude a user from the rights to access a dashboard.

    • Each published Dashboard gets a set of options to be performed on it. Refer to Options for a Published Dashboard section provided under the Document Options to get more details on it.

    • The selected user receives an email from the BDB Support Team after the selected Dashboard gets ​published to the user.

    ​

    Accessing the Publish to Portal option for a dashboard
    Charcoal Grey Theme
    Accessing Dashboard Properties option
    Accessing the Designer Themes
    Accessing the Dashboard Theme Selection window
    Dashboard in Material Theme
    Default Theme
    Dark Theme
    Material Theme
    Emerald Forest Theme
    Burnished Bronze Theme
    Sky Oasis Theme

    Select a user group using the checkbox. The user is allowed to select multiple user groups.

    A notification message ensures the dashboard is shared with the user group.
  • Open the Manage Access window again for the same dashboard.

  • The excluded users will be listed under the Excluded Users section.

  • The Revoke window appears to confirm the action.

  • Click the Yes option.

  • Accessing the Share Dashbord option
    Accessing a shared dashboard from the target user account
    Merging Data Fields
    • Click the Data Connectors icon.

    • Create new connections using any data connector option (In this case, Excel connections are created. E.g., Connection-1, Connection-2).

    • Create a connection under the Merged Data connector. (E.g., Connection-3).

    • Configure the new connection created for Merged data by mapping the created Excel connections.

    • Define a condition via the drop-down menu in the Criteria space. (E.g. Equal or Not Equal)

    • Click the Create Criteria icon.

    • The Merged Fields displays all the data fields from the merged connections.

    • After clicking the Create Criteria icon, the created criteria get added to space.

    • Trigger a script to produce some action on the connection part using the Script on Load icon.

    Removing fields from the Merged Data Connection

    The users can remove the fields added to the merged data connection using the Remove icon.​​

    Creating a Calculated Field

    Select the Calculated Fields tab to access Calculated Field Editor and add the calculated fields.

    • Click the Calculated Fields tab.

    • Click the Add icon.

    ​

    • The Calculated Field Editor window opens.

    • Provide a title for the calculated field.

    • Insert calculation formula inside the Script Editor space.

    • Click the Create option.

    • The newly created Calculated field gets added under the Calculated Fields tab.

    ​

    Managing Options for a Dashboard

    The page focuses on the various options provided for a saved dashboard while using the Manage option.

    Manage and share your work with others. This section explains how to edit, save, and publish the dashboards created by users.

    Generally created dashboards are saved under a workspace. Based on the requirement, the users can edit the dashboards by adding some modifications and saving them to the disk. This tutorial explains how to edit, open, and save dashboards.

    The created and saved dashboards can be shared among the users for a purpose. There are options provided to move and publish dashboards.

    The below given description helps you how to access those options in the Designer:

    • Navigate to the Designer homepage.

    • Click the Manage option.

    • A list of Workspaces gets displayed.

    • Choose a workspace.

    • A list of all the saved dashboards under the selected workspace gets displayed.

    • Options provided next to a dashboard name can be used to manage or move that dashboard.

    Options provided to a Dashboard:

    Options provided under the More Actions:​

    CSV Connection

    Steps to develop a data connection based on the CSV file.

    Check out the given walk-through on how to create the CSV data connection and associated it with a charting component.

    To open a created dashboard in the designer canvas.

    ​​

    Publish to Portal

    To publish a created dashboard onto the portal.

    ​​

    More Actions

    To provide more actions to be applied to the selected dashboard.

    Removes the dashboard

    ​​

    Move To

    Moves the dashboard

    Option

    Name

    Description

    ​

    Push To VCS

    To push the dashboard to the git version control

    ​

    Pull from VCS

    To Pull the version dashboard from VCS

    ​

    Share Dashboard

    To share the dashboard file with the other user

    ​​

    Option

    Name

    Description

    ​​

    Preview

    Opens preview for the selected dashboard

    ​​

    Export to Local Disk

    Exports the dashboard to a local disk

    ​​

    Rename

    Renames the dashboard

    ​​

    Options to Manage a Dashboard

    Open in Designer

    Delete

    Please Note: Click the Data Connector icon provided on the right side of the canvas, and view the database connectivity options.

    Creating a New CSV Connection

    • Click the Data Connectors icon to display all the available data connector types.

    • Click the Create New Connection icon provided next to the CSV option.

    • A new connection gets added under the CSV connection type.

    • Click the connection to display the connection-specific details.

    Creating a New Connection
    • Configure the following information:

      • Name: Name the connection.

      • Browse: Click the Browse icon to browse a CSV file.

      • Load at Start: Enable this option to get the updated data from the data source before loading it into charts.

    • The Field Set tab displays all the fields after establishing the data connection.

    Configuring a Data connection

    Condition

    • Select the Condition tab.

    • Provide a condition to be applied as a filter on the selected data by putting a checkmark in the given box.

      • E.g., As displayed in the following image, specific date has been provided under the Conditions column for the Timeline so, data for the given date will be taken.

    Calculated Fields

    The users can add a calculated field by using this tab.

    • Navigate to the Data Connectors page.

    • Create a connection by selecting a specific Data Connector type.

    • Connect to the desired data source to access the available fields.

    • Click the Calculated Fields tab.

    • The Calculated Field Editor dialog box opens.

      • Name: Provide a name for the calculated field

      • Script Editor: Use the Script Editor space to insert the desired calculation formula using the rule given below.

    • Click the Create option to create the calculated field.

    ​

    Please Note:

    • Enclose field names in square brackets: [total_sales]/[number_of_items]

    • Enclose global variable in curly braces: {bar1.profit}*2+[profit_jan]

    • The newly created calculated field gets added under the Calculated Fields tab.

    Script on Load for a Data Connection

    The users can apply their modifications or preferences at the connection level using the Scripting window to get the modified data.

    • Navigate to the Data Connectors page.

    • Select a Data Connector type.

    • Create a new Connection and configure it.

    • Select the Script on Load icon provided next to the connection.

    Accessing the Script on Load icon under the Data Connectors page
    • The Script tab appears to trigger a script to produce some action on the data connection.

    The Script tab for connection
    • The user can also use a script for the Dashboard, which can be accessed via the Components tab.

    The Script window for the Dashboard components
    • The user can search the script for the Dashboard, which can be accessed via the Script tab.

    The Script window for the Dashboard

    Opening the Scripting Help/ Advanced Scripting

    • Click the Help icon from the Script on the Load page.

    Accessing the Help icon
    • The Scripting Help tab opens with some predefined scripts.

    Scripting Help tab with pre-defined scripts
    • Click the Advanced Scripting option to display the chart-wise advanced scripts.

    The Advanced Scripting tab displaying the chart-wise advanced scripts

    List

    Check out the walk-through on how to use the List filter component in the Designer module.

    List is a component used to filter data. All available items are displayed as a list. Users can select multiple items simultaneously by holding the CTRL-key. Select items will determine the data that is displayed in any associated chart(s).

    Default Component Image

    Properties of the List Filter

    Background

    • Background Color: Select the desired color for the component's background. This allows you to customize the visual look to match your design preferences.

    • Opacity: Adjust the transparency of the background color. A lower value makes the background more transparent, while a higher value makes it more opaque.

    • Shadow: Enable or disable the shadow effect on the component. This adds depth and contrast to the component's appearance.

    General

    • Component Name: Assign a unique identifier to the component for easy reference within your design or code.

    • Show Search: Enable this to allow users to search within the list, enhancing usability for long lists.

    • Left, Top: Specify the position of the component on the screen by setting the Left and Top values.

    • Height, Width: Define the size dimensions of the component. Adjust these to fit your layout requirements.

    Title

    • Title Box Color: Defines the background color of the title box.

    • Show Title Box: Toggles the visibility of the title box.

    • Show Title: Toggles the visibility of the title text.

    • Title Bar Height: Adjusts the height of the title bar.

    Style

    The Style properties panel provides various fields to customize the appearance of the component:

    • Font Color: Sets the color of the text for clarity and aesthetic cohesion.

    • Font Size: Determines the size of the text, enabling readability adjustments.

    • Font Style: Offers style options such as italic or normal for text appearance.

    • Font Weight: Controls the thickness of the text, ranging from light to bold.

    Modified List filter after changing its Properties

    Hierarchical Combobox

    Hierarchical Combo Box is similar to Check Box and Combo Box but here the list will be arranged hierarchically and users will be allowed to select multiple items simultaneously.

    The Best Situation to Use Hierarchical Combobox

    When users should be given the option to select 1 or more cities that will be used in the table/chart (instead of displaying data for all cities)

    Default Component Image

    Properties of the Hierarchical Combo Box Filter

    Background

    General

    The General Properties help tailor the component behavior and appearance to suit specific requirements, improving user interaction and data visibility control.

    • Component Name: Specifies the identifier for the component, allowing for easy reference.

    • Left, Top: Sets the position of the component on the chart by adjusting its coordinates.

    • Height, Width: Determines the size of the component, enabling customization of its dimensions.

    • Initial Visibility: Controls whether the component is visible at the initial load of the chart.

    Background

    The Background Properties panel offers options to enhance the visual layout of the component through the following fields:

    • Shadow: Enables a shadow effect for the component, creating a sense of depth and focus.

    • Shadow Color: Sets the color of the shadow, allowing for customization to match the overall design theme.

    • Shadow Transparency: Adjusts the transparency of the shadow, providing control over how prominent or subtle the shadow appears.

    Style

    The Style properties panel provides various fields to customize the appearance of the component:

    • Rollover Color: Defines the color that appears when hovering over a cell, enhancing interactive feedback.

    • Selection Color: Sets the color for highlighting selected cells, making them visually distinct.

    • Background Color: Allows setting a specific color for the component's background.

    • Panel Background Color: Customizes the background color of the panel area for a cohesive look.

    Hierarchical Combo box filter variant after changing its properties

    Radio Button

    Check out the below given walk-through on how to use the Radio Button filter component in Designer module.

    The Radio Button component helps to filter data on other components.

    Default Component Image

    Properties of the Radio Button

    General

    General

    • Component Name: Allows users to set a unique identifier for the radio button component.

    • Left/Top: Specifies the position of the radio button within the interface, in terms of left and top margins.

    • Height/Width: Defines the dimensions of the radio button.

    • Initial Visibility: Toggles the initial display state of the component; if not enabled, it won't appear on the first preview.

    Background

    • Shadow: Enable or disable the shadow effect on the component. This adds depth and contrast to the component's appearance.

    • Shadow Color: Choose the color for the shadow effect. This can be matched with your design aesthetics or contrast requirements.

    • Shadow Transparency: Control the transparency level of the shadow. Adjust this to blend the shadow with the background seamlessly or make it more pronounced.

    Modified Radio Button after changing its properties

    Sharing a Workspace
    Excluding users from accessing a shared workspace
    Publishing a Dashboard
    Revoking Privileges for a Workspace
    Sharing a Dashboard
    Revoking Permissions for a Dashboard
    Excluding users from the previleges to get a shared dashboard
    Shadow Color
    : Choose the color for the shadow effect. This can be matched with your design aesthetics or contrast requirements.
  • Shadow Transparency: Control the transparency level of the shadow. Adjust this to blend the shadow with the background seamlessly or make it more pronounced.

  • Initial Visibility: Determine if the component should be visible initially. If disabled, the component will not appear until explicitly shown.

  • List Swap: Allow users to move items between lists, facilitating better management of selected values.

  • Multiple Selection: Enable this to allow users to select more than one item from the list at a time.

  • Row Height: Set the height of individual rows within the list, affecting overall list readability.

  • Action Bar Height: Define the height of the action bar, which may contain buttons for additional functionality.

  • Action Icons Color: Customize the color of icons within the action bar to match your design theme.

  • Selected Index: Specify an index to highlight a particular item by default when the list is initially presented.

  • Auto Update GV: Automatically update global variables when the list values change, ensuring data consistency.

  • Notify GV Update: Enable notifications for global variable updates, providing feedback when data changes occur.

  • Public Filter: Set this feature to allow public access or use of the filter, expanding its availability to multiple users.

  • Description: Allows for additional text under the title.

  • Font Color: Changes the color of the title text.

  • Font Size: Modifies the size of the title text.

  • Font Style: Sets the style of the title text (e.g., italic).

  • Font Weight: Controls the thickness of the title text (e.g., bold).

  • Font Family: Specifies the typeface for the title text.

  • Align: Adjusts the text alignment (e.g., left, center, right).

  • Text Decoration: Adds effects like underlining the text.

  • Font Family: Selects the typeface to align with branding or design preferences.

  • Chrome Color Opacity: Controls the transparency level of the chrome color, allowing more or less background visibility.

  • Chrome Color: Sets the color of the browser's interface elements surrounding the component.

  • Roll Over Color: Defines the color that appears when hovering over elements, enhancing interactive feedback.

  • Selection Color: Specifies the color used to highlight selected elements, making them visually distinct.

  • Selection Font Color: Determines the font color of selected text, ensuring readability against the selection color.

  • Border: Adjusts the thickness and style of the component's border, contributing to its visual outline.

  • Border Color: Sets the color of the component's border, influencing its contrast and aesthetic appeal.

  • New Enhancements in the General Properties of the List component
  • Hierarchy Level: Allows selection between a Multiple or Single level hierarchy for data display.

  • Multiple Selection: Enables the capability to select multiple items at once within the component.

  • Controlled Selection: Manages how selections are controlled within the component, often working with external factors.

  • Custom Selection: Offers the option to define specific selection criteria or methods beyond default settings.

  • Selection Limit: Sets the maximum number of items to be selected.

  • Show Selection Limit: Option to display a notice or indicator when the selection limit is reached.

  • Auto Update GV: Automatically updates the Global Variable when changes occur within the component.

  • Notify GV Update: Alerts or indicates when a Global Variable has been updated due to user actions.

  • Public Filter: Determines whether the filter settings used in the component are accessible publicly or restricted.

  • Border Radius: Specifies the curvature of the component's corners for a rounded effect.

  • Panel Border Radius: Adjusts the corner curvature of the panel specifically.

  • Font Size: Determines the size of the text, enabling readability adjustments.

  • Font Style: Offers style options such as italic or normal for text appearance.

  • Font Weight: Controls the thickness of the text, ranging from light to bold.

  • Font Family: Selects the typeface to align with branding or design preferences.

  • Font Color: Sets the color of the text for clarity and aesthetic cohesion.

  • Panel Font Color: Defines the text color specifically within the panel.

  • Text Decoration: Applies effects like underlines or strikethroughs to the text.

  • Advance Theme: Enables advanced theming options for comprehensive stylistic control.

  • View Type: Determines the display style of the radio button, such as the Enhance Button.

  • Font Color/Size/Style/Weight/Family: Customizes the typography, including color, size, style, weight, and typeface.

  • Spacing: Adjusts the space between radio buttons to enhance layout clarity.

  • Border Radius: Rounds the corners of the buttons for a softer look.

  • Selection Color: Highlights the selected button, providing visual feedback.

  • Chrome Color: Sets the background color for buttons, with adjustable transparency.

  • Button Color: Defines the fill color of the radio button.

  • Circle Color: Sets the color of the circle within the radio button.

  • Circle Size: Adjusts the size of the circle marker inside the button.

  • Button Top Spacing: Sets the space above the button to manage layout balance.

  • Opacity: Controls the transparency level of the radio button for layering effects.

  • Orientation: Switches the arrangement between horizontal and vertical alignments.

  • Selected Index: Indicates which button is initially selected.

  • Auto Update GV: Automatically updates the global variable with the selected value.

  • Notify GV Update: Alerts the system to update the global variable when selection changes.

  • Modifying the Radio Button component with newly added Properties

    KPI Tile

    The KPI tile charting component displays the sum of quantity for progressive evolution. KPI is a measurable value that demonstrates how effectively a company is achieving key business objectives. The users can get a quick view of prominent trends, indicators, and values based on the various metrics of the business. Proper use of KPI helps in reducing the number of components used in the dashboard for multiple parameters for better performance. It contains the Sparkline component and Trend in build in it.

    Best Situations to Use a KPI Tile

    To provide information about the current performance of a company or organization at a glance

    Default KPI Tile Image

    Properties of the KPI Tile

    General

    • Component Name: Set a unique name to identify the KPI Tile component. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left: Determine the horizontal positioning of the chart.

    • Top: Adjust the vertical positioning of the chart.

    • Height: Define the height of the chart in pixels.

    Background and Style

    Category

    In the Category section, you can customize the appearance of text using the following fields:

    • Font Color: Select a color for the text to enhance readability and match the overall theme.

    • Font Size: Adjust the text size to ensure visibility and cohesiveness with other chart elements.

    • Font Style: Choose between different styles such as italic or normal to add emphasis or distinction.

    • Font Weight: Set the weight (thickness) of the font to highlight or deemphasize the text. The supported options are Normal, Bold, 300, 600, and 900.

    Primary Series

    The user can set and modify the Font Color, Font Size, Font Style, Font Weight, and Font Family for the Primary Series (first series field).

    • Font Color: Select a color for the text to enhance readability and match the overall theme.

    • Font Size: Adjust the text size to ensure visibility and cohesiveness with other chart elements.

    • Font Style: Choose between different styles such as italic or normal to add emphasis or distinction.

    • Font Weight: Set the weight (thickness) of the font to highlight or deemphasize the text. The supported options are Normal, Bold, 300, 600, and 900.

    Secondary Series

    The user can set and modify the Font Color, Font Size, Font Style, Font Weight, and Font Family ac. for the Secondary Series (second series field).

    • Font Color: Select a color for the text to enhance readability and match the overall theme.

    • Font Size: Adjust the text size to ensure visibility and cohesiveness with other chart elements.

    • Font Style: Choose between different styles such as italic or normal to add emphasis or distinction.

    • Font Weight: Set the weight (thickness) of the font to highlight or deemphasize the text. The supported options are Normal, Bold, 300, 600, and 900.

    Dataset Indicator Properties

    KPI Tile Variants

    Sparkline

    Sparkline with Trend

    Trend

    Sample Data

    Download the given sample data and map it as mentioned below to plot your KPI Tile chart.

    Use the Value Field column as the Category field, Primary Series and Secondary Series columns as Series, and Sparkline and Trend columns as Indicator columns to plot data.

    Please Note: The user also needs to set the No. of rows/ columns from the General Properties fields to plot the sample data as displayed in the above-given image. E.g., the current image displays a chart with 5 sets as the No. of rows/ columns.

    Combobox

    Check out the walk-through given below on how to use a Combobox filter component in the Designer.

    Combo Box is used to filter data on any associated components. Selecting an item from the drop-down menu will change the data displayed in the associated components.

    Best Situation to Use Combo Box

    • To filter data on associated components.

    • To select only a particular item.

    Default Component Image

    Properties of the Combo Box Filter

    General

    The General Properties allow customization of the Combo Box Filter component through various fields:

    • Component Name: Defines the identifier name for the Combo Box Filter component.

    • Show Search: Enables or disables the search function, assisting users in finding specific values.

    • Left, Top: Sets the component position in the user interface by specifying the leftmost and topmost margins.

    • Height, Width: Adjusts the size dimensions of the Combo Box Filter component.

    Background

    The Background Properties panel offers options to enhance the visual layout of the component through the following fields:

    • Shadow: Enables a shadow effect for the component, creating a sense of depth and focus.

    • Shadow Color: Sets the color of the shadow, allowing for customization to match the overall design theme.

    • Shadow Transparency: Adjusts the transparency of the shadow, providing control over how prominent or subtle the shadow appears.

    • Background Color: Defines the main color filling to the component background for aesthetic and branding consistency.

    Title

    • Title Box Color: Sets the background color of the title box for a cohesive look.

    • Show Title Box: Toggles the visibility of the title box.

    • Show Title: Allows the title text to be displayed.

    • Show Only Title: Displays only the title, hiding other elements for a minimalist approach.

    Dropdown Style

    • Rollover Color: This property changes the background color when a user hovers over an option in the dropdown, enhancing interactivity and user experience.

    • Selection Color: Defines the background color of a selected option in the dropdown, providing a visual indication of the user's choice.

    • Background Color: Sets the overall background color of the dropdown menu, contributing to the visual consistency of the design.

    Combo Box Filter Variants after Changing its Properties

    Default Selection

    Single Select

    Multiselect with enhanced Checkbox

    Canvas Properties

    The Canvas Properties helps users to configure properties for the entire dashboard.

    The Designer canvass is provided with specific properties.

    • Navigate to the Designer canvas.

    • Use the Right-click anywhere on the canvas to get the Dashboard properties.

    • Select the

  • Width: Set the width of the chart in pixels.

  • Initial Visibility: Enable this option to make the chart visible during the initial preview.

  • Tooltip: Enable this field to show the information text that appears when the user hovers over the KPI Tile.

  • Direction: Choose between horizontal or vertical orientation to display data trends.

  • No. of Rows/ Columns: Provide a number to define the number of rows and columns.

  • +ve Trend Color: Set a trend color for the positive value.

  • -ve Trend Color: Set a trend color for the negative value.

  • Zero Trend Color: Set a trend color for the Zero value.

  • SparkLine Color: Select the border color for the Sparkline when this indicator type is chosen.

  • SparkLine Fill Color: Select the fill color for the Sparkline using this field.

  • Font Family: Opt for a typeface that aligns with the chart's aesthetic or your branding requirements.

  • Font Family: Opt for a typeface that aligns with the chart's aesthetic or your branding requirements.

  • Font Family: Opt for a typeface that aligns with the chart's aesthetic or your branding requirements.

  • 9KB
    Sample Data_KPI Tile.xlsx
    Open
  • Initial Visibility: Determines whether the filter is visible upon the first preview. If not enabled, the chart won't appear initially.

  • Font Color, Font Size: Modifies the text color and size within the filter for better visual distinction.

  • Font Style, Font Weight, Font Family: Customizes the typography, including style (e.g., italic), weight (e.g., bold), and font family for a consistent visual theme.

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the title text from the given choices.

  • Selection: Allows choosing between 'Default', 'Single', or 'Multiple' selection modes for item selection flexibility.

  • Selected Index: Sets a default value that appears initially in the filter; requires enabling 'Notify GV Update' for dynamic changes.

  • Auto Update GV: Automatically refreshes the filter when changes occur to the governing variables (GV) without manual intervention.

  • Notify GV Update: Notifies and updates linked variables when a selection is made, keeping data in sync.

  • Public Filter: Determines if the filter settings should be accessible to other components or users.

  • Title Bar Height: Adjusts the height of the title bar, impacting the overall layout.

  • Description: Adds supplementary information beneath the title.

  • Font Color: Specifies the color of the title text for readability and design alignment.

  • Font Size: Defines the size of the title text.

  • Font Style: Choose between normal, italic, or oblique styling for the title text.

  • Font Weight: Sets the thickness of the title text, offering a range from light to bold.

  • Font Family: Selects the font family to apply to the title text.

  • Align: Aligns the title text (left, center, right) within its container.

  • Text Decoration: Adds text decoration such as underline, overline, or line-through.

  • Position: Determines the position of the title element within the component.

  • Properties
    option from the context menu.
    Accessing the Properties option for the Dashboard Canvas
    • Various Dashboard level properties get listed in the displayed context menu as shown in the below-given image:​​

    Dashboard Properties

    Gradient

    ​​​

    Parameter Name

    Description

    Background Colors

    Users will be directed to select a background color.

    Opacity

    Set background-color opacity.

    Background Rotation

    Set the value to rotate the background color accordingly

    Please Note: By clicking the Background Colors icon, a new window opens with a menu to select a color for the Background (as displayed in the below-given image) gradient colors. The users can select a color using the menu and click the Save option to apply the selected background gradient color. The colors pallet to set background gradient color is given below:

    Border

    The Border Properties fields​

    Parameter Name

    Description

    Thickness

    Set border thickness.

    Border Color

    Select a border color from the menu.

    Global Font And Themes

    ​

    Global Font & Themes Properties fields

    Parameter Name

    Description

    Use Global Shadow

    Enable this option to display global shadow

    Shadow Color

    Select a color from using the menu

    Shadow Transparency

    Set the transparency for the shadow

    Use Global Font

    Enable this option to use the global font.

    Font Family

    Select a font type from the drop-down menu.

    • Select the Global Font And Themes option from the context menu.

    • Click on the Designer themes icon.

    Screen Size

    The Size Properties option helps to

    Check out the given walk-through on how redraw on resize Property gets applied to the Dashboard.

    Displaying Redraw on Resize option

    ​

    Parameter Name

    Description

    Screen Size

    Select an option from the drop-down menu.

    Width

    Increase/decrease the width of the dashboard.

    Height

    Increase/decrease the height of the dashboard.

    Redraw on resize

    Redraws the dashboard while resizing it.

    Enable Scaling

    Enable this option to display scaling.

    Please Note: The Dashboard screen size can be scaled based on display devices (E.g., Mobile, iPad, and PC).

    Steps to set the Screen Size

    • Click the drop-down icon for the Screen Size field.

    • A context menu appears displaying various options to set the Screen Size.

    ​​

    Language Mapping

    Language Mapping Properties fields

    ​

    Parameter Name

    Description

    Enable

    Enable this option to apply language mapping functionality.

    Hide Curly Braces

    Enable this option to hide the curly braces.

    Select a Mapping

    Select a language mapping using the drop-down menu.

    Please Note: By clicking on the Select a Mapping icon, the Language Mapping Selection dialog box opens.

    Steps to Map a Language

    • Navigate to the Language Mapping Selection dialog box.

    • Select a language mapping option using the Mapping List drop-down menu.

    • Click the Save option.

    Mapping a Language

    Cache

    ​​

    Use a checkmark in the given box to enable the Enable Cache option for the data service. If cache is enabled for a dashboard with a data service as a data source it will do the following tasks:

    • While loading the dashboard, for the first time data will hit from database.

    • The same dashboard while loading again it will load the data from the Cache.

    Report Burst

    ​​

    Use a checkmark in the given box to Enable Report Burst. By enabling the Report Burst option from the Dashboard properties displays the Report Burst option for a published Dashboard. Refer the Report Burst section from the Options for a Published Dashboard section for more details.

    Please Note: The Report Burst option comes pre-selected in all the new dashboards.

    Spark Line

    A Sparkline is a small chart that is drawn without axes. It does not contain some chart-specific elements (such as legend, title, etc.). The Sparkline chart can be easily embedded in the text as it performs more like an inline element (rendered inside a span) as opposed to the standard charts, which behave like block elements. The primary purpose attached to the Sparkline Chart is to show a trend of something unique.

    The best situation to use the Sparkline chart

    To show the data trend.

    Default Chart Image

    Properties of the Sparkline chart

    General

    • Component Name: Set a unique name for the component identification. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left: Sets the horizontal position of the chart within the workspace.

    • Top: Sets the vertical position of the chart within the workspace.

    • Height: Adjusts the vertical size of the chart.

    Background

    • Gradient Rotation: Adjust the angle of the gradient applied to the background, allowing for a dynamic visual transition between colors.

    • Opacity: Set the transparency level of the background, ranging from fully opaque to completely transparent.

    • Gradient: Enable or disable gradient colors in the background for depth and visual appeal.

    Tooltip

    • Show Tool Tip: The user can show the series description and get the tooltip by clicking the Show Tool Tip option.

      • The Tool Tip Configuration window opens.

      • Select any Tool Tip option. The supported Tool Tip options are None and Default.

    Line

    When configuring the Line chart in the Sparkline component, various properties can be adjusted to enhance visual representation:

    • Line Color: Set the color for the line in the chart to make it stand out.

    • Fill Color: Choose a color to fill the area between the line and the x-axis.

    • Opacity: Adjust the transparency level of the fill color for clear visibility.

    • Line Width: Specify the thickness of the line to ensure it is easily visible.

    Bar

    • Bar Spacing: Adjust the space between individual bars for better clarity or a compact look.

    • Zero Axis: Enable or disable the zero-axis line for reference in the bar chart.

    • Positive Color: Select a color to represent the bars with positive values.

    • Negative Color: Choose a color for bars indicating negative values.

    Tristate

    After selecting the type to Tristate from the General section, the following properties can be adjusted to enhance its visual representation:

    • Bar Spacing: Modify the space between bars to achieve a more refined or compact layout, allowing for better visual differentiation.

    • Positive Color: Assign a specific color to bars that represent positive values, aiding quick identification of growth or gains.

    • Negative Color: Choose a distinct color for bars displaying negative values, highlighting losses or declines effectively.

    • Zero Color

    Formatter

    The Formatter allows users to customize how numerical data is displayed. This includes:

    • Currency: Select the currency type for financial values. Options include CENT, EURO, INR, POUND, USD, and YEN.

    • Position: Choose where the currency symbol appears. Use the Prefix position if the currency is in INR format, or the Suffix position for other formats like Pound or USD.

    • Number Formatter: Set the number format based on your region's convention. You can choose between the Indian and International number formats, affecting how large numbers are grouped and separated.

    The following variants can be obtained by changing Spark Line properties:

    Sparkline Line

    Sparkline Bar

    Sparkline Tristate

    ​Sample Data

    Download the given sample data and map it as mentioned below to plot your Spark Line chart.

    Use the Tristate column as the Category field, and the Trend column as the Series field to plot data.

    Pivot Grid

    Pivot grid, also known as Pivot Table is a data summarization tool used in data visualization software. The users can identify and select columns and rows of data in a database or spreadsheet to obtain a desired report using the pivot grid tool. A pivot grid does not change the actual database or spreadsheet but turns the data to be viewed from different perspectives.

    Best Situation to Use Pivot Grid

    When the users want to perform analysis on multi-dimensional data by generating cross-tabular reports.

    Default Pivot Grid Chart Image

    Properties of the Pivot Grid Chart

    General

    • Component Name: Allows the user to assign a unique identifier to the chart component.

    • Left: Adjusts the horizontal position of the chart on the page.

    • Top: Controls the vertical placement of the chart within the display area.

    • Height: Sets the vertical dimension of the chart.

    Background

    • Gradient Rotation: Modify the angle of the gradient to achieve the desired effect.

    • Opacity: Set the transparency level to balance visibility and aesthetics.

    • Gradient: Choose and customize the gradient colors to match your theme.

      • Click the

    Title

    • Title Box Color: Set the color of the title box to complement your chart's overall design.

    • Show Title Box: Toggle this option to display or hide the title box around the title text.

    • Show Title: Enable or disable the title visibility on your chart.

    • Title Bar Height: Adjust the title bar height to fit your design specifications.

    Subtitle

    • Show Sub Title: Enable or disable the display of the sub-title text.

    • Description: Add a description text below the sub-title.

    • Font Color: Select the color of the sub-title text.

    • Font Size: Specify the size of the sub-title text.

    Header Style

    The Header Style section allows for customization of the header in your design. You can modify the following fields:

    • Header Text Color: Set the color of the header text to align with your theme.

    • Font Size: Define the text size in the header for visibility and emphasis.

    • Font Style: Choose a style such as italic or normal to enhance the header's appearance.

    • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

    Row Style

    The user can change the Font color-size-weight-family of the text inside the row. Row height can also be adjusted. Under text decoration, we can provide an underline to the text.

    Styles

    • Roll Over Color: Defines the color that will be applied while rolling over the rows.

    • Text Hover Color: Specifies the color that text changes to when hovered over by the mouse pointer, useful for providing visual feedback.

    • Selection Color: Determines the color used to highlight selected elements, ensuring that selections are easily distinguishable.

    • Horizontal Grid Lines:

    Export Options

    • Enable Context Menu: Activate a right-click context menu for quick access to export options in the preview mode of the chart.

    • Export Excel: Save the chart data in an Excel file format (.xlsx).

    • Export CSV: Export the chart data into a CSV file format (.csv).

    • Export JPEG: Export the chart as a JPEG image (.jpg).

    Dataset Properties

    The user can map the dataset as displayed in the images: Row: State & City, Column: Country, Values: Population & Revenue.

    The selected Values can be configured by using the Properties.

    Pivot Grid Variants after Changing the Component Properties

    Please Note:

    • The user needs to select the Column Type as Numeric for the selected Data Grid fields using the Properties tab provided for the Dataset, so they become responsive to the changes that the user set using the Indicator tab.

    Checkbox

    Check out the given walk-through to understand the Checkbox filter component.

    The checkbox is used to filter data on any associated components. Enabling a checkbox will change the data displayed in the associated components.

    Best Situation to use Checkbox

    • To filter data displayed in the associated components

    • To select multiple items at a time

    Default Checkbox Image

    Properties of the Checkbox filter

    General

    The checkbox component offers a range of customizable properties to tailor its appearance and functionality:

    • Component Name: Assign a unique name to identify the checkbox component.

    • Left: Set the left position of the checkbox within its container.

    • Top: Define the top position of the checkbox within its container.

    • Height: Specify the height of the checkbox.

    Multi-checkbox Settings

    The user can provide multiple checkboxes while enabling this property option.

    • Multiple Checkboxes: Enable the Multiple Checkboxes option from the MultiCheckbox Settings property to add multiple checkboxes with labels.

    • Toggle Checkboxes: Enable the option to access the new Toggle Switch UI as checkboxes.

    • Manage Checkbox: Click the Manage Checkbox icon to access the dialog window for managing multiple checkboxes.

      • The user can add or delete checkboxes.

      • Provide Label Text, select the default display to be checked or unchecked, and provide value for the checked toggle checkboxes.

    • Direction: Select an option from the drop-down menu to choose the direction of the checkboxes. It can be Horizontal or Vertical.

    Toggle Style

    The user can style the toggle switch UI using the Toggle Style property option.

    • The user can modify the Width, Height, and Toggle Switch Shape (Round or Square) from the Toggle Stypes property option.

    • The user can also define colors for the Toggle Slider, Checked Color, and UnChecked Color.

    Background

    • The user can get the reflection of the chart by enabling the shadow option.

    • The user can also change the color and increase/decrease the transparency of the shadow.

    Modified Checkbox filter after changing its properties

    ​​

    Checkbox Use Case - Mapping the

    The following use case explains the steps to connect and use a Checkbox with a Data Grid component.

    • Drag a Data Grid component to the Designer canvas.

    • Associate a Data Connection with it.

    • Drag a Checkbox component from the Filter group to the canvas.

    • Open the Checkbox Properties, provide the necessary properties, and apply them.

      • Provide the text for the Label.

      • Provide the Checked Value.

      • Keep the Unchecked Value blank.

    • Configure the Condition tab by providing a field value for the conditions (the field State is chosen in the given image).

    • Click the Preview icon to preview the Dashboard.

    ​

    • Use a checkmark in the given box to display the Checked Value in the chart.

    • Uncheck the Check Box to display the Unchecked Value in the chart (In this case, no value has been assigned as Unchecked Value so it will display all the records).

    Mito Plot

    Mito is a very advanced chart that is based on mitochondrial DNA study. The Mito-plot chart shows the basic structure of mitochondrial DNA, as shown in the figure. Mito-Plot chart divided into different segments each segment produces a protein (RNA type) these proteins is essential during the cellular respiration cycle. These segments have been defined through the category, and its color depends on the RNA type what it contains. Mitochondrial DNA has two strands, and that can be differentiated based on their nucleotide content, these two strands are a heavy strand or H-strand and a light strand or L-strand. H-strand is a genuine rich strand and represents through the segment which orientation towards outside. L-strand is a cytosine-rich strand that represents through the segment which orients towards inside.

    Check out the below given walk-through on how to use the Mito Plot chart component in Designer module.

    Best Situations to Use a Mito Plot Chart

    Medical experts can use this chart to visualize mitochondrial DNA damage specific to individuals.

    Default Mito Plot Image

    Properties of the Mito Plot

    General

    The General Properties section allows the user to customize various aspects of the component. Here are the fields you can modify:

    • Component Name: Set a unique name for the component identification. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left & Top: Define the component's position on the screen by setting the left and top margins.

    • Height & Width: Specify the dimensions to ensure the component fits the desired space.

    • Initial Visibility

    Tooltip

    The user who wants to show the series description can use the tooltip by enabling it.

    • The user can show the series description and get the tooltip by clicking the Show Tool Tip option.

      • The Tool Tip Configuration window opens.

      • Select any Tool Tip option. The supported Tool Tip is None and Custom.

    Please Note: To use the Custom option for the Tool Tip configuration, please refer to the page.

    Background

    • Gradient Rotation: Modify the angle of the gradient to achieve the desired effect.

    • Opacity: Set the transparency level to balance visibility and aesthetics.

    • Gradient: Choose and customize Click the Gradient icon.

    Title

    • Title Box Color: Choose the background color for the title box.

    • Show Title Box: Enable or disable the display of the title box on the chart.

    • Show Title: Enable or disable the display of the title text.

    • Title Bar Height: Set the height of the title bar.

    Please Note: The Title will be added from the mapped dataset if the Show Dataset Description option is enabled.

    Subtitle

    • Show Sub Title: Enable or disable the display of the sub-title text.

    • Description: Add a description text below the sub-title.

    • Font Color: Select the color of the sub-title text.

    • Font Size: Specify the size of the sub-title text.

    Export Options

    • Enable Context Menu: Activate a right-click context menu for quick access to export options in the preview mode of the chart.

    • Export Excel: Save the chart data in an Excel file format (.xlsx).

    • Export CSV: Export the chart data into a CSV file format (.csv).

    • Export JPEG: Export the chart as a JPEG image (.jpg).

    The user can get the Export Context Menu from the preview mode to download the reports in different export formats.

    Mito Plot after Changing its Properties

    Sample Data

    Download the given sample data and map it as mentioned below to plot your Mito chart.

    • Use the Patient_seq column as Category field, Color_rnaType column as RNA Type, orientation column as Orientation field, start column as Start field, stop column as Stop field, and dataLabel_pos column as Marker field to plot data.

    Inverted Funnel

    Inverted Funnel charts are a great way to track progress through a workflow with multiple steps. They can highlight how well a process is being followed and easily identify any bottlenecks.

    The users can invert the funnel chart to see things from a different point of view. It widens at the bottom and narrows at the top pinpointing the various phases in a classified structure. This chart can be used to see the hierarchical structure of an organization or distribution process of fund/salary/profit etc.

    Best Situations to Use a Column chart

    To display hierarchical pattern

    Example: To categorize the administrative structure in an organization

    Data Sheet

    Data Sheets are used to capturing various process, mechanical, electrical, technical, and control requirements for equipment and instruments. The sheets incorporate information about the selected components, usually with input from multiple users.

    Best Situation to use Data Sheet Grid

    To collect information from various users. To bring the collected information from the various users to one place. To search, filter, and compare the collected data.

  • Width: Adjusts the horizontal size of the chart.

  • Initial Visibility: When unchecked, the chart will not be displayed during the first preview.

  • Type: Allows the selection of the chart type, such as Line, Bar, or Tristate, offering flexibility in data representation.

  • Click the Gradient icon to access the Background gradient colors dialog box.
  • Click the Add Color option to add multiple colors.

  • Click the Save option to apply the selected background colors.

  • Border: Define the width of the border surrounding the pyramid chart.

  • Border Color: Select the color for the chart's border, enhancing its visibility and aesthetics.

  • Border Radius: Round the corners of the chart's border for a softer, more modern appearance.

  • Shadow: Enable a shadow effect for the background to add dimension and focus to the chart.

  • Shadow Color: Choose the color of the shadow cast by the chart background.

  • Shadow Transparency: Adjust the transparency level of the shadow to control its prominence and intensity.

  • Click the Save option.

  • Background Color: Set the background color for the tooltip box to enhance readability.

  • Opacity: Adjust the transparency level of the tooltip background.

  • Border Color: Define the color of the border surrounding the tooltip box.

  • Tooltip Font Size: Specify the font size for the text displayed in the tooltip.

  • Box Width: Determine the width of the tooltip box for optimal presentation.

  • Precision: Set the number of decimal places to show in the tooltip for numerical values.

  • Spot Color: Define a color for spots along the line to highlight data points.

  • Min Spot Color: Set a distinct color for the minimum value spot on the line.

  • Max Spot Color: Choose a color for highlighting the maximum value spot.

  • Highlight Spot Color: Specify a color to highlight certain spots for emphasis.

  • Highlight Line Color: Select a color to emphasize particular lines in the chart.

  • Spot Radius: Determine the size of the spots displayed on the line.

  • Min Normal Value: Set the lower bound of the normal value range to indicate on the chart.

  • Max Normal Value: Define the upper limit of the normal value range.

  • Normal Color: Choose a color to fill the area within the normal value range.

  • Min/Max Data Label: Enable this option to display the minimum and maximum values directly on the chart.

  • Zero Color: Define the color for bars that represent zero values.

  • Auto Axis: Automatically adjust the axis based on the data range to optimize chart appearance.

  • Min Y-Axis Range: Set the minimum range for the Y-axis to maintain a consistent scale across charts.

  • : Set a color for bars that denote zero values, ensuring these neutral or unchanged data points are visible.
    8KB
    Sample Data_Sparkline.xlsx
    Open

    Width: Determines the horizontal dimension of the chart.

  • Initial Visibility: Determines whether the chart is visible upon the first preview.

  • Max Button: Enables or disables the option to maximize the chart.

  • First Column Width: Sets the width of the first column.

  • Fit Columns: Configures the chart to adjust its columns for the best fit.

  • Gradient
    icon to access the
    Background gradient colors
    dialog box.
  • Click the Add Color option to add multiple colors.

  • Click the Save option to apply the selected background colors.

  • Border: Add a border around the chart for a defined perimeter.

  • Border Color: Alter the border color to complement or contrast with the chart.

  • Border Radius: Round the corners of the chart border for a smoother look.

  • Shadow: Enable shadows to create depth and a 3D-like effect.

  • Shadow Color: Customize the shadow color to blend naturally with the chart.

  • Shadow Transparency: Adjust the transparency level to control the intensity of the shadow effect.​

  • Description: Provide an additional description for the chart title to offer more context.

  • Font Color: Choose the font color for the title to ensure readability and match your theme.

  • Font Size: Set the title's font size for optimal visibility and aesthetics.

  • Font Style: Select the font style (e.g., italic, bold) to enhance the title's appearance.

  • Font Weight: Modify the font weight to make the title text lighter or bolder.

  • Font Family: Pick a font family that aligns with your design theme for the title.

  • Align: Align the title text to the left, center, or right according to your layout needs.

  • Text Decoration: Apply text decorations to the title for emphasis (E.g., Underline).

  • Show Dataset Description: Enable or disable the dataset description in the title.

  • Font Style: Choose the font style for the Sub-title (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the sub-title text from the given choices.

  • Align: Align the sub-title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the sub-title text.

  • Font Family: Select a font family for the header that complements your overall design.

  • Use Field Color: Enable this option to apply a specific field color to the header background.

  • Background Color: Change the header's background color to match or contrast with the text.

  • Text Decoration: Apply decorative elements like Underline to the header text for additional styling.

  • When enabled, adds horizontal lines between rows for improved readability and structure.
  • Horizontal Line Color: Customizes the color of the horizontal grid lines to match the design theme or improve visual clarity.

  • Vertical Line Color: Adjusts the color of the vertical grid lines, allowing for consistent styling with other elements.

  • Grid Colors: Allows users to change the row color and alternate row color to create a visually appealing grid layout.

  • Export PNG: Export the chart as a PNG image (.png).

  • Export PPT: Export the chart to a PowerPoint presentation (.pptx).

  • Export PDF: Export the chart as a PDF document (.pdf).

  • Show Print: Include an option to print the chart directly.

  • Export Heading: Add a custom heading to the exported file.

  • Export Sub Heading: Add a custom subheading to the exported file.

  • Export File Name: Specify the file name for the exported file/dashboard.

  • Global Export Type: Define the default export format using the drop-down (e.g., Screenshot, Tabular).

    • Refer to the Alerts in Grids page under the Configurations section to understand how to insert Alerts in a Grid component.

    Width: Determine the width of the checkbox.

  • Initial Visibility: Enable or disable the initial visibility of the checkbox in the preview.

  • Show Checked: Enable to display a checkmark by default.

  • Label: Assign a name to the checkbox label, which can be customized.

  • Font Color: Change the font color of the label.

  • Font Size: Adjust the size of the label text.

  • Font Style: Select the style (e.g., italic) for the label font.

  • Font Weight: Set the weight (e.g., boldness) of the label font.

  • Font Family: Choose the font family for the label text.

  • Chrome Color: Set the background color of the checkbox, with adjustable transparency.

  • Opacity: Modify the transparency level of the checkbox background.

  • Checked Value: Assign a value that is passed when the checkbox is checked.

  • Unchecked Value: Specify a value that is passed when the checkbox is unchecked.​

  • ​

  • Use the component object page to write the required script at the component level.

  • : Determine if the component should be visible initially; if unchecked, it won't appear on the first preview.
  • Max Button: Enable the option to maximize the component, allowing users to expand it for better visibility.

  • Series Colors: Customize the colors of the series, for the Mito chart to distinguish different segments.

  • Chart Alignment: Adjust the alignment of the chart within the container, choosing from Center, Right, or Left.

  • Click the Save option.

  • Background Color: Set the tooltip background color to enhance its visibility and appearance.

  • Opacity: Adjust the transparency level of the tooltip to ensure that the information is visible without obstructing the view of the main chart.

  • Border Color: Define the color of the tooltip's border to make it stand out against the background.

  • Tooltip Font Size: Specify the font size within the tooltip for better readability.

  • Box Width: Set the width of the tooltip box to accommodate the content and maintain a tidy layout.

  • Precision: Choose the decimal precision to display numerical data accurately in the tooltip, allowing for more precise data representation.

  • Click the Gradient icon to access the Background gradient colors dialog box.
  • Click the Add Color option to add multiple colors.

  • Click the Save option to apply the selected background colors.

  • Border: Add a border around the chart for a defined perimeter.

  • Border Color: Alter the border color to complement or contrast with the chart.

  • Border Radius: Round the corners of the chart border for a smoother look.

  • Shadow: Enable shadows to create depth and a 3D-like effect.

  • Shadow Color: Customize the shadow color to blend naturally with the chart.

  • Shadow Transparency: Adjust the transparency level to control the intensity of the shadow effect.

  • Description: Add a description text below the title.

  • Font Color: Select the color of the title text.

  • Font Size: Specify the size of the title text.

  • Font Style: Choose a Font style using the drop-down menu (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the title text from the given choices.

  • Align: Align the title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the title text.

  • Show Dataset Description: Enable or disable the dataset description in the title.

  • Font Style: Choose the font style for the Sub-title (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the sub-title text from the given choices.

  • Align: Align the sub-title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the sub-title text.

  • Export PNG: Export the chart as a PNG image (.png).

  • Export PPT: Export the chart to a PowerPoint presentation (.pptx).

  • Export PDF: Export the chart as a PDF document (.pdf).

  • Show Print: Include an option to print the chart directly.

  • Export Heading: Add a custom heading to the exported file.

  • Export Sub Heading: Add a custom subheading to the exported file.

  • Export File Name: Specify the file name for the exported file/dashboard.

  • Global Export Type: Define the default export format using the drop-down (e.g., Screenshot, Tabular).

  • Tooltip (Default & Custom)
    14KB
    Sample Data_Mito chart.xlsx
    Open

    Default Chart Image

    Properties of the Inverted Funnel Chart

    General

    The user can change the height, width, top, left, chart type, column type & Line form. In this case, we have changed the chart type to Inverted & Identical Stack.

    • Component Name: Assigns a unique identifier to the inverted funnel chart component. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left: Determines the horizontal position of the chart within the container.

    • Top: Sets the vertical positioning of the chart.

    • Height: Specifies the height of the funnel chart.

    • Width: Defines the width of the chart.

    • Initial Visibility: Controls whether the chart is visible upon initial load.

    • Max Button: Allows the inclusion of a button to maximize the chart view.

    • Show Percentage: Enables the display of percentage values on the chart.

    • Series Colors: Customizes the colors for different series in the funnel chart.

    General Properties with Identical Stack Chart Type

    Tooltip

    Tooltips enhance user interaction by displaying additional information about chart elements.

    • Show Tool Tip: Enable this option to display tooltips for the chart series, providing descriptions or data insights.

      • Click the Show Tool Tip icon to access the Tool Tip Configuration window.

      • Select the Default option.

      • Click the Save option to display Tool Tip in the default display.

    • Background Color: Choose a background color for the tooltip to enhance visibility and match your visual theme.

    • Opacity: Adjust the tooltip's transparency to ensure it doesn't obstruct important chart elements while remaining readable.

    • Border Color: Select a border color that complements the tooltip, ensuring clarity and contrast against the chart background.

    • Tooltip Font Size: Customize the font size to maintain readability, adapting it to the overall chart presentation.

    • Box Width: Define the width of the tooltip box to ensure it fits the content appropriately and maintains a neat appearance.

    • Precision: Set the numerical precision for data values displayed in the tooltip, aiding in clearer data interpretation.

    • Highlighter: Toggle the highlighter to emphasize specific data points on the chart, drawing user attention to crucial information.

    Please Note: To use the Custom option for the Tool Tip configuration, please refer to the Tooltip (Default & Custom) page.

    Background

    • Gradient Rotation: Modify the angle of the gradient to achieve the desired effect.

    • Opacity: Set the transparency level to balance visibility and aesthetics.

    • Gradient: Choose and customize the gradient colors to match your theme.

      • Click the Gradient icon to access the Background gradient colors dialog box.

      • Click the Add Color option to add multiple colors.

      • Click the Save option to apply the selected background colors.

    • Border: Add a border around the chart for a defined perimeter.

    • Border Color: Alter the border color to complement or contrast with the chart.

    • Border Radius: Round the corners of the chart border for a smoother look.

    • Shadow: Enable shadows to create depth and a 3D-like effect.

    • Shadow Color: Customize the shadow color to blend naturally with the chart.

    • Shadow Transparency: Adjust the transparency level to control the intensity of the shadow effect.

    Title

    • Show Title Box: Enable or disable the display of the title box on the chart.

    • Title Box Color: Choose the background color for the title box.

    • Show Title: Enable or disable the display of the title text.

    • Title Bar Height: Set the height of the title bar.

    • Description: Add a description text below the title.

    • Font Color: Select the color of the title text.

    • Font Size: Specify the size of the title text.

    • Font Style: Choose a Font style using the drop-down menu (e.g., italic or normal).

    • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

    • Font Family: Choose the font family for the title text from the given choices.

    • Align: Align the title text (e.g., left, center, right).

    • Text Decoration: Apply text decorations (e.g., underline) to the title text.

    • Show Dataset Description: Enable or disable the dataset description in the title.

    Please Note: By enabling the Show Dataset Description option the Title will get added from the mapped dataset.

    Subtitle

    • Show Sub Title: Enable or disable the display of the sub-title text.

    • Description: Add a description text below the sub-title.

    • Font Color: Select the color of the sub-title text.

    • Font Size: Specify the size of the sub-title text.

    • Font Style: Choose the font style for the Sub-title (e.g., italic or normal).

    • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

    • Font Family: Choose the font family for the sub-title text from the given choices.

    • Align: Align the sub-title text (e.g., left, center, right).

    • Text Decoration: Apply text decorations (e.g., underline) to the sub-title text.

    Legend

    • Show Legend: Toggle the visibility of the chart legend.

    • Font Color: Choose the font color for the legend text.

    • Font Weight: Determine the weight (boldness) of the legend text.

    • Font Size: Specify the size of the font for the legend text.

    • Font Family: Select the font family for the legend text.

    • Font Style: Choose the font style (e.g., italic) for the legend text.

    • Text Decoration: Add text decorations (e.g., underline) to the legend text.

    • Hide on Load: Determine if the legend should be hidden when the chart initially loads.

    Formatter

    • Unit: Define the unit of measurement for the values displayed in the chart.

    • Precision: Set the number of decimal places to display for numerical values.

    • Currency: Format the numbers as a currency with the appropriate symbol.

    • Position: Determine the position of the formatted value (e.g., before or after the number).

    • Number Formatter: Apply a specific notation or style to the numbers (e.g., Indian, International).

    Export Options

    • Enable Context Menu: Activate a right-click context menu for quick access to export options in the preview mode of the chart.

    • Export Excel: Save the chart data in an Excel file format (.xlsx).

    • Export CSV: Export the chart data into a CSV file format (.csv).

    • Export JPEG: Export the chart as a JPEG image (.jpg).

    • Export PNG: Export the chart as a PNG image (.png).

    • Export PPT: Export the chart to a PowerPoint presentation (.pptx).

    • Export PDF: Export the chart as a PDF document (.pdf).

    • Show Print: Include an option to print the chart directly.

    • Export Heading: Add a custom heading to the exported file.

    • Export Sub Heading: Add a custom subheading to the exported file.

    • Export File Name: Specify the file name for the exported file/dashboard.

    • Global Export Type: Define the default export format using the drop-down (e.g., Screenshot, Tabular).

    The user can get the Export Context Menu from the preview mode to download the reports in different export formats.

    Dataset Series Properties

    Inverted Funnel Chart Variants

    Inverted Chart

    Identical Stack Chart

    ​

    Sample Data

    Download the given sample data and map it as mentioned below to plot your Inverted Funnel chart.

    • Use the Stage column as Category field, and Count column as Series to plot data.

    8KB
    Sample Data_Inverted Funnel chart.xlsx
    Open
    Default Data Sheet Chart Image

    Properties of the Data Sheet component:

    General

    • Component Name: The unique identifier for the Paging Grid Component.

    • Left: Determines the horizontal position of the component on the page.

    • Top: Sets the vertical position of the component within the layout.

    • Height: Specifies the vertical size of the component.

    • Width: Defines the horizontal size of the component.

    • Initial Visibility: Controls whether the component is visible when the page first loads.

    • Max Button: Allows users to maximize the component to full screen.

    • Fit Columns: Adjusts the column widths automatically to fit the content or available space.

    • Editable: Allows users to modify the data within the grid cells directly.

    • Allow Row Insert: Enables the insertion of new rows, facilitating dynamic data entry.

    • Quick Cell Save: Provides an option to save changes in a cell immediately after editing, ensuring data is rapidly updated.

    • Pagination: Controls the division of data into pages, enhancing navigation and performance for large datasets.

    • No. of Rows: Specifies how many rows are displayed per page, allowing for customization according to user preference or screen size.

    Background

    • Gradient Rotation: Defines the angle at which the gradient is applied across the component.

    • Opacity: Controls the transparency level of the background, where 0 is completely transparent and 1 is fully opaque.

    • Gradient: Specifies the transition between colors used in the background.

    • Border: Determines the presence and thickness of the border surrounding the component.

    • Border Color: Sets the color of the component’s border.

    • Border Radius: Rounds the corners of the component’s border.

    • Shadow: Adds a shadow effect beneath the component.

    • Shadow Color: Defines the color of the shadow.

    • Shadow Transparency: Adjusts the visibility of the shadow, affecting how pronounced it appears.

    Please Note: The users will be redirected to the Background gradient colors window by clicking the Gradient icon.

    Title

    • Title Box Color: Set the color of the title box to complement your chart's overall design.

    • Show Title Box: Toggle this option to display or hide the title box around the title text.

    • Show Title: Enable or disable the title visibility on your chart.

    • Title Bar Height: Adjust the title bar height to fit your design specifications.

    • Description: Provide an additional description for the chart title to offer more context.

    • Font Color: Choose the font color for the title to ensure readability and match your theme.

    • Font Size: Set the title's font size for optimal visibility and aesthetics.

    • Font Style: Select the font style (e.g., italic, bold) to enhance the title's appearance.

    • Font Weight: Modify the font weight to make the title text lighter or bolder.

    • Font Family: Pick a font family that aligns with your design theme for the title.

    • Align: Align the title text to the left, center, or right according to your layout needs.

    • Text Decoration: Apply text decorations to the title for emphasis (E.g., Underline).

    • Show Dataset Description: Enable or disable the dataset description in the title.

    Subtitle

    • Show Sub Title: Enable or disable the display of the sub-title text.

    • Description: Add a description text below the sub-title.

    • Font Color: Select the color of the sub-title text.

    • Font Size: Specify the size of the sub-title text.

    • Font Style: Choose the font style for the Sub-title (e.g., italic or normal).

    • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

    • Font Family: Choose the font family for the sub-title text from the given choices.

    • Align: Align the sub-title text (e.g., left, center, right).

    • Text Decoration: Apply text decorations (e.g., underline) to the sub-title text.

    Header Style

    The Header Style section allows for customization of the header in your design. You can modify the following fields:

    • Header Text Color: Set the color of the header text to align with your theme.

    • Font Size: Define the text size in the header for visibility and emphasis.

    • Font Style: Choose a style such as italic or normal to enhance the header's appearance.

    • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

    • Font Family: Select a font family for the header that complements your overall design.

    • Use Field Color: Enable this option to apply a specific field color to the header background.

    • Background Color: Change the header's background color to match or contrast with the text.

    • Text Decoration: Apply decorative elements like Underline to the header text for additional styling.

    Row Style

    • Font Color: This property allows users to change the color of the text within a row, enabling better visibility and alignment with design aesthetics.

    • Font Size: Adjusts the size of the text, enhancing readability and fitting within the design requirements.

    • Font Style: Offers options such as italic or normal, providing stylistic flexibility for the text within the data grid.

    • Font Weight: Controls the thickness of the text, from normal to bold, helping users emphasize specific data points.

    • Font Family: Allows selection of different font families, ensuring the grid text aligns with overall design standards.

    • Text Decoration: Includes options such as underline, overline, or line-through, offering additional stylistic choices for the text.

    • Text Wrap: Enables text to wrap within the cell, ensuring complete visibility without affecting the row width.

    • Row Height: Users can increase or decrease the height of rows to accommodate more content or improve the grid's appearance.

    Styles

    • Border Color: Set the color of the border for visual separation and clarity in your data grid.

    • Measure Color: Define the color for measuring indicators, helping in data differentiation.

    • Target Color: Choose a color for target indicators to enhance the visibility of target values.

    • Marker Color: Select the color for markers to distinguish data points effectively.

    • Marker Font Color: Adjust the font color of marker labels for better readability.

    • Font Color: Allows customization of text color for consistency with design themes.

    • Actual Meter Size: Specify the size of the actual meter for a clear representation of data.

    • Target Meter Size: Define the size of the target meter to emphasize target goals.

    • Font Size: Set the size of the text to ensure readability and emphasis.

    • Font Family: Choose a font family that aligns with your overall design aesthetics.

    Grid Colors

    This properties option helps to set colors for the rows in the Data Sheet. The user can apply the following steps to set the grid colors for the rows.

    • Click the Grid Colors icon.

    • The Grid Colors window opens.

    • Select a color using the Row Color color pallet option.

    • Set a color for the alternate rows using the Alternate Row Color option.

    • Click the Save option.

    • The selected row colors will be applied to the Data Sheet.

    Data Sheet variants by changing the Properties

    Please Note:

    • The user needs to select the Column Type as Numeric for the selected Data Grid fields using the Properties tab provided for the Dataset, so they become responsive to the changes that the user sets using the Indicator tab.

    • Refer to the page under the section to understand how to insert Alerts in a Grid component.

    Designer Themes

    Select a theme from the drop-down menu.

    Scaling View

    Select an option from the drop-down menu (Fit to page/Fit to width/Fit to height/Proportional).

    Align

    Gets aligns based on the selected Align option.

    Funnel Chart

    The Funnel chart can represent various stages in a process. As the shape suggests it widens at the top and narrows at the bottom this chart helps to pinpoint a phase where the maximum dropout occurred. This type of chart can describe a progressive reduction of data as it passes from one phase to the other where each phase represents a different percentage of data contributing to the whole.

    Funnel charts help to track progress through a workflow with multiple steps. The user can highlight how well a process is being followed and easily identify any bottlenecks.

    Best Situations to Use a Funnel Chart

    Funnel charts are suitable for displaying sales conversation data.

    Examples:

    • To evaluate the success of a promotional campaign

    • To analyze the recruitment process

    • Default Chart Image

    Default Chart Image

    Properties of the Funnel chart

    General

    • Component Name: Assigns a unique identifier to the funnel chart component. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left: Determines the horizontal position of the chart within the container.

    • Top: Sets the vertical positioning of the chart.

    • Height: Specifies the height of the funnel chart.


    Tooltip

    Tooltips enhance user interaction by displaying additional information about chart elements.

    • Show Tool Tip: Enable this option to display tooltips for the chart series, providing descriptions or data insights.

      • Click the Show Tool Tip icon to access the Tool Tip Configuration window.

      • Select the Default option.

    Please Note: To use the Custom option for the Tool Tip configuration, please refer to the page.

    Background

    • Gradient Rotation: Modify the angle of the gradient to achieve the desired effect.

    • Opacity: Set the transparency level to balance visibility and aesthetics.

    • Gradient: Choose and customize the gradient colors to match your theme.

      • Click the

    Title

    • Title Box Color: Choose the background color for the title box.

    • Show Title Box: Enable or disable the display of the title box on the chart.

    • Show Title: Enable or disable the display of the title text.

    • Title Bar Height: Set the height of the title bar.

    Please Note: By enabling the Show Dataset Description option the Title will get added from the mapped dataset.

    Subtitle

    • Show Sub Title: Enable or disable the display of the sub-title text.

    • Description: Add a description text below the sub-title.

    • Font Color: Select the color of the sub-title text.

    • Font Size: Specify the size of the sub-title text.

    Legend

    • Show Legend: Toggle the visibility of the chart legend.

    • Font Color: Choose the font color for the legend text.

    • Font Weight: Determine the weight (boldness) of the legend text.

    • Font Size: Specify the size of the font for the legend text.

    Formatter

    • Unit: Define the unit of measurement for the values displayed in the chart.

    • Precision: Set the number of decimal places to display for numerical values.

    • Currency: Format the numbers as a currency with the appropriate symbol.

    • Position: Determine the position of the formatted value (e.g., before or after the number).

    Export Options

    • Enable Context Menu: Activate a right-click context menu for quick access to export options in the preview mode of the chart.

    • Export Excel: Save the chart data in an Excel file format (.xlsx).

    • Export CSV: Export the chart data into a CSV file format (.csv).

    • Export JPEG: Export the chart as a JPEG image (.jpg).

    • The user can get the Export Context Menu from the preview mode to download the reports in different export formats.

    Different Variants of Funnel Chart

    Funnel with default options

    Funnel with Percentage Option

    Sample Data

    Download the given sample data and map it as mentioned below to plot your Funnel chart:

    • Use the Stage column as a Category field, and the Count column as a Series to plot data.

    Please Note: The Category field can be any data type line, string, or numeric. However, the Series fields can be only numeric data types.

    Data Grid

    The Data Grid component is used to represent data in tabular form. Data Grid is also known as 'Grid View' as the data will be displayed within a grid.

    Best Situation to Use Data Grid

    • To view data in numerical format.

    • To show alerts.

    Default Data Grid Chart Image

    Properties of the Data Grid Chart

    General

    • Component Name: This field allows users to assign a unique name to the data grid component for easy identification and reference.

    • Left: Sets the horizontal position of the data grid component on the canvas.

    • Top: Sets the vertical position of the data grid component on the canvas.

    • Height: Adjusts the height of the data grid to fit the desired display area.

    Check out the given illustration on how to use the Column Rearrange property in the Data Grid.

    Background

    • Gradient Rotation: Modify the angle of the gradient to achieve the desired effect.

    • Opacity: Set the transparency level to balance visibility and aesthetics.

    • Gradient: Choose and customize the gradient colors to match your theme.

      • Click the

    Title

    • Title Box Color: Set the color of the title box to complement your chart's overall design.

    • Show Title Box: Toggle this option to display or hide the title box around the title text.

    • Show Title: Enable or disable the title visibility on your chart.

    • Title Bar Height: Adjust the title bar height to fit your design specifications.

    Subtitle

    • Show Sub Title: Enable or disable the display of the sub-title text.

    • Description: Add a description text below the sub-title.

    • Font Color: Select the color of the sub-title text.

    • Font Size: Specify the size of the sub-title text.

    Header Style

    The Header Style section allows for customization of the header in your design. You can modify the following fields:

    • Header Text Color: Set the color of the header text to align with your theme.

    • Font Size: Define the text size in the header for visibility and emphasis.

    • Font Style: Choose a style such as italic or normal to enhance the header's appearance.

    • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

    Access Check Boxes for the Multi-selection of the Rows

    Enable the Show Checkbox property from the General section and provide the "allowmultipleselection = true" in the Dashboard script to avail the checkboxes in the preview mode of the Data Grid.

    Check out the given illustration on accessing checkboxes for the multi-selection of the Grid Rows.

    Row Style

    • Font Color: This property allows users to change the color of the text within a row, enabling better visibility and alignment with design aesthetics.

    • Font Size: Adjusts the size of the text, enhancing readability and fitting within the design requirements.

    • Font Style: Offers options such as italic or normal, providing stylistic flexibility for the text within the data grid.

    • Font Weight

    Styles

    The users can set various display styles for the data grid using these fields.

    • Roll Over Color: The Roll Over Color property allows customization of the color change when a user hovers over an interface element. This provides visual feedback and helps highlight interactive components.

    • Selection Color: The Selection Color property determines the color displayed when an element or text is selected. It helps distinguish the selected items from the rest, facilitating easier navigation and interaction.

    • Horizontal Grid Lines: The Horizontal Grid Lines property allows users to enable or disable horizontal lines across the interface. These lines can aid in aligning and organizing content effectively, and their color can be customized to blend with the overall design.

    Export Options

    • Enable Context Menu: Activate a right-click context menu for quick access to export options in the preview mode of the chart.

    • Export Excel: Save the chart data in an Excel file format (.xlsx).

    • Export CSV: Export the chart data into a CSV file format (.csv).

    • Export JPEG: Export the chart as a JPEG image (.jpg).

    The user can get the Export Context Menu from the preview mode to download the reports in different export formats.

    Properties Tab from the Dataset Pallet

    Data Grid after changing the Properties

    Supported Date-Time Formats

    The Data Grid component supports the date columns with the following types of date-time formats:

    a. YYYY-MM-DD HH:MM:SS

    b. MM/DD/YYYY HH:MM:SS

    c. DD-MM-YYYY HH:MM:SS

    d. ISO 8601 format (e.g., 2023-08-23T14:30:00Z)

    e. Time formats such as 12-hour and 24-hour clocks (HH:MM)​​

    Check out the illustration displaying the support for the various date-time formats inside the Data Grid component.

    Please Note:

    • The user needs to select the Column Type as Numeric for the selected Data Grid fields using the Properties tab provided for the Dataset, to make it responsive to the changes that the user sets using the Indicator tab.

    Pie Chart

    Check out the walk-through on how to use the Pie chart component in the Designer module.

    The most widely used chart to show proportions, percentages, and categories of information. Users can use the Pie charts mainly to compare various categories. It is better to limit the categories up to 6 or fewer while visualizing them through a pie chart. Generally, Pie charts are used when values or the sum of values meet 100%.

    Best Situations to Use a Pie Chart

    Top performers and least performers based on the comparison of categories To illustrate breakdowns within a single dimension To show differences within groups based on one variable.

    Variations of this chart

    Pie-Doughnut

    Doughnut charts behave like a Pie-chart the user can switch the pie-chart to a doughnut.

    Default Pie Chart Image

    Properties of the Pie chart

    General

    • Component Name: Set a unique name for the component identification. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left/Top: Control the positioning of the chart within its container.

    • Height/Width: Specify the dimensions of the pie chart to fit your layout needs.

    • Initial Visibility: Toggle to determine if the chart is visible on the first preview.

    Tooltip

    • The user can show the series description and get the tooltip by clicking the Show Tool Tip option.

      • The Tool Tip Configuration window opens.

      • Select any Tool Tip option. The supported Tool Tip is None, Default, Custom.

    • Background Color: Set the background color for the tooltip box to enhance readability.

    • Opacity: Adjust the transparency level of the tooltip background.

    • Border Color: Define the color of the border surrounding the tooltip box.

    • Tooltip Font Size: Specify the font size for the text displayed in the tooltip.

    Please Note: To use the Custom option for the Tool Tip configuration, please refer to the page.

    Background

    The user can change the background color of the chart, get the border for the chart, and change the border color. Get the reflection of the chart by enabling the shadow option can also change the color, and increase or decrease the transparency of the shadow.

    • Gradient Rotation: Modify the angle of the gradient to achieve the desired effect.

    • Opacity: Set the transparency level to balance visibility and aesthetics.

    • Gradient: Choose and customize the gradient colors to match your theme.

      • Click the

    Title

    • Title Box Color: Choose the background color for the title box.

    • Show Title Box: Enable or disable the display of the title box on the chart.

    • Show Title: Enable or disable the display of the title text.

    • Title Bar Height: Set the height of the title bar.

    Please Note: By enabling the Show Dataset Description option the Title will be added from the mapped dataset.

    Subtitle

    • Show Sub Title: Enable or disable the display of the subtitle text.

    • Description: Add descriptive text below the subtitle.

    • Font Color: Choose the color for the subtitle text.

    • Font Size: Set the size of the subtitle text.

    Legend

    • Show Legend: Toggle to display or hide the legend on the chart.

    • Font Color: Select the color for the legend text.

    • Font Weight: Set the boldness of the legend text, with options like Normal, Bold, 300, 600, and 900.

    • Font Size: Specify the size of the legend text.

    Formatter

    • Unit: Specify the unit of measuring currency represented on the chart.

    • Precision: Define the number of decimal places to be displayed for numerical values to ensure accuracy and consistency.

    • Currency: Set the currency type for monetary values, allowing for consistent representation of financial data.

    • Position: Determine the placement of the formatted value about the axis or chart element, such as Prefix or Suffix.

    Export Options

    The Export Options section allows users to easily export their chart data in various formats for reporting and presentation purposes. This feature supports seamless integration with common applications and file types.

    • Enable Context Menu: Activates a context menu on the chart, providing quick access to export functions directly from the chart interface.

    • Export Excel: Allows the data to be exported as an Excel file, suitable for further analysis or sharing in a tabular format.

    • Export CSV: Exports data in CSV format, ideal for importing into databases or other data processing tools.

    • Export JPEG

    The user can get the Export Context Menu from the preview mode to download the reports in different export formats.

    Data Set Pallet Properties

    Variants of the Pie Chart

    Pie-Doughnut

    Doughnut charts behave like a Pie-chart the user can switch the pie-chart to a doughnut.

    Semi- Doughnut Pie Chart

    ​

    Sample Data

    Download the given sample data and map it as mentioned below to plot your Pie chart.

    • Use the ExpenseHeads column as a Category field and the DollorInMillion column as a Series to plot data.

    Please Note: The Category field can be any data type line, string, or numeric. However, Series fields can be only numeric data types.

    Paging Grid

    The Paging Data Grid is used to represent data in tabular form. Paging Data Grids can be used to filter data using columns, comparison operators, and search options provided.

    Best Situation to use Paging Data Grid

    • When end-user need to view data in numerical format.

    • When alerts need to be shown.

    • When end-users need to filter, compare, and search for data within the grid.

    Variations

    Add-up Filters: Filter data by selecting any column(s) present in the data grid

    Compare Operation: Data can be compared by using comparison operators

    Search: Search for a particular value

    Default Chart Image

    Properties of the Paging Grid Component

    General

    • Component Name: The unique identifier for the Paging Grid Component.

    • Left: Determines the horizontal position of the component on the page.

    • Top: Sets the vertical position of the component within the layout.

    • Height: Specifies the vertical size of the component.

    Background

    • Gradient Rotation: Defines the angle at which the gradient is applied across the component.

    • Opacity: Controls the transparency level of the background, where 0 is completely transparent and 1 is fully opaque.

    • Gradient: Specifies the transition between colors used in the background.

    • Border: Determines the presence and thickness of the border surrounding the component.

    Please Note: The users will be redirected to the Background gradient colors window by clicking the Gradient icon.

    Title

    • Title Box Color: Set the color of the title box to complement your chart's overall design.

    • Show Title Box: Toggle this option to display or hide the title box around the title text.

    • Show Title: Enable or disable the title visibility on your chart.

    • Title Bar Height: Adjust the title bar height to fit your design specifications.

    Subtitle

    • Show Sub Title: Enable or disable the display of the sub-title text.

    • Description: Add a description text below the sub-title.

    • Font Color: Select the color of the sub-title text.

    • Font Size: Specify the size of the sub-title text.

    Header Style

    The Header Style section allows for customization of the header in your design. You can modify the following fields:

    • Header Text Color: Set the color of the header text to align with your theme.

    • Font Size: Define the text size in the header for visibility and emphasis.

    • Font Style: Choose a style such as italic or normal to enhance the header's appearance.

    • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

    Row Style

    • Font Color: This property allows users to change the color of the text within a row, enabling better visibility and alignment with design aesthetics.

    • Font Size: Adjusts the size of the text, enhancing readability and fitting within the design requirements.

    • Font Style: Offers options such as italic or normal, providing stylistic flexibility for the text within the data grid.

    • Font Weight

    Styles

    The users can set various display styles for the data grid using these fields.

    • Roll Over Color: The Roll Over Color property allows customization of the color change when a user hovers over an interface element. This provides visual feedback and helps highlight interactive components.

    • Selection Color: The Selection Color property determines the color displayed when an element or text is selected. It helps distinguish the selected items from the rest, facilitating easier navigation and interaction.

    • Horizontal Grid Lines: The Horizontal Grid Lines property allows users to enable or disable horizontal lines across the interface. These lines can aid in aligning and organizing content effectively, and their color can be customized to blend with the overall design.

    Export Options

    • Enable Context Menu: Activate a right-click context menu for quick access to export options in the preview mode of the chart.

    • Export Excel: Save the chart data in an Excel file format (.xlsx).

    • Export CSV: Export the chart data into a CSV file format (.csv).

    • Export JPEG: Export the chart as a JPEG image (.jpg).

    The user can enable the Enable Context Menu from the preview section to download the reports in different formats.

    How the Fit Columns field works in the Paging Grid?

    The Fit Columns field has been provided to the Paging Gird component.

    • The user can't avail the horizontal scroll for the Paging Grid component if the Fit Columns field is enabled.

    Check out the given walk-through on how the Fit Columns field works for the Paging Grid component.

    Property Tab for Dataset Pallet

    Page Grids variants after Changes in Property:

    • Page Grid without Conditions

    • Page Grid with Conditions

      ​

    Please Note:

    • The user needs to select the Column Type as Numeric for the selected Data Grid fields using the Properties tab provided for the Dataset, so they become responsive to the changes that the user sets using the Indicator tab.

    Spider Chart

    The Spider chart also known as the 'Radar chart' can plot values of each category along the axis that starts at the center of the chart and extends up to the end of the radius. It is a two-dimensional chart type designed to plot one or more series of values arranged in the form of spokes.

    Check out the walk-through on how to use the Spider chart component in the Designer module.

    Using Spider chart

    Best Situations to Use a Spider chart

    • To analyze performance areas in an organization.

    • To compare allocated values and spending analysis in different departments.

    Default Spider Chart Image

    Properties of the Spider Chart

    General

    • Component Name: Set a unique name for the component identification. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left: The horizontal position of the chart on the interface.

    • Top: The vertical position of the chart on the interface.

    • Height: The chart's vertical dimension.

    Tooltip

    • Show Tool Tip: The user can show the series description and get the tooltip by clicking the Show Tool Tip option.

      • The Tool Tip Configuration window opens.

      • Select any Tool Tip option. The supported Tool Tip options are None and Default.

    • Background Color: Set the background color for the tooltip box to enhance readability.

    • Opacity: Adjust the transparency level of the tooltip background.

    • Border Color: Define the color of the border surrounding the tooltip box.

    • Tooltip Font Size: Specify the font size for the text displayed in the tooltip.

    Please Note: To use the Custom option for the Tool Tip configuration, please refer to the page.

    Background

    • Gradient Rotation: Adjust the angle of the gradient applied to the background, allowing for a dynamic visual transition between colors.

    • Opacity: Set the transparency level of the background, ranging from fully opaque to completely transparent.

    • Gradient: Enable or disable gradient colors in the background for depth and visual appeal.

    Title

    • Title Box Color: Choose the background color for the title box.

    • Show Title Box: Enable or disable the display of the title box on the chart.

    • Show Title: Enable or disable the display of the title text.

    • Title Bar Height: Set the height of the title bar.

    Please Note: The Title will be added from the mapped dataset by enabling the Show Dataset Description option.

    Sub Title

    The user can customize the Subtitle properties which include:

    • Show Subtitle: Toggle this option to display or hide the subtitle.

    • Description: Add a custom description for the subtitle.

    • Font Color: Change the color of the subtitle text.

    • Font Size: Adjust the size of the subtitle text.

    Legend

    The users can enable the internal legend if they want to show it and customize the font size, color, style, etc. for the enabled legend.

    • Show Legend: Toggle the visibility of the chart legend.

    • Font Color: Choose the font color for the legend text.

    • Font Weight: Determine the weight (boldness) of the legend text.

    • Font Size: Specify the size of the font for the legend text.

    Formatter

    • Unit: Define the unit of measurement for the values displayed in the chart.

    • Precision: Set the number of decimal places to display for numerical values.

    • Currency: Format the numbers as a currency with the appropriate symbol.

    • Position: Determine the position of the formatted value (e.g., Prefix or Suffix).

    Axis Labels

    • Font Color: Choose the color for the axis labels to enhance visibility and match the design theme.

    • Font Size: Set the font size of the axis labels to ensure readability.

    • Font Style: Select styles like italic or normal to give a distinct appearance to the axis labels.

    • Font Weight: Adjust the thickness of the text by choosing options like light, regular, or bold for emphasis.

    Export Options

    • Enable Context Menu: Activate a right-click context menu for quick access to export options in the preview mode of the chart.

    • Export Excel: Save the chart data in an Excel file format (.xlsx).

    • Export CSV: Export the chart data into a CSV file format (.csv).

    • Export JPEG: Export the chart as a JPEG image (.jpg).

    The user can get the Export Context Menu from the preview mode to download the reports in different export formats.

    Different Variants of Spider Charts

    Spider chart with Polygon Chart type and Web type Fill

    Spider chart with Circle Chart type and Web type Stroke

    Please Note: The user needs to set the opacity for the series field to approximately 0.5 to get the proper plotting of the selected data.

    Sample Data

    Download the given sample data and map it as mentioned below to plot your Spider Plot chart.

    Select the Department column as a Category field and Allocated_Budget as well as Actual_Spending columns as Series fields to plot the data.

    Circumplex Chart

    The Circumplex chart, also known as the Polar Area or Nightingale Rose chart, combines the Bar chart and Pie chart. The Circumplex chart can be drawn on a polar coordinate grid. Each category or interval in data is divided into equal segments on the radial chart. As per the denoted values, the distance of each segment from the center depends on a polar axis. Therefore, each ring from the center of the polar grid can be used as a scale to plot the segment size and represent a higher value. Each category can contain multiple sub-categories, with each sub-category represented by some angle of a disc section. The value of the corresponding sub-category is shown through the area. Users can adjust the area of each segment (based on data) by changing the radius in a Circumplex chart.

    Best Situation to Use a Circumplex Chart

    To display manifold data in the form of a two-dimensional chart of three or more measurable variables represented on axes starting from the same point.

    Project Timeline

    Check out the below given walk-through on how to use the Project Timeline chart component in Designer module.

    The Project Timeline is an interactive visualization chart to visualize data in time. The data items can take place on a single date or have a start and end date (a range). Users can easily move and zoom in on the timeline by using the drag-drop and scroll functionalities. The time scale on the axis is adjusted automatically, and it supports scales ranging from milliseconds to hours to days to years. The Project Timeline uses regular HTML DOM to render the timeline and items placed on the timeline. It allows for flexible customization using CSS styling.

    Scorecard

    A Scorecard component is similar to the Data Grid, where data can be displayed in a hierarchical format and setting alerts is possible.

    Best Situation to use Scorecard

    • When end-users need to view data in numerical format

  • Width: Defines the width of the chart.

  • Initial Visibility: Controls whether the chart is visible upon initial load.

  • Max Button: Allows the inclusion of a button to maximize the chart view.

  • Show Percentage: Enables the display of percentage values on the chart.

  • Series Colors: Customizes the colors for different series in the funnel chart.

  • Click the Save option to display Tool Tip in the default display.
  • Background Color: Choose a background color for the tooltip to enhance visibility and match your visual theme.

  • Opacity: Adjust the tooltip's transparency to ensure it doesn't obstruct important chart elements while remaining readable.

  • Border Color: Select a border color that complements the tooltip, ensuring clarity and contrast against the chart background.

  • Tooltip Font Size: Customize the font size to maintain readability, adapting it to the overall chart presentation.

  • Box Width: Define the width of the tooltip box to ensure it fits the content appropriately and maintains a neat appearance.

  • Precision: Set the numerical precision for data values displayed in the tooltip, aiding in clearer data interpretation.

  • Highlighter: Toggle the highlighter to emphasize specific data points on the chart, drawing user attention to crucial information.

  • Gradient
    icon to access the
    Background gradient colors
    dialog box.
  • Click the Add Color option to add multiple colors.

  • Click the Save option to apply the selected background colors.

  • Border: Add a border around the chart for a defined perimeter.

  • Border Color: Alter the border color to complement or contrast with the chart.

  • Border Radius: Round the corners of the chart border for a smoother look.

  • Shadow: Enable shadows to create depth and a 3D-like effect.

  • Shadow Color: Customize the shadow color to blend naturally with the chart.

  • Shadow Transparency: Adjust the transparency level to control the intensity of the shadow effect.

  • Description: Add a description text below the title.

  • Font Color: Select the color of the title text.

  • Font Size: Specify the size of the title text.

  • Font Style: Choose a Font style using the drop-down menu (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the title text from the given choices.

  • Align: Align the title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the title text.

  • Show Dataset Description: Enable or disable the dataset description in the title.

  • Font Style: Choose the font style for the Sub-title (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the sub-title text from the given choices.

  • Align: Align the sub-title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the sub-title text.

  • Font Family: Select the font family for the legend text.

  • Font Style: Choose the font style (e.g., italic) for the legend text.

  • Text Decoration: Add text decorations (e.g., underline) to the legend text.

  • Hide on Load: Determine if the legend should be hidden when the chart initially loads.

  • Number Formatter: Apply a specific notation or style to the numbers (e.g., Indian, International).

    Export PNG: Export the chart as a PNG image (.png).

  • Export PPT: Export the chart to a PowerPoint presentation (.pptx).

  • Export PDF: Export the chart as a PDF document (.pdf).

  • Show Print: Include an option to print the chart directly.

  • Export Heading: Add a custom heading to the exported file.

  • Export Sub Heading: Add a custom subheading to the exported file.

  • Export File Name: Specify the file name for the exported file/dashboard.

  • Global Export Type: Define the default export format using the drop-down (e.g., Screenshot, Tabular).

  • Tooltip (Default & Custom)
    8KB
    Sample Data_Funnel chart.xlsx
    Open
    Accessing the Export Context menu in the Preview mode
  • Width: Adjusts the width of the data grid to fit the desired display area.

  • Initial Visibility: Enable to ensure the Grid chart appears during the initial preview.

  • Max Button: Allows users to maximize the data grid view for better visualization and interaction.

  • Fit Columns: Automatically adjust the column sizes to fit the content by placing a checkmark.

  • Column Rearrange: Permits rearrangement of columns within the data grid for custom orders as per user preference.

  • Scroll View: Users can enable or disable this to manage the inclusion of scroll bars; 'Disable' is the default setting.

  • Gradient
    icon to access the
    Background gradient colors
    dialog box.
  • Click the Add Color option to add multiple colors.

  • Click the Save option to apply the selected background colors.

  • Border: Add a border around the chart for a defined perimeter.

  • Border Color: Alter the border color to complement or contrast with the chart.

  • Border Radius: Round the corners of the chart border for a smoother look.

  • Shadow: Enable shadows to create depth and a 3D-like effect.

  • Shadow Color: Customize the shadow color to blend naturally with the chart.

  • Shadow Transparency: Adjust the transparency level to control the intensity of the shadow effect.

  • Description: Provide an additional description for the chart title to offer more context.

  • Font Color: Choose the font color for the title to ensure readability and match your theme.

  • Font Size: Set the title's font size for optimal visibility and aesthetics.

  • Font Style: Select the font style (e.g., italic, bold) to enhance the title's appearance.

  • Font Weight: Modify the font weight to make the title text lighter or bolder.

  • Font Family: Pick a font family that aligns with your design theme for the title.

  • Align: Align the title text to the left, center, or right according to your layout needs.

  • Text Decoration: Apply text decorations to the title for emphasis (E.g., Underline).

  • Show Dataset Description: Enable or disable the dataset description in the title.

  • Font Style: Choose the font style for the Sub-title (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the sub-title text from the given choices.

  • Align: Align the sub-title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the sub-title text.

  • Font Family: Select a font family for the header that complements your overall design.

  • Use Field Color: Enable this option to apply a specific field color to the header background.

  • Background Color: Change the header's background color to match or contrast with the text.

  • Text Decoration: Apply decorative elements like Underline to the header text for additional styling.

  • : Controls the thickness of the text, from normal to bold, helping users emphasize specific data points.
  • Font Family: Allows selection of different font families, ensuring the grid text aligns with overall design standards.

  • Text Decoration: Includes options such as underline, overline, or line-through, offering additional stylistic choices for the text.

  • Text Wrap: Enables text to wrap within the cell, ensuring complete visibility without affecting the row width.

  • Row Height: Users can increase or decrease the height of rows to accommodate more content or improve the grid's appearance.

  • Horizontal Line Color: The Horizontal Line Color refers to the color of the horizontal grid lines that can be displayed across the interface. This color can be customized to fit the design palette of the application seamlessly.

  • Vertical Line Color: The Vertical Line Color is the color assigned to the vertical grid lines. Users can adjust this color to help differentiate vertical separations on the interface, enhancing visual organization.

  • Grid Colors: Grid Colors encompass horizontal and vertical line colors, offering comprehensive customization options for both components. Adjusting these colors allows users to create a coordinated look that complements the interface design.

  • Export PNG: Export the chart as a PNG image (.png).

  • Export PPT: Export the chart to a PowerPoint presentation (.pptx).

  • Export PDF: Export the chart as a PDF document (.pdf).

  • Show Print: Include an option to print the chart directly.

  • Export Heading: Add a custom heading to the exported file.

  • Export Sub Heading: Add a custom subheading to the exported file.

  • Export File Name: Specify the file name for the exported file/dashboard.

  • Global Export Type: Define the default export format using the drop-down (e.g., Screenshot, Tabular).

    • Refer to the Alerts in Grids page under the Configurations section to understand how to insert Alerts in a Grid component.

    Rearrange Column Property in the Data Grid component
  • Max Button: Enable to allow maximization of the chart independently.

  • Series Colors: Customize the colors for each slice in the pie chart.

  • Opacity: Adjust the transparency of the pie chart elements.

  • Chart Type: Choose between Pie, Doughnut, or Semi Doughnut chart styles.

  • Show Percentage: Option to display the percentage values on slices.

  • Animation: Add transitions or animation effects to the pie chart.

  • Show Limited Slices: Limit the number of slices displayed on the chart.

  • Maximum Slices: Define the number of slices to be shown when limited.

  • Doughnut Width: Change the width of the Doughnut-style chart.

  • Chart Alignment: Align the chart within its space (e.g., center, left, right).

  • Actions: Access additional actions like 'show data', 'sort data', 'export', and 'chart' in the preview mode.

  • Click the Save option.

    Box Width: Determine the width of the tooltip box for optimal presentation.

  • Precision: Set the number of decimal places to show in the tooltip for numerical values.

  • Gradient
    icon to access the
    Background gradient colors
    dialog box.
  • Click the Add Color option to add multiple colors.

  • Click the Save option to apply the selected background colors.

  • Border: Add a border around the chart for a defined perimeter.

  • Border Color: Alter the border color to complement or contrast with the chart.

  • Border Radius: Round the corners of the chart border for a smoother look.

  • Shadow: Enable shadows to create depth and a 3D-like effect.

  • Shadow Color: Customize the shadow color to blend naturally with the chart.

  • Shadow Transparency: Adjust the transparency level to control the intensity of the shadow effect.

  • Description: Add a description text below the title.

  • Font Color: Select the color of the title text.

  • Font Size: Specify the size of the title text.

  • Font Style: Choose the font style (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the title text from the given choices.

  • Align: Align the title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the title text.

  • Show Dataset Description: Enable or disable the dataset description in the title.

  • Font Style: Select the style of the subtitle text (e.g., italic or normal).

  • Font Weight: Define the weight (boldness) of the subtitle font, with options such as Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the subtitle text from the available options.

  • Align: Align the subtitle text (e.g., left, center, right).

  • Text Decoration: Apply decorations, such as underlining, to the subtitle text.

  • Font Family: Choose the font family for the legend text from the available options.

  • Font Style: Choose the style for the legend text, such as italic or normal.

  • Text Decoration: Apply decorations like underlining to the legend text.

  • Hide on Load: Determine if the legend should be hidden initially when the chart loads.

  • Number Formatter: Customize how numbers are displayed (International or Indian).

  • : Provides the option to export the chart as a JPEG image, useful for creating static visual representations.
  • Export PNG: Similar to JPEG, but offers a lossless export option in PNG format for clearer image quality in visual presentations.

  • Export PPT: Facilitates exporting the chart directly into a PowerPoint file, streamlining the process of incorporating charts into slideshows.

  • Export PDF: Enables exporting the chart and its data in PDF format, suitable for creating shareable and print-ready documents.

  • Show Print: Displays a print button on the chart, allowing users to print the chart directly from the application.

  • Export Heading: Customizes the heading title for exported files, ensuring clarity and context when distributing chart data.

  • Export Sub Heading: Adds a secondary title or description to exported files, providing additional context or information.

  • Export File Name: Allows customization of the file name for the exported data, ensuring easy identification and organization.

  • Global Export Type: Sets a default export format for all charts, streamlining the export process across multiple datasets.

  • Tooltip (Default & Custom)
    8KB
    Sample Data_Pie & Doughnut chart.xlsx
    Open
    Doughnut Pie chart
    Semi-Doughnut Pie chart

    Width: Defines the horizontal size of the component.

  • Initial Visibility: Controls whether the component is visible when the page first loads.

  • Max Button: Allows users to maximize the component to full screen.

  • Fit Columns: Adjusts the column widths automatically to fit the content or available space.

  • Border Color: Sets the color of the component’s border.

  • Border Radius: Rounds the corners of the component’s border.

  • Shadow: Adds a shadow effect beneath the component.

  • Shadow Color: Defines the color of the shadow.

  • Shadow Transparency: Adjusts the visibility of the shadow, affecting how pronounced it appears.

  • Description: Provide an additional description for the chart title to offer more context.

  • Font Color: Choose the font color for the title to ensure readability and match your theme.

  • Font Size: Set the title's font size for optimal visibility and aesthetics.

  • Font Style: Select the font style (e.g., italic, bold) to enhance the title's appearance.

  • Font Weight: Modify the font weight to make the title text lighter or bolder.

  • Font Family: Pick a font family that aligns with your design theme for the title.

  • Align: Align the title text to the left, center, or right according to your layout needs.

  • Text Decoration: Apply text decorations to the title for emphasis (E.g., Underline).

  • Show Dataset Description: Enable or disable the dataset description in the title.

  • Font Style: Choose the font style for the Sub-title (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the sub-title text from the given choices.

  • Align: Align the sub-title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the sub-title text.

  • Font Family: Select a font family for the header that complements your overall design.

  • Use Field Color: Enable this option to apply a specific field color to the header background.

  • Background Color: Change the header's background color to match or contrast with the text.

  • Text Decoration: Apply decorative elements like Underline to the header text for additional styling.

  • : Controls the thickness of the text, from normal to bold, helping users emphasize specific data points.
  • Font Family: Allows selection of different font families, ensuring the grid text aligns with overall design standards.

  • Text Decoration: Includes options such as underline, overline, or line-through, offering additional stylistic choices for the text.

  • Text Wrap: Enables text to wrap within the cell, ensuring complete visibility without affecting the row width.

  • Row Height: Users can increase or decrease the height of rows to accommodate more content or improve the grid's appearance.

  • Horizontal Line Color: The Horizontal Line Color refers to the color of the horizontal grid lines that can be displayed across the interface. This color can be customized to fit the design palette of the application seamlessly.

  • Vertical Line Color: The Vertical Line Color is the color assigned to the vertical grid lines. Users can adjust this color to help differentiate vertical separations on the interface, enhancing visual organization.

  • Grid Colors: Grid Colors encompass horizontal and vertical line colors, offering comprehensive customization options for both components. Adjusting these colors allows users to create a coordinated look that complements the interface design.

  • Pagination Bar Color: The Pagination Bar Color property allows customization of the color of the pagination bar. This feature helps maintain consistency with the application's design by aligning the pagination bar's color with the overall theme.

  • Pagination Font Color: This setting enables users to change the color of the text displayed on the pagination controls. Adjusting the font color can enhance legibility and ensure it complements the pagination bar color.

  • Row Count: The Row Count field allows users to specify the number of rows to be displayed per page in the data grid. This feature aids in enhancing data navigation and offers users control over how much data they wish to view at one time.

  • Export PNG: Export the chart as a PNG image (.png).

  • Export PPT: Export the chart to a PowerPoint presentation (.pptx).

  • Export PDF: Export the chart as a PDF document (.pdf).

  • Show Print: Include an option to print the chart directly.

  • Export Heading: Add a custom heading to the exported file.

  • Export Sub Heading: Add a custom subheading to the exported file.

  • Export File Name: Specify the file name for the exported file/dashboard.

  • Global Export Type: Define the default export format using the drop-down (e.g., Screenshot, Tabular).

  • The user
    can avail horizontal scroll
    for the Paging grid component, if the
    Fit Columns field is disabled
    from the General Properties of the component.
    • Refer to the Alerts in Grids page under the Configurations section to understand how to insert Alerts in a Grid component.

    Explaining the Fit to column option for the Paging Grid

    Width: The chart's horizontal dimension.

  • Initial Visibility: Determines if the chart is visible upon initial preview.

  • Max Button: Allows maximization of the chart if enabled.

  • Color From Drill: Adjusts the color scheme based on drilled data.

  • Points: Enable this option to plot the data points on the chart.

  • Chart Type: Choose between a Polygon and a Circle for the shape of the spider chart.

  • Web Type: Defines the web style between Fill and Stroke.

  • Axis Color: Sets the color of the chart's axes.

  • Actions: Custom actions that can be associated with the chart such as sorting, exporting, and displaying data in the tabular format will be listed in the preview mode of the chart.

  • Animation: Enables animated transitions for the chart.

  • Click the Save option.

    Box Width: Determine the width of the tooltip box for optimal presentation.

  • Precision: Set the number of decimal places to show in the tooltip for numerical values.

  • Highlighter: Toggle the highlighter to emphasize specific data points on the chart, drawing user attention to crucial information.

  • Click the Gradient icon to access the Background gradient colors dialog box.
  • Click the Add Color option to add multiple colors.

  • Click the Save option to apply the selected background colors.

  • Border: Define the width of the border surrounding the pyramid chart.

  • Border Color: Select the color for the chart's border, enhancing its visibility and aesthetics.

  • Border Radius: Round the corners of the chart's border for a softer, more modern appearance.

  • Shadow: Enable a shadow effect for the background to add dimension and focus to the chart.

  • Shadow Color: Choose the color of the shadow cast by the chart background.

  • Shadow Transparency: Adjust the transparency level of the shadow to control its prominence and intensity.

  • Description: Add the title text.

  • Font Color: Select the color of the title text.

  • Font Size: Specify the size of the title text.

  • Font Style: Choose the font style (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the title text from the given choices.

  • Align: Align the title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the title text.

  • Show Dataset Description: Enable or disable the dataset description in the title.

  • Font Style: Apply styles such as italics to the subtitle.

  • Font Weight: Modify the thickness of the subtitle text, e.g., bold.

  • Font Family: Select the font type for the subtitle.

  • Align: Align the subtitle text (left, center, or right).

  • Text Decoration: Add elements like underline or overline to the subtitle text.

  • Font Family: Select the font family for the legend text.

  • Font Style: Choose the font style (e.g., italic) for the legend text.

  • Text Decoration: Add text decorations (e.g., underline) to the legend text.

  • Hide on Load: Determine if the legend should be hidden when the chart initially loads.

  • Number Formatter: Apply a specific notation or style to the numbers (e.g., Indian, International).

  • Font Family: Choose the typeface to maintain consistency with the overall design and branding.

  • Export PNG: Export the chart as a PNG image (.png).

  • Export PPT: Export the chart to a PowerPoint presentation (.pptx).

  • Export PDF: Export the chart as a PDF document (.pdf).

  • Show Print: Include an option to print the chart directly.

  • Export Heading: Add a custom heading to the exported file.

  • Export Sub Heading: Add a custom subheading to the exported file.

  • Export File Name: Specify the file name for the exported file/dashboard.

  • Global Export Type: Define the default export format using the drop-down (e.g., Screenshot, Tabular).

  • Tooltip (Default & Custom)
    8KB
    Sample Data_Spider chart.xlsx
    Open
    Default Chart Image

    The Properties of Circumplex Chart

    General

    • Component Name: Sets the unique identifier for the chart component. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left: Specifies the horizontal offset of the chart within the display area.

    • Top: Specifies the vertical offset of the chart within the display area.

    • Height: Determines the height of the chart in the display.

    • Width: Determines the width of the chart in the display.

    • Initial Visibility: Controls whether the chart is visible on the initial load.

    • Max Button: Enables or disables the button for maximizing the chart.

    • Color From Drill: Option to use colors derived from drilled-down data.

    • Use Series Colors: Allows the use of predefined series colors for the chart.

    • Series Colors: Specifies the color palette for series data representation.

    • Animation: Configures animation effects for displaying data transitions.

    • Clock Wise Direction: Sets the direction for chart data to be plotted clockwise.

    • Chart Type: Defines the type of chart to display (e.g., pie, radar).

    • Doughnut Width: Determines the width of the doughnut hole in related chart types.

    • Web Type: Chooses the structure style for web-like visuals.

    • Web Stroke Color: Specifies the outline color for web-like structures.

    • Category Stroke Color: Determines the color for category borders.

    Tooltip

    Tooltips enhance user interaction by displaying additional information about chart elements.

    • Show Tool Tip: Enable this option to display tooltips for the chart series, providing descriptions or data insights.

      • Click the Show Tool Tip icon to access the Tool Tip Configuration window.

      • Select the Default option.

      • Put a checkmark in the box to enable the component farmatter.

      • Click the Save option to display Tool Tip in the default display.

    • Background Color: Choose a background color for the tooltip to enhance visibility and match your visual theme.

    • Opacity: Adjust the tooltip's transparency to ensure it doesn't obstruct important chart elements while remaining readable.

    • Border Color: Select a border color that complements the tooltip, ensuring clarity and contrast against the chart background.

    • Tooltip Font Size: Customize the font size to maintain readability, adapting it to the overall chart presentation.

    • Box Width: Define the width of the tooltip box to ensure it fits the content appropriately and maintains a neat appearance.

    • Precision: Set the numerical precision for data values displayed in the tooltip, aiding in clearer data interpretation.

    • Highlighter: Toggle the highlighter to emphasize specific data points on the chart, drawing user attention to crucial information.

    Please Note: To use the Custom option for the Tool Tip configuration, please refer to the Tooltip (Default & Custom) page.

    Background

    • Gradient Rotation: Modify the angle of the gradient to achieve the desired effect.

    • Opacity: Set the transparency level to balance visibility and aesthetics.

    • Gradient: Choose and customize the gradient colors to match your theme.

      • Click the Gradient icon to access the Background gradient colors dialog box.

      • Click the Add Color option to add multiple colors.

      • Click the Save option to apply the selected background colors.

    • Border: Add a border around the chart for a defined perimeter.

    • Border Color: Alter the border color to complement or contrast with the chart.

    • Border Radius: Round the corners of the chart border for a smoother look.

    • Shadow: Enable shadows to create depth and a 3D-like effect.

    • Shadow Color: Customize the shadow color to blend naturally with the chart.

    • Shadow Transparency: Adjust the transparency level to control the intensity of the shadow effect.

    Title

    • Title Box Color: Choose the background color for the title box.

    • Show Title Box: Enable or disable the display of the title box on the chart.

    • Show Title: Enable or disable the display of the title text.

    • Title Bar Height: Set the height of the title bar.

    • Description: Add a description text below the title.

    • Font Color: Select the color of the title text.

    • Font Size: Specify the size of the title text.

    • Font Style: Choose a Font style using the drop-down menu (e.g., italic or normal).

    • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

    • Font Family: Choose the font family for the title text from the given choices.

    • Align: Align the title text (e.g., left, center, right).

    • Text Decoration: Apply text decorations (e.g., underline) to the title text.

    • Show Dataset Description: Enable or disable the dataset description in the title.

    Please Note: By enabling the Show Dataset Description option the Title will get added from the mapped dataset.

    Subtitle

    • Show Sub Title: Enable or disable the display of the sub-title text.

    • Description: Add a description text below the sub-title.

    • Font Color: Select the color of the sub-title text.

    • Font Size: Specify the size of the sub-title text.

    • Font Style: Choose the font style for the Sub-title (e.g., italic or normal).

    • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

    • Font Family: Choose the font family for the sub-title text from the given choices.

    • Align: Align the sub-title text (e.g., left, center, right).

    • Text Decoration: Apply text decorations (e.g., underline) to the sub-title text.

    Legend

    • Show Legend: Toggle the visibility of the chart legend.

    • Font Color: Choose the font color for the legend text.

    • Font Weight: Determine the weight (boldness) of the legend text.

    • Font Size: Specify the size of the font for the legend text.

    • Font Family: Select the font family for the legend text.

    • Font Style: Choose the font style (e.g., italic) for the legend text.

    • Text Decoration: Add text decorations (e.g., underline) to the legend text.

    • Hide on Load: Determine if the legend should be hidden when the chart initially loads.

    Formatter

    • Unit: Define the unit of measurement for the values displayed in the chart.

    • Precision: Set the number of decimal places to display for numerical values.

    • Currency: Format the numbers as a currency with the appropriate symbol.

    • Position: Determine the position of the formatted value (e.g., before or after the number).

    • Number Formatter: Apply a specific notation or style to the numbers (e.g., Indian, International).

    Axis Labels

    • Font Color: Choose the color for the text of your axis labels to ensure readability and match the chart's design.

    • Font Size: Set the size of the font for axis labels to maintain clarity and legibility.

    • Marker Font Size: Determine the size of the font for any markers on the axis, ensuring they are consistent with the overall font scheme.

    • Font Style: Select the style of the font (e.g., normal, italic) to align with the design aesthetics.

    • Font Weight: Adjust the thickness of the font (e.g., normal, bold) to enhance visibility and emphasis.

    • Font Family: Choose the typeface for the axis labels to maintain consistency with the chart's theme.

    Axis Setup

    • Auto Axis Setup: Automatically adjust the axis settings based on the dataset.

    • Base Zero: Ensure the axis starts at zero for better data comparison.

    • Min Value: Define the minimum value displayed on the axis.

    • Max Value: Set the maximum value for the axis range.

    Export Options

    • Enable Context Menu: Activate a right-click context menu for quick access to export options in the preview mode of the chart.

    • Export Excel: Save the chart data in an Excel file format (.xlsx).

    • Export CSV: Export the chart data into a CSV file format (.csv).

    • Export JPEG: Export the chart as a JPEG image (.jpg).

    • Export PNG: Export the chart as a PNG image (.png).

    • Export PPT: Export the chart to a PowerPoint presentation (.pptx).

    • Export PDF: Export the chart as a PDF document (.pdf).

    • Show Print: Include an option to print the chart directly.

    • Export Heading: Add a custom heading to the exported file.

    • Export Sub Heading: Add a custom subheading to the exported file.

    • Export File Name: Specify the file name for the exported file/dashboard.

    • Global Export Type: Define the default export format using the drop-down (e.g., Screenshot, Tabular).

    The user can get the Export Context Menu from the preview mode to download the reports in different export formats.

    Accessing the Export Context Menu in the Preview mode

    Variants of Circumplex chart

    After modifying the chart properties the user can the following variants of the Circumplex chart.

    Clustered Circumplex with Polygon Web Type (using Series Colors)

    Overlaid Circumplex with Circular Web Type (not using Series Colors)

    Sample Data

    Download the given sample data and map it as mentioned below to plot your Circumplex chart:

    • Use the Country column as a Category field, Region as a Sub Category, and the other columns as Series to plot data.

    Please Note: The Category field can be any data type line, string, or numeric. But, Series fields can be only numeric data type.

    9KB
    Sample Data_Circumplex chart.xlsx
    Open
    Best Situations to Use a Project Timeline chart

    To track project deadlines and status with the timeline template. To update status throughout the project

    Default Chart Image

    Properties of the Project Timeline chart

    General

    • Component Name: Set a unique name for the component identification. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left: Defines the horizontal position of the chart from the left margin.

    • Top: Specifies the vertical position of the chart from the top margin.

    • Height: Sets the height of the timeline chart.

    • Width: Determines the width of the timeline chart.

    • Initial Visibility: Configures the chart's visibility status on the initial load (visible or hidden).

    • Max Button: Boolean setting to enable or disable the maximize button for the chart view.

    • Date Formatting: Allows customization of the date display format on the timeline.

    Tooltip

    • Show Tool Tip: The user can show the series description and get the tooltip by clicking the Show Tool Tip option.

      • The Tool Tip Configuration window opens.

      • Select any Tool Tip option. The supported Tool Tip options are None and Default.

      • Click the Save option.

    • Background Color: Set the background color for the tooltip box to enhance readability.

    • Opacity: Adjust the transparency level of the tooltip background.

    • Border Color: Define the color of the border surrounding the tooltip box.

    • Tooltip Font Size: Specify the font size for the text displayed in the tooltip.

    • Box Width: Determine the width of the tooltip box for optimal presentation.

    • Precision: Set the number of decimal places to show in the tooltip for numerical values.

    Please Note: To use the Custom option for the Tool Tip configuration, please refer to the Tooltip (Default & Custom) page.

    Background

    The user can change the background color of the chart, get the border for the chart, and change the border color. Get the reflection of the chart by enabling the shadow option can also change the color, and increase or decrease the transparency of the shadow.

    • Gradient Rotation: Modify the angle of the gradient to achieve the desired effect.

    • Opacity: Set the transparency level to balance visibility and aesthetics.

    • Gradient: Choose and customize the gradient colors to match your theme.

      • Click the Gradient icon to access the Background gradient colors dialog box.

      • Click the Add Color option to add multiple colors.

      • Click the Save option to apply the selected background colors.

    • Border: Add a border around the chart for a defined perimeter.

    • Border Color: Alter the border color to complement or contrast with the chart.

    • Border Radius: Round the corners of the chart border for a smoother look.

    • Shadow: Enable shadows to create depth and a 3D-like effect.

    • Shadow Color: Customize the shadow color to blend naturally with the chart.

    • Shadow Transparency: Adjust the transparency level to control the intensity of the shadow effect.

    Timeline Styles

    • Timeline Position: Adjust the position of the timeline on the chart for better alignment.

    • Today Marker Color: Set the color of the marker that indicates the current date.

    • Today Marker Size: Determine the size of the today marker for better visibility.

    • Show Major Labels: Display major time labels for clear time segmentation.

    • Show Minor Labels: Include minor time labels for detailed time navigation.

    • Marker Border Color: Customize the border color of time markers to highlight them.

    • Font Color: Change the font color used in timeline labels for readability.

    • Font Size: Adjust the font size to optimize label visibility and prevent clutter.

    • Font Weight: Modify the font weight (e.g., bold) to emphasize certain labels.

    • Font Family: Select the font family to ensure style consistency across the chart.

    • Font Style: Choose from various font styles (e.g., italics) to align with design preferences.

    Milestone Styles

    • Milestone: Customize the appearance of milestones on the chart to highlight key events.

      • Click the Milestone icon.

      • The Milestone Properties window opens.

      • Add a new range by clicking the Add Range option.

      • Choose the color for each range.

      • Click the Save option.

    • Border Width: Set the border width of milestones for better definition.

    • Font Color: Adjust the font color for milestone labels to ensure readability.

    • Font Size: Change the font size for milestone labels to maintain clarity.

    • Font Weight: Modify the font weight (e.g., bold) to make milestone labels stand out.

    • Font Family: Choose a font family for milestone labels that complements the overall design.

    • Font Style: Select font styles (e.g., italics) for milestone labels to match the aesthetic preferences.

    Task Styles

    • Task: Customize the appearance of task boxes on the chart for improved visual distinction.

    • Show Overflow Text: Enable or disable text overflow settings to ensure task labels are evident without truncation.

    • Font Color: Change the font color used in task labels to enhance readability on the chart.

    • Font Size: Adjust the font size of task labels for clarity and to ensure they are legible at various zoom levels.

    • Font Weight: Modify the font weight (e.g., bold) to emphasize certain task labels.

    • Font Family: Select a font family for task labels that complements the overall chart design and maintains consistency.

    • Font Style: Choose from font styles (e.g., italics) to align task labels with the desired design aesthetic.

    Title

    • Title Box Color: Choose the background color for the title box.

    • Show Title Box: Enable or disable the display of the title box on the chart.

    • Show Title: Enable or disable the display of the title text.

    • Title Bar Height: Set the height of the title bar.

    • Description: Add a description text below the title.

    • Font Color: Select the color of the title text.

    • Font Size: Specify the size of the title text.

    • Font Style: Choose the font style (e.g., italic or normal).

    • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

    • Font Family: Choose the font family for the title text from the given choices.

    • Align: Align the title text (e.g., left, center, right).

    • Text Decoration: Apply text decorations (e.g., underline) to the title text.

    • Show Dataset Description: Enable or disable the dataset description in the title.

    Please Note: By enabling the Show Dataset Description option the Title will be added from the mapped dataset.

    Subtitle

    The user can customize the Subtitle properties which include:

    • Show Subtitle: Toggle this option to display or hide the subtitle.

    • Description: Add a custom description for the subtitle.

    • Font Color: Change the color of the subtitle text.

    • Font Size: Adjust the size of the subtitle text.

    • Font Style: Apply styles such as italics to the subtitle.

    • Font Weight: Modify the thickness of the subtitle text, e.g., bold.

    • Font Family: Select the font type for the subtitle.

    • Align: Align the subtitle text (left, center, or right).

    • Text Decoration: Add elements like underline or overline to the subtitle text.

    Export Options

    The Export Options section allows users to easily export their chart data in various formats for reporting and presentation purposes. This feature supports seamless integration with common applications and file types.

    • Enable Context Menu: Activates a context menu on the chart, providing quick access to export functions directly from the chart interface.

    • Export Excel: Allows the data to be exported as an Excel file, suitable for further analysis or sharing in a tabular format.

    • Export CSV: Exports data in CSV format, ideal for importing into databases or other data processing tools.

    • Export JPEG: Provides the option to export the chart as a JPEG image, useful for creating static visual representations.

    • Export PNG: Similar to JPEG, but offers a lossless export option in PNG format for clearer image quality in visual presentations.

    • Export PPT: Facilitates exporting the chart directly into a PowerPoint file, streamlining the process of incorporating charts into slideshows.

    • Export PDF: Enables exporting the chart and its data in PDF format, suitable for creating shareable and print-ready documents.

    • Show Print: Displays a print button on the chart, allowing users to print the chart directly from the application.

    • Export Heading: Customizes the heading title for exported files, ensuring clarity and context when distributing chart data.

    • Export Sub Heading: Adds a secondary title or description to exported files, providing additional context or information.

    • Export File Name: Allows customization of the file name for the exported data, ensuring easy identification and organization.

    • Global Export Type: Sets a default export format for all charts, streamlining the export process across multiple datasets.

    The user can get the Export Context Menu from the preview mode to download the reports in different export formats.

    Project Timeline chart by changing the Properties

    Sample Data

    Download the given sample data and map it as mentioned below to plot your Project Timeline chart.

    Use the Category column as the Category field, Start Date as the Start Date field, and End Date as the End Date to plot data.

    9KB
    Sample Data_Project Timeline.xlsx
    Open

    When alerts need to be shown.

  • When need to display hierarchies in data.

  • Variations

    Compare: A ‘Compare Value’ must be given by the user. Alerts are then triggered depending on it the data in the data set is greater, equal, or less than the compare value. (Ex. <50% = Red, 50%= Yellow, >50%= Green)

    Range: Alerts can be configured to trigger based on range value(s), (Ex. 0-40%, =Red, 41-50% Yellow, 51-59% Blue, 60-69 Green)

    Default Scorecard Chart Image

    Properties of the Scorecard Grid chart

    General

    • Component Name: Allows the user to assign a unique identifier to the chart component.

    • Left: Adjusts the horizontal position of the chart on the page.

    • Top: Controls the vertical placement of the chart within the display area.

    • Height: Sets the vertical dimension of the chart.

    • Width: Determines the horizontal dimension of the chart.

    • Initial Visibility: Determines whether the chart is visible upon the first preview.

    • Max Button: Enables or disables the option to maximize the chart.

    • Fit Columns: Configures the chart to adjust its columns for the best fit.

    • Hierarchy Level: Allows toggling between Multiple and Single hierarchy views.

    • Tree Field: Defines the field used to structure and organize the hierarchical tree view.

    Background

    • Gradient Rotation: Modify the angle of the gradient to achieve the desired effect.

    • Opacity: Set the transparency level to balance visibility and aesthetics.

    • Gradient: Choose and customize the gradient colors to match your theme.

      • Click the Gradient icon to access the Background gradient colors dialog box.

      • Click the Add Color option to add multiple colors.

      • Click the Save option to apply the selected background colors.

    • Border: Add a border around the chart for a defined perimeter.

    • Border Color: Alter the border color to complement or contrast with the chart.

    • Border Radius: Round the corners of the chart border for a smoother look.

    • Shadow: Enable shadows to create depth and a 3D-like effect.

    • Shadow Color: Customize the shadow color to blend naturally with the chart.

    • Shadow Transparency: Adjust the transparency level to control the intensity of the shadow effect.

    Title

    • Title Box Color: Set the color of the title box to complement your chart's overall design.

    • Show Title Box: Toggle this option to display or hide the title box around the title text.

    • Show Title: Enable or disable the title visibility on your chart.

    • Title Bar Height: Adjust the title bar height to fit your design specifications.

    • Description: Provide an additional description for the chart title to offer more context.

    • Font Color: Choose the font color for the title to ensure readability and match your theme.

    • Font Size: Set the title's font size for optimal visibility and aesthetics.

    • Font Style: Select the font style (e.g., italic, bold) to enhance the title's appearance.

    • Font Weight: Modify the font weight to make the title text lighter or bolder.

    • Font Family: Pick a font family that aligns with your design theme for the title.

    • Align: Align the title text to the left, center, or right according to your layout needs.

    • Text Decoration: Apply text decorations to the title for emphasis (E.g., Underline).

    • Show Dataset Description: Enable or disable the dataset description in the title.

    Subtitle

    • Show Sub Title: Enable or disable the display of the sub-title text.

    • Description: Add a description text below the sub-title.

    • Font Color: Select the color of the sub-title text.

    • Font Size: Specify the size of the sub-title text.

    • Font Style: Choose the font style for the Sub-title (e.g., italic or normal).

    • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

    • Font Family: Choose the font family for the sub-title text from the given choices.

    • Align: Align the sub-title text (e.g., left, center, right).

    • Text Decoration: Apply text decorations (e.g., underline) to the sub-title text.

    Header Style

    The Header Style section allows for customization of the header in your design. You can modify the following fields:

    • Header Text Color: Set the color of the header text to align with your theme.

    • Font Size: Define the text size in the header for visibility and emphasis.

    • Font Style: Choose a style such as italic or normal to enhance the header's appearance.

    • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

    • Font Family: Select a font family for the header that complements your overall design.

    • Use Field Color: Enable this option to apply a specific field color to the header background.

    • Background Color: Change the header's background color to match or contrast with the text.

    • Text Decoration: Apply decorative elements like Underline to the header text for additional styling.

    Row Style

    • Font Color: This property allows users to change the color of the text within a row, enabling better visibility and alignment with design aesthetics.

    • Font Size: Adjusts the size of the text, enhancing readability and fitting within the design requirements.

    • Font Style: Offers options such as italic or normal, providing stylistic flexibility for the text within the data grid.

    • Font Weight: Controls the thickness of the text, from normal to bold, helping users emphasize specific data points.

    • Font Family: Allows selection of different font families, ensuring the grid text aligns with overall design standards.

    • Text Decoration: Includes options such as underline, overline, or line-through, offering additional stylistic choices for the text.

    • Text Wrap: Enables text to wrap within the cell, ensuring complete visibility without affecting the row width.

    • Row Height: Users can increase or decrease the height of rows to accommodate more content or improve the grid's appearance.

    Styles

    • Roll Over Color: Define the background color that appears when the cursor hovers over an element, aiding in interactive feedback.

    • Selection Color: Set the background color for selected rows or elements, helping users easily identify selected items.

    • Horizontal Grid Lines: Enable or disable horizontal lines between rows to improve readability within the grid.

    • Horizontal Line Color: Choose a color for the horizontal grid lines, ensuring they align with the overall design theme.

    • Vertical Line Color: Set the color for vertical grid lines, allowing for clear separation of columns within the grid.

    • Grid Colors: Customize color for rows and alternate rows.

    Export Options

    • Enable Context Menu: Activate a right-click context menu for quick access to export options in the preview mode of the chart.

    • Export Excel: Save the chart data in an Excel file format (.xlsx).

    • Export CSV: Export the chart data into a CSV file format (.csv).

    • Export JPEG: Export the chart as a JPEG image (.jpg).

    • Export PNG: Export the chart as a PNG image (.png).

    • Export PPT: Export the chart to a PowerPoint presentation (.pptx).

    • Export PDF: Export the chart as a PDF document (.pdf).

    • Show Print: Include an option to print the chart directly.

    • Export Heading: Add a custom heading to the exported file.

    • Export Sub Heading: Add a custom subheading to the exported file.

    • Export File Name: Specify the file name for the exported file/dashboard.

    • Global Export Type: Define the default export format using the drop-down (e.g., Screenshot, Tabular).

    Property Tab for Dataset Properties Pallet

    The user needs to set the Hierarchy Type for the category columns. In this case, Country is set as Parent, and the Child hierarchy type is selected for the State and City columns.

    The user can also configure the properties for the numerical columns such as the Population column has been configured in the below-given images:

    Scorecard grid variants after changing its properties:

    Please Note:

    • The user needs to select the Column Type as Numeric for the selected Data Grid fields using the Properties tab provided for the Dataset, so they become responsive to the changes that the user sets using the Indicator tab.

    • Refer to the page under the section to understand how to insert Alerts in a Grid component.

    Alerts in Grids
    Configurations

    Pyramid Chart

    Check out the walk-through on how to use the Pyramid chart component in the Designer module.

    Pyramid charts are used when items need to be shown in a hierarchical structure. Generally, the chart will be a triangle sliced into no. of parts. The items and topics will be represented in a progressive order based on quantity and size.

    Best Situations to Use a Pyramid Chart

    Hierarchical Breakdown

    To represent levels of hierarchy in an organization or a process.

    Variations of this Chart

    Inverted Funnel Chart & Funnel Chart: This is just a reversed format of the Pyramid chart.

    Default Chart Image

    Properties of the Pyramid Chart

    General

    • Component Name: Set a unique name for the component identification. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left: Adjust the horizontal positioning of the chart on the canvas.

    • Top: Set the vertical positioning of the chart from the top edge.

    • Height: Determine the height of the chart in the layout.

    Background

    • Gradient Rotation: Adjust the angle of the gradient applied to the background, allowing for a dynamic visual transition between colors.

    • Opacity: Set the transparency level of the background, ranging from fully opaque to completely transparent.

    • Gradient: Enable or disable gradient colors in the background for depth and visual appeal.

    Tooltip

    • Show Tool Tip: The user can show the series description and get the tooltip by clicking the Show Tool Tip option.

      • The Tool Tip Configuration window opens.

      • Select any Tool Tip option. The supported Tool Tip options are None and Default.

    Title

    • Title Box Color: Choose the background color for the title box.

    • Show Title Box: Enable or disable the display of the title box on the chart.

    • Show Title: Enable or disable the display of the title text.

    • Title Bar Height: Set the height of the title bar.

    Please Note: The Title will be added from the mapped dataset by enabling the Show Dataset Description option.

    Subtitle

    The user can customize the Subtitle properties which include:

    • Show Subtitle: Toggle this option to display or hide the subtitle.

    • Description: Add a custom description for the subtitle.

    • Font Color: Change the color of the subtitle text.

    • Font Size: Adjust the size of the subtitle text.

    Legend

    • Show Legend: Toggle the visibility of the chart legend.

    • Font Color: Choose the font color for the legend text.

    • Font Weight: Determine the weight (boldness) of the legend text.

    • Font Size: Specify the size of the font for the legend text.

    Formatter

    • Unit: Specify the unit of measuring currency represented on the chart.

    • Precision: Define the number of decimal places to be displayed for numerical values to ensure accuracy and consistency.

    • Currency: Set the currency type for monetary values, allowing for consistent financial data representation.

    • Position: Determine the placement of the formatted value about the axis or chart element, such as Prefix or Suffix.

    Export Options

    The Export Options section allows users to easily export their chart data in various formats for reporting and presentation purposes. This feature supports seamless integration with common applications and file types.

    • Enable Context Menu: Activates a context menu on the chart, providing quick access to export functions directly from the chart interface.

    • Export Excel: Allows the data to be exported as an Excel file, suitable for further analysis or sharing in a tabular format.

    • Export CSV: Exports data in CSV format, ideal for importing into databases or other data processing tools.

    • Export JPEG

    The user can get the Export Context Menu from the preview mode to download the reports in different export formats.

    Pyramid Timeline chart by changing the Properties

    Sample Data

    Download the given sample data and map it as mentioned below to plot your Pyramid chart.

    Use the Stage column as the Category field, and the Count column as the Series field to plot data.

    Waterfall Chart

    A Waterfall Chart is a form of data visualization that helps in understanding the cumulative effect of sequentially introduced positive or negative values. The waterfall chart is also known as a flying bricks chart or Mario chart due to the apparent suspension of columns (bricks) in mid-air. The Waterfall Chart is used to show how an initial value is increased and decreased by a series of intermediate values, leading to a final value.

    Best Situations to Use Waterflow chart

    To show incremental changes in the values over time.

  • Width: Specify the width of the chart to resize it accordingly.

  • Initial Visibility: Control whether the chart is visible when the page loads.

  • Max Button: Enable a button to maximize the chart's view.

  • Show Percentage: Display the percentage of each segment in the pyramid chart.

  • Series Colors: Customize the colors used for different series within the chart to enhance visual distinction.

  • Click the Gradient icon to access the Background gradient colors dialog box.
  • Click the Add Color option to add multiple colors.

  • Click the Save option to apply the selected background colors.

  • Border: Define the width of the border surrounding the pyramid chart.

  • Border Color: Select the color for the chart's border, enhancing its visibility and aesthetics.

  • Border Radius: Round the corners of the chart's border for a softer, more modern appearance.

  • Shadow: Enable a shadow effect for the background to add dimension and focus to the chart.

  • Shadow Color: Choose the color of the shadow cast by the chart background.

  • Shadow Transparency: Adjust the transparency level of the shadow to control its prominence and intensity.

  • Click the Save option.

  • Background Color: Set the background color for the tooltip box to enhance readability.

  • Opacity: Adjust the transparency level of the tooltip background.

  • Border Color: Define the color of the border surrounding the tooltip box.

  • Tooltip Font Size: Specify the font size for the text displayed in the tooltip.

  • Box Width: Determine the width of the tooltip box for optimal presentation.

  • Precision: Set the number of decimal places to show in the tooltip for numerical values.

  • Highlighter: Use color indicators to highlight specific bars or data points within the tooltip, facilitating quick visual recognition.

  • Description: Add the title text.

  • Font Color: Select the color of the title text.

  • Font Size: Specify the size of the title text.

  • Font Style: Choose the font style (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the title text from the given choices.

  • Align: Align the title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the title text.

  • Show Dataset Description: Enable or disable the dataset description in the title.

  • Font Style: Apply styles such as italics to the subtitle.

  • Font Weight: Modify the thickness of the subtitle text, e.g., bold.

  • Font Family: Select the font type for the subtitle.

  • Align: Align the subtitle text (left, center, or right).

  • Text Decoration: Add elements like underline or overline to the subtitle text.

  • Font Family: Select the font family for the legend text.

  • Font Style: Choose the font style (e.g., italic) for the legend text.

  • Text Decoration: Add text decorations (e.g., underline) to the legend text.

  • Hide on Load: Determine if the legend should be hidden when the chart initially loads.

  • Number Formatter: Customize how numbers are displayed (International or Indian).

  • : This option allows exporting the chart as a JPEG image to create static visual representations.
  • Export PNG: Similar to JPEG, but offers a lossless export option in PNG format for clearer image quality in visual presentations.

  • Export PPT: Facilitates exporting the chart directly into a PowerPoint file, streamlining the process of incorporating charts into slideshows.

  • Export PDF: Enables exporting the chart and its data in PDF format, which is suitable for creating shareable and print-ready documents.

  • Show Print: Displays a print button on the chart, allowing users to print the chart directly from the application.

  • Export Heading: Customizes the heading title for exported files, ensuring clarity and context when distributing chart data.

  • Export Sub Heading: Adds a secondary title or description to exported files, providing additional context or information.

  • Export File Name: Allows customization of the file name for the exported data, ensuring easy identification and organization.

  • Global Export Type: Sets a default export format for all charts, streamlining the export process across multiple datasets.

  • 8KB
    Sample Data_Pyramid chart.xlsx
    Open
    Default Chart Image

    Properties of the Waterfall Chart

    General

    The General Properties panel allows you to modify the core attributes of the Bar chart. Here are the fields available:

    • Component Name: Set a unique name for the component identification. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left: Specify the left position coordinate of the chart component on the canvas.

    • Top: Indicate the top position coordinate for the chart placement.

    • Height: Set the height of the chart to determine its vertical size.

    • Width: Adjust the width of the chart to control its horizontal dimension.

    • Initial Visibility: Enable to ensure the chart appears during the initial preview.

    • Max Button: Enable or disable the max button to allow users to maximize the chart for a more detailed view.

    • Color From Drill: Enable this option to choose whether the colors displayed should derive from drill-down operations.

    • Base Type: Select the base type for bar categorization in the chart.

    • Positive Color: Select the color representing positive values in the chart, making it visually distinct and easy to identify growth or profit.

    • Negative Color: Choose the color for negative values, highlighting losses or decreases consistently.

    • Total Color: Define the color for the total value, ensuring it stands out distinctly from individual positive or negative values.

    • Net Column Name: Specify the column name representing the calculated net values, allowing for clear identification and understanding of the presented data.

    • Bar Size: Configure the size of each bar to adjust spacing and appearance.

    Tooltip

    • Show Tool Tip: The user can show the series description and get the tooltip by clicking the Show Tool Tip option.

      • The Tool Tip Configuration window opens.

      • Select any Tool Tip option. The supported Tool Tip options are None and Default.

      • Click the Save option.

    • Background Color: Set the background color for the tooltip box to enhance readability.

    • Opacity: Adjust the transparency level of the tooltip background.

    • Border Color: Define the color of the border surrounding the tooltip box.

    • Tooltip Font Size: Specify the font size for the text displayed in the tooltip.

    • Box Width: Determine the width of the tooltip box for optimal presentation.

    • Precision: Set the number of decimal places to show in the tooltip for numerical values.

    • Highlighter: Toggle the highlighter to emphasize specific data points on the chart, drawing user attention to crucial information.

    Please Note: To use the Custom option for the Tool Tip configuration, please refer to the Tooltip (Default & Custom) page.

    Background

    • Gradient Rotation: Adjust the angle of the gradient applied to the background, allowing for a dynamic visual transition between colors.

    • Opacity: Set the transparency level of the background, ranging from fully opaque to completely transparent.

    • Gradient: Enable or disable gradient colors in the background for depth and visual appeal.

      • Click the Gradient icon to access the Background gradient colors dialog box.

      • Click the Add Color option to add multiple colors.

      • Click the Save option to apply the selected background colors.

    • Border: Define the width of the border surrounding the pyramid chart.

    • Border Color: Select the color for the chart's border, enhancing its visibility and aesthetics.

    • Border Radius: Round the corners of the chart's border for a softer, more modern appearance.

    • Shadow: Enable a shadow effect for the background to add dimension and focus to the chart.

    • Shadow Color: Choose the color of the shadow cast.

    • Shadow Transparency: Adjust the transparency level of the shadow to control its prominence and intensity.

    Title

    • Title Box Color: Choose the background color for the title box.

    • Show Title Box: Enable or disable the display of the title box on the chart.

    • Show Title: Enable or disable the display of the title text.

    • Title Bar Height: Set the height of the title bar.

    • Description: Add the title text.

    • Font Color: Select the color of the title text.

    • Font Size: Specify the size of the title text.

    • Font Style: Choose the font style (e.g., italic or normal).

    • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

    • Font Family: Choose the font family for the title text from the given choices.

    • Align: Align the title text (e.g., left, center, right).

    • Text Decoration: Apply text decorations (e.g., underline) to the title text.

    • Show Dataset Description: Enable or disable the dataset description in the title.

    Please Note: The Title will be added from the mapped dataset by enabling the Show Dataset Description option.

    Subtitle

    The user can customize the Subtitle properties which include:

    • Show Subtitle: Toggle this option to display or hide the subtitle.

    • Description: Add a custom description for the subtitle.

    • Font Color: Change the color of the subtitle text.

    • Font Size: Adjust the size of the subtitle text.

    • Font Style: Apply styles such as italics to the subtitle.

    • Font Weight: Modify the thickness of the subtitle text, e.g., bold.

    • Font Family: Select the font type for the subtitle.

    • Align: Align the subtitle text (left, center, or right).

    • Text Decoration: Add elements like underline or overline to the subtitle text.

    X-Axis

    • Show X-Axis Line: Toggle the visibility of the x-axis line.

    • X-Axis Line Color: Select the color for the x-axis line.

    • Label Font Color: Set the color of the x-axis labels.

    • Label Font Size: Adjust the font size used for x-axis labels.

    • Label Font Style: Choose the style (e.g., italic, oblique) for label text.

    • Label Font Weight: Define the thickness of the label text.

    • Label Font Family: Select the font type for the labels.

    • Label Decoration: Add text decorations such as underlining to labels.

    • Label Rotation: Specify the angle for rotating x-axis labels.

    • Tilted Label: Enable this to tilt labels for better visibility.

    • Description: Provide a brief description or title for the x-axis.

    • Font Color: Pick a color for the x-axis text elements.

    • Font Size: Change the overall size of text on the x-axis.

    • Font Style: Set the text style for x-axis elements (e.g., normal, italic).

    • Font Weight: Modify the boldness of the text on the x-axis.

    • Font Family: Define the typeface for text along the x-axis.

    • Text Decoration: Apply decorative styles like underlining to x-axis text.

    • Category Tick Marks: Control the appearance and frequency of tick marks on the x-axis.

    • Marker Color: Choose a color for the markers along the x-axis.

    • Show Dataset Description: Enable or disable the dataset description for the X-Axis.

    Y-Axis

    • Show Y-Axis Line: Toggle the visibility of the Y-axis line.

    • Y-Axis Line Color: Select the color for the Y-axis line.

    • Label Font Color: Choose the font color for Y-axis labels.

    • Label Font Size: Specify the size of the font for Y-axis labels.

    • Label Font Style: Set the style (e.g., italic) for Y-axis labels.

    • Label Font Weight: Determine the weight (e.g., bold) for Y-axis label fonts.

    • Label Font Family: Choose the font family for Y-axis labels.

    • Label Decoration: Add decorations (e.g., underline) to Y-axis labels.

    • Description: Add a description for the Y-axis.

    • Font Color: Specify the color of the Y-axis text.

    • Font Size: Set the font size for the Y-axis text.

    • Font Style: Choose the font style (e.g., italic) for Y-axis text.

    • Font Weight: Determine the weight (boldness) of the Y-axis text.

    • Font Family: Select the font family for the Y-axis text.

    • Text Decoration: Add text decorations (e.g., underline) to the Y-axis labels.

    • Show Dataset Description: Enable or disable the dataset description for the Y-Axis.

    Legend

    The users can enable the internal legend if they want to show it and customize the font size, color, style, etc. for the enabled legend.

    • Show Legend: Toggle the visibility of the chart legend.

    • Font Color: Choose the font color for the legend text.

    • Font Weight: Determine the weight (boldness) of the legend text.

    • Font Size: Specify the size of the font for the legend text.

    • Font Family: Select the font family for the legend text.

    • Font Style: Choose the font style (e.g., italic) for the legend text.

    • Text Decoration: Add text decorations (e.g., underline) to the legend text.

    • Hide on Load: Determine if the legend should be hidden when the chart initially loads.

    Formatter

    • Unit: Define the unit of measurement for the values displayed in the chart.

    • Precision: Set the number of decimal places to display for numerical values.

    • Currency: Format the numbers as a currency with the appropriate symbol.

    • Position: Determine the position of the formatted value (e.g., Prefix or Suffix).

    • Number Formatter: Apply a specific notation or style to the numbers (e.g., Indian, International).

    Axis Setup

    • Auto Axis Setup: Automatically adjust the axis settings based on the dataset.

    • Base Zero: Ensure the axis starts at zero for better data comparison.

    • Min Value: Define the minimum value displayed on the axis.

    • Max Value: Set the maximum value for the axis range.

    • Horizontal Marker Line: Add a horizontal line at a specified value for reference.

    • Vertical Marker Line: Place a vertical line at a specific point for highlighting.

    • Zero Marker Line: Include a line at zero to emphasize the baseline.

    • Zero Marker Color: Customize the color of the zero marker line.

    • Color: Choose the color for the axis and labels.

    • Opacity: Adjust the transparency of the axis and markers.

    Export Options

    • Enable Context Menu: Activate a right-click context menu for quick access to export options in the preview mode of the chart.

    • Export Excel: Save the chart data in an Excel file format (.xlsx).

    • Export CSV: Export the chart data into a CSV file format (.csv).

    • Export JPEG: Export the chart as a JPEG image (.jpg).

    • Export PNG: Export the chart as a PNG image (.png).

    • Export PPT: Export the chart to a PowerPoint presentation (.pptx).

    • Export PDF: Export the chart as a PDF document (.pdf).

    • Show Print: Include an option to print the chart directly.

    • Export Heading: Add a custom heading to the exported file.

    • Export Sub Heading: Add a custom subheading to the exported file.

    • Export File Name: Specify the file name for the exported file/dashboard.

    • Global Export Type: Define the default export format using the drop-down (e.g., Screenshot, Tabular).

    The user can get the Export Context Menu from the preview mode to download the reports in different export formats.

    Dataset Property

    The users can map a dataset with the dragged Waterfall chart component, and map the data fields as displayed in the given image:

    Waterfall charts after changing its properties

    Base Type with Plain

    Base Type with Gradient 1

    Base Type with Gradient 2

    Base Type with Gradient 3

    Sample Data

    Download the given sample data and map it as mentioned below to plot your Waterfall chart.

    Select the Year column as the Category field and the Expense or Revenue column as the Series field to plot the data.

    Please Note: The Waterfall chart supports only one series field.

    10KB
    Sample Data_Water Fall chart.xlsx
    Open
    Alerts in Grids
    Configurations
    Implementing Checkbox property for the multi selection of the rows in the Data Grid
    Various Date formats supported inside Data Grid

    Histogram Chart

    The histogram is similar to a bar chart but it groups the values into continuous ranges. Each bar in the histogram represents the height of the number of values present in that range. The X-Axis remains a continuous scale in the Histogram chart that makes it different from the Vertical Bar Chart. The Histograms make it easy to grasp where most values fall in a measurement scale, and how much variation is there. It is used to summarize a large amount of data or compare process results with specification limits.

    Best Situations to Use a Histogram chart

    • To summarize massive data sets graphically

    • To compare process results with specification limits

    • To communicate information graphically for the most frequent values

    Default Chart Image

    Properties of the Histogram chart

    General

    • Component Name: Specify a unique identifier for the Column chart component. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left: Determine the horizontal positioning of the chart.

    • Top: Adjust the vertical positioning of the chart.

    • Height: Define the height of the chart in pixels.

    Background

    • Gradient Rotation: Modify the angle of the gradient to achieve the desired effect.

    • Opacity: Set the transparency level to balance visibility and aesthetics.

    • Gradient: Choose and customize the gradient colors to match your theme.

      • Click the

    Tooltip

    • Show Tool Tip: Enable this option to display tooltips for the chart series, providing descriptions or data insights.

      • Click the Show Tooltip icon to get the configuration window for the tooltip.

      • The user can select any tooltip by enabling the checkbox given next to the tooltip.

    Title

    • Title Box Color: Choose the background color for the title box.

    • Show Title Box: Enable or disable the display of the title box on the chart.

    • Show Title: Enable or disable the display of the title text.

    • Title Bar Height: Set the height of the title bar.

    Please Note: By enabling the Show Dataset Description option the Title will be added from the mapped dataset.

    Subtitle

    • Show Sub Title: Enable or disable the display of the sub-title text.

    • Description: Add a description text below the sub-title.

    • Font Color: Select the color of the sub-title text.

    • Font Size: Specify the size of the sub-title text.

    X-Axis

    • Show X-Axis Line: Toggle the visibility of the X-axis line.

    • X-Axis Line Color: Select the color for the X-axis line.

    • Label Font Color: Choose the font color for X-axis labels.

    • Label Font Size: Specify the size of the font for X-axis labels.

    Y-Axis

    • Show Y-Axis Line: Toggle the visibility of the Y-axis line.

    • Y-Axis Line Color: Select the color for the Y-axis line.

    • Label Font Color: Choose the font color for Y-axis labels.

    • Label Font Size: Specify the size of the font for Y-axis labels.

    Legend

    • Show Legend: Toggle the visibility of the chart legend.

    • Font Color: Choose the font color for the legend text.

    • Font Weight: Determine the weight (boldness) of the legend text.

    • Font Size: Specify the size of the font for the legend text.

    Formatter

    • Unit: Define the unit of measurement for the values displayed in the chart.

    • Precision: Set the number of decimal places to display for numerical values.

    • Currency: Format the numbers as a currency with the appropriate symbol.

    • Position: Determine the position of the formatted value (e.g., before or after the number).

    Axis Setup

    • Auto Axis Setup: Automatically adjust the axis settings based on the dataset.

    • Base Zero: Ensure the axis starts at zero for better data comparison.

    • Min Value: Define the minimum value displayed on the axis.

    • Max Value: Set the maximum value for the axis range.

    Range

    The Range properties allow you to define the scope of the axis on your chart. You can choose between enabling the Auto Range option or manually setting the range by providing specific values.

    • Auto Range: When enabled, the chart automatically adjusts the ranges on the X Axis and Y Axis to display pre-defined values, ensuring optimal data visualization without the need for manual configuration.

    • Range: If the Auto Range is disabled, you can manually specify the numerical range for the axis using the Range field. This option provides more control over the data presentation by allowing you to define custom boundaries.

    By enabling the Auto Range option the chart displays pre-defined ranges on the X Axis and Y Axis.

    Export Options

    • Enable Context Menu: Activate a right-click context menu for quick access to export options in the preview mode of the chart.

    • Export Excel: Save the chart data in an Excel file format (.xlsx).

    • Export CSV: Export the chart data into a CSV file format (.csv).

    • Export JPEG: Export the chart as a JPEG image (.jpg).

    The user can get the Export Context Menu from the preview mode to download the reports in different export formats.

    Dataset Property Pallet

    Variants of Histogram chart

    Histogram - Default Chart

    Histogram - Default Chart with Data Labels

    Histogram - Default Chart with Base & Border Color

    Histogram - Rectangle Base type

    Histogram -Cylinder Base type

    Histogram - Gradient 1 Chart

    Histogram – Gradient 2 Chart

    Histogram – Gradient 3 Chart

    Sample Data

    Download the given sample data and map it as mentioned below to plot your Histogram chart:

    • Use the Sales column as a Category field, and the Profit column as a Series to plot data.

    Please Note: The Category field can be any data type line, string, or numeric. However, Series fields can be only numeric data types.

    Area chart

    An area chart or area graph displays graphically quantitively data. It is based on the line chart. The primary use of area charts is to display trends over a period of time.

    Best Situation to use an Area Chart

    • To view the automobile sales of a manufacturer over a period of time.

    Scatter Plot

    Scatter plots are used to analyze patterns in bivariate data. Data is plotted on the horizontal and vertical axis in an attempt to show how much one variable is related to another. They are the best visualizations that give users a sense of trends, correlations, and outliers from the data.

    Best Situations to Use a Scatter Plot Chart

    • To find the Relation between different variables

  • Width: Set the width of the chart in pixels.

  • Initial Visibility: Check this option to enable the chart's visibility upon the initial load.

  • Max Button: Enable or disable the maximization button for expanding the chart view.

  • Color From Drill: Allow the chart to inherit colors from a drill-down operation.

  • Base Type: Select the base shape of the columns, such as a Rectangle, Cylinder, Plain, Gradient 1, Gradient 2, or Gradient 3.

  • Border Color: Specify a border color for the chart component using this option.

  • Gradient
    icon to access the
    Background gradient colors
    dialog box.
  • Click the Add Color option to add multiple colors.

  • Click the Save option to apply the selected background colors.

  • Border: Add a border around the chart for a defined perimeter.

  • Border Color: Alter the border color to complement or contrast with the chart.

  • Border Radius: Round the corners of the chart border for a smoother look.

  • Shadow: Enable shadows to create depth and a 3D-like effect.

  • Shadow Color: Customize the shadow color to blend naturally with the chart.

  • Shadow Transparency: Adjust the transparency level to control the intensity of the shadow effect.

  • Background Color: Choose a background color for the tooltip to enhance visibility and match your visual theme.

  • Opacity: Adjust the tooltip's transparency to ensure it doesn't obstruct important chart elements while remaining readable.

  • Border Color: Select a border color that complements the tooltip, ensuring clarity and contrast against the chart background.

  • Tooltip Font Size: Customize the font size to maintain readability, adapting it to the overall chart presentation.

  • Box Width: Define the width of the tooltip box to ensure it fits the content appropriately and maintains a neat appearance.

  • Precision: Set the numerical precision for data values displayed in the tooltip, aiding in clearer data interpretation.

  • Highlighter: Toggle the highlighter to emphasize specific data points on the chart, drawing user attention to crucial information.

  • Description: Add a description text below the title.

  • Font Color: Select the color of the title text.

  • Font Size: Specify the size of the title text.

  • Font Style: Choose a Font style using the drop-down menu (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the title text from the given choices.

  • Align: Align the title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the title text.

  • Show Dataset Description: Enable or disable the dataset description in the title.

  • Font Style: Choose the font style for the Sub-title (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the sub-title text from the given choices.

  • Align: Align the sub-title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the sub-title text.

  • Label Font Style: Set the style (e.g., italic) for X-axis labels.

  • Label Font Weight: Determine the weight (e.g., bold) for X-axis label fonts.

  • Label Font Family: Choose the font family for X-axis labels.

  • Label Decoration: Add decorations (e.g., underline) to X-axis labels.

  • Label Rotation: Set the rotation angle for X-axis labels.

  • Tilted Label: Enable to tilt X-axis labels for better readability.

  • Description: Add a description for the X-axis.

  • Font Color: Specify the color of the X-axis text.

  • Font Size: Set the font size for the X-axis text.

  • Font Style: Choose the font style (e.g., italic) for X-axis text.

  • Font Weight: Determine the weight (boldness) of the X-axis text.

  • Font Family: Select the font family for the X-axis text.

  • Text Decoration: Add text decorations (e.g., underline) to the X-axis labels.

  • Category Tick Marks: Activate tick marks for categories on the X-axis.

  • Marker Color: Choose the color of the markers on the X-axis.

  • Show Dataset Description: Toggle the visibility of dataset descriptions on the X-axis.

  • Label Font Style: Set the style (e.g., italic) for Y-axis labels.

  • Label Font Weight: Determine the weight (e.g., bold) for Y-axis label fonts.

  • Label Font Family: Choose the font family for Y-axis labels.

  • Label Decoration: Add decorations (e.g., underline) to Y-axis labels.

  • Description: Add a description for the Y-axis.

  • Font Color: Specify the color of the Y-axis text.

  • Font Size: Set the font size for the Y-axis text.

  • Font Style: Choose the font style (e.g., italic) for Y-axis text.

  • Font Weight: Determine the weight (boldness) of the Y-axis text.

  • Font Family: Select the font family for the Y-axis text.

  • Text Decoration: Add text decorations (e.g., underline) to the Y-axis labels.

  • Show Dataset Description: Toggle the visibility of dataset descriptions on the Y-axis.

  • Font Family: Select the font family for the legend text.

  • Font Style: Choose the font style (e.g., italic) for the legend text.

  • Text Decoration: Add text decorations (e.g., underline) to the legend text.

  • Hide on Load: Determine if the legend should be hidden when the chart initially loads.

  • Number Formatter: Apply a specific notation or style to the numbers (e.g., Indian, International).

    Horizontal Marker Line: Add a horizontal line at a specified value for reference.

  • Vertical Marker Line: Place a vertical line at a specific point for highlighting.

  • Zero Marker Line: Include a line at zero to emphasize the baseline.

  • Zero Marker Color: Customize the color of the zero marker line.

  • Color: Set a color for the marker line.

  • Opacity: Adjust the color transparency of the axis marker line.

  • Export PNG: Export the chart as a PNG image (.png).

  • Export PPT: Export the chart to a PowerPoint presentation (.pptx).

  • Export PDF: Export the chart as a PDF document (.pdf).

  • Show Print: Include an option to print the chart directly.

  • Export Heading: Add a custom heading to the exported file.

  • Export Sub Heading: Add a custom subheading to the exported file.

  • Export File Name: Specify the file name for the exported file/dashboard.

  • Global Export Type: Define the default export format using the drop-down (e.g., Screenshot, Tabular).

  • 9KB
    Sample Data_Histogram.xlsx
    Open
    Accessing the Export Context menu in the Preview mode

    To view the revenue growth of an organization by quarter wise.

    Default Visualization of the Chart

    Area Chart in Design Mode

    Properties of the Area Chart

    General

    In the General properties of the Area Chart, users can customize several aspects:

    • Component Name: Assign a unique identifier to the chart for easy reference. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left & Top: Set the chart's position within the design area by modifying these values.

    • Height & Width: Adjust the chart's dimensions to fit your layout needs.

    • Initial Visibility: Enable to ensure the chart appears during the initial preview.

    • Max Button: Provide a button to maximize the chart for better visibility.

    • Color From Drill: Utilize colors from drilled data points to enhance visual distinction.

    • Points: Display data points on the chart for greater detail.

    • Line Form: Select the form of the line in the chart, such as Segment or Curve.

    • Chart Type: Choose the chart's style, e.g., Overlaid, Stacked, and Laid to best represent the data.

    Background

    In the Background properties of the Area Chart, users can enhance the visual appeal by adjusting the following fields:

    • Gradient Rotation: Modify the angle of the gradient to achieve the desired effect.

    • Opacity: Set the transparency level to balance visibility and aesthetics.

    • Gradient: Choose and customize the gradient colors to match your theme.

      • Click the Gradient icon to access the Background gradient colors dialog box.

      • Click the Add Color option to add multiple colors.

      • Click the Save option to apply the selected background colors.

    • Border: Add a border around the chart for a defined perimeter.

    • Border Color: Alter the border color to complement or contrast with the chart.

    • Border Radius: Round the corners of the chart border for a smoother look.

    • Shadow: Enable shadows to create depth and a 3D-like effect.

    • Shadow Color: Customize the shadow color to blend naturally with the chart.

    • Shadow Transparency: Adjust the transparency level to control the intensity of the shadow effect.

    Tooltip

    Tooltips enhance user interaction by displaying additional information about chart elements.

    • Show Tool Tip: Enable this option to display tooltips for the chart series, providing descriptions or data insights.

      • Click the Show Tool Tip icon to access the Tool Tip Configuration window.

      • Select the Default option.

      • Put a checkmark in the box to enable the component formatter.

      • Click the Save option to display Tool Tip in the default display.

    • Background Color: Choose a background color for the tooltip to enhance visibility and match your visual theme.

    • Opacity: Adjust the tooltip's transparency to ensure it doesn't obstruct important chart elements while remaining readable.

    • Border Color: Select a border color that complements the tooltip, ensuring clarity and contrast against the chart background.

    • Tooltip Font Size: Customize the font size to maintain readability, adapting it to the overall chart presentation.

    • Box Width: Define the width of the tooltip box to ensure it fits the content appropriately and maintains a neat appearance.

    • Precision: Set the numerical precision for data values displayed in the tooltip, aiding in clearer data interpretation.

    • Highlighter: Toggle the highlighter to emphasize specific data points on the chart, drawing user attention to crucial information.

    Please Note: To use the Custom option for the Tool Tip configuration, please refer to the Tooltip (Default & Custom) page.

    Title

    • Title Box Color: Choose the background color for the title box.

    • Show Title Box: Enable or disable the display of the title box on the chart.

    • Show Title: Enable or disable the display of the title text.

    • Title Bar Height: Set the height of the title bar.

    • Description: Add a description text below the title.

    • Font Color: Select the color of the title text.

    • Font Size: Specify the size of the title text.

    • Font Style: Choose a Font style using the drop-down menu (e.g., italic or normal).

    • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

    • Font Family: Choose the font family for the title text from the given choices.

    • Align: Align the title text (e.g., left, center, right).

    • Text Decoration: Apply text decorations (e.g., underline) to the title text.

    • Show Dataset Description: Enable or disable the dataset description in the title.

    Please Note: By enabling the Show Dataset Description option the Title will get added from the mapped dataset.

    Subtitle

    • Show Sub Title: Enable or disable the display of the sub-title text.

    • Description: Add a description text below the sub-title.

    • Font Color: Select the color of the sub-title text.

    • Font Size: Specify the size of the sub-title text.

    • Font Style: Choose the font style for the Sub-title (e.g., italic or normal).

    • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

    • Font Family: Choose the font family for the sub-title text from the given choices.

    • Align: Align the sub-title text (e.g., left, center, right).

    • Text Decoration: Apply text decorations (e.g., underline) to the sub-title text.

    X-Axis

    • Show X-Axis Line: Toggle the visibility of the X-axis line.

    • X-Axis Line Color: Select the color for the X-axis line.

    • Label Font Color: Choose the font color for X-axis labels.

    • Label Font Size: Specify the size of the font for X-axis labels.

    • Label Font Style: Set the style (e.g., italic) for X-axis labels.

    • Label Font Weight: Determine the weight (e.g., bold) for X-axis label fonts.

    • Label Font Family: Choose the font family for X-axis labels.

    • Label Decoration: Add decorations (e.g., underline) to X-axis labels.

    • Label Rotation: Set the rotation angle for X-axis labels.

    • Tilted Label: Enable to tilt X-axis labels for better readability.

    • Description: Add a description for the X-axis.

    • Font Color: Specify the color of the X-axis text.

    • Font Size: Set the font size for the X-axis text.

    • Font Style: Choose the font style (e.g., italic) for X-axis text.

    • Font Weight: Determine the weight (boldness) of the X-axis text.

    • Font Family: Select the font family for the X-axis text.

    • Text Decoration: Add text decorations (e.g., underline) to the X-axis labels.

    • Category Tick Marks: Activate tick marks for categories on the X-axis.

    • Marker Color: Choose the color of the markers on the X-axis.

    • Show Dataset Description: Toggle the visibility of dataset descriptions on the X-axis.

    Y-Axis

    • Show Y-Axis Line: Toggle the visibility of the Y-axis line.

    • Y-Axis Line Color: Select the color for the Y-axis line.

    • Label Font Color: Choose the font color for Y-axis labels.

    • Label Font Size: Specify the size of the font for Y-axis labels.

    • Label Font Style: Set the style (e.g., italic) for Y-axis labels.

    • Label Font Weight: Determine the weight (e.g., bold) for Y-axis label fonts.

    • Label Font Family: Choose the font family for Y-axis labels.

    • Label Decoration: Add decorations (e.g., underline) to Y-axis labels.

    • Description: Add a description for the Y-axis.

    • Font Color: Specify the color of the Y-axis text.

    • Font Size: Set the font size for the Y-axis text.

    • Font Style: Choose the font style (e.g., italic) for Y-axis text.

    • Font Weight: Determine the weight (boldness) of the Y-axis text.

    • Font Family: Select the font family for the Y-axis text.

    • Text Decoration: Add text decorations (e.g., underline) to the Y-axis labels.

    • Show Dataset Description: Toggle the visibility of dataset descriptions on the Y-axis.

    Legend

    • Show Legend: Toggle the visibility of the chart legend.

    • Font Color: Choose the font color for the legend text.

    • Font Weight: Determine the weight (boldness) of the legend text.

    • Font Size: Specify the size of the font for the legend text.

    • Font Family: Select the font family for the legend text.

    • Font Style: Choose the font style (e.g., italic) for the legend text.

    • Text Decoration: Add text decorations (e.g., underline) to the legend text.

    • Hide on Load: Determine if the legend should be hidden when the chart initially loads.

    Formatter

    • Unit: Define the unit of measurement for the values displayed in the chart.

    • Precision: Set the number of decimal places to display for numerical values.

    • Currency: Format the numbers as a currency with the appropriate symbol.

    • Position: Determine the position of the formatted value (e.g., before or after the number).

    • Number Formatter: Apply a specific notation or style to the numbers (e.g., Indian, International).

    Axis Setup

    • Auto Axis Setup: Automatically adjust the axis settings based on the dataset.

    • Base Zero: Ensure the axis starts at zero for better data comparison.

    • Min Value: Define the minimum value displayed on the axis.

    • Max Value: Set the maximum value for the axis range.

    • Horizontal Marker Line: Add a horizontal line at a specified value for reference.

    • Vertical Marker Line: Place a vertical line at a specific point for highlighting.

    • Zero Marker Line: Include a line at zero to emphasize the baseline.

    • Zero Marker Color: Customize the color of the zero marker line.

    • Color: Set color for the axis marker line.

    • Opacity: Adjust the color transparency of the axis marker line.

    Export Options

    • Enable Context Menu: Activate a right-click context menu for quick access to export options in the preview mode of the chart.

    • Export Excel: Save the chart data in an Excel file format (.xlsx).

    • Export CSV: Export the chart data to a CSV file format (.csv).

    • Export JPEG: Export the chart as a JPEG image (.jpg).

    • Export PNG: Export the chart as a PNG image (.png).

    • Export PPT: Export the chart to a PowerPoint presentation (.pptx).

    • Export PDF: Export the chart as a PDF document (.pdf).

    • Show Print: Include an option to print the chart directly.

    • Export Heading: Add a custom heading to the exported file.

    • Export Sub Heading: Add a custom subheading to the exported file.

    • Export File Name: Specify the file name for the exported file/dashboard.

    • Global Export Type: Define the default export format using the drop-down (e.g., Screenshot, Tabular).

    • The user can get the Export Context Menu from the preview mode to download the reports in different export formats.

    Context Menu with Export options in the Preview mode

    Dataset Series Properties

    The user can change the color of each series by selecting any of the series. The user can change the Line type to Dot, Dot-Dash, Straight, or Dash together with the line width, point shape, point radius, and Display Name i.e. it can display a different name while previewing the dashboard if Display Name change is selected. We can enable the Data Label to show the Value of each Year.

    Default Dataset Properties

    Please Note: The Category field can be any data type line, string, or numeric. But, Series fields can be only numeric data type.

    Various Variants of the Area chart

    It is possible to get the following variants of the Area chart by changing the Properties.

    Overlaid Chart with the Line segment

    Overlaid Chart with Line Curve

    Stacked Chart

    100% Chart

    Sample Data

    Download the given sample data and map it as mentioned below to plot your Area Plot chart:

    • Use the Year column as Category field and the other columns as Series to plot data as shown in the given examples below:

    9KB
    Sample Data_Area chart.xlsx
    Open

    To find the potential root cause of a problem

    Variations of this chart

    Add-up Filters: Filters like combo boxes can be added to the scatter plot chart to filter data based on a condition.

    Differentiate by Type: Data plotted on the charts may contain different categories. These categories can be identified by assigning different shapes.

    Default Component Image

    Properties of the Scatter Plot

    General

    The user can change the height, width, top, and left. If initial visibility is not enabled, then the chart won’t be available for the first preview. The base type can be adjusted between Gradient and Plain.

    • Component Name: Set a unique name for the component identification. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left: Adjust the horizontal positioning of the chart on the canvas.

    • Top: Set the vertical positioning of the chart from the top edge.

    • Height: Determine the height of the chart in the layout.

    • Width: Specify the width of the chart to resize it accordingly.

    • Drag and Zoom: Enable or disable the ability for users to drag and zoom into specific areas of the scatter plot for a more detailed view. This can enhance interactivity and user engagement with the data.

    • Initial Visibility: Control whether the chart is visible when the page loads.

    • Max Button: Enable a button to maximize the chart's view.

    • Base Type: Select between Gradient and Plain options to set the foundational style of the scatter plot. Gradient provides a more visually layered effect, whereas Plain offers a straightforward presentation.

    • Luminance: Adjust the luminance settings to control the brightness or dimness of the chart appearance. This can be used to accommodate different visual requirements or preferences.

    • Actions: Define custom actions or behaviors when users interact with the scatter plot, such as clicking on a data point or hovering over the chart, to create a dynamic user experience.

    • Animation: Enable animation effects for transitions within the scatter plot to provide a smooth and visually appealing movement when the chart data updates or loads.

    Tooltip

    • Show Tool Tip: The user can show the series description and get the tooltip by clicking the Show Tool Tip option.

      • The Tool Tip Configuration window opens.

      • Select any Tool Tip option. The supported Tool Tip options are None and Default.

      • Click the Save option.

    • Background Color: Set the background color for the tooltip box to enhance readability.

    • Opacity: Adjust the transparency level of the tooltip background.

    • Border Color: Define the color of the border surrounding the tooltip box.

    • Tooltip Font Size: Specify the font size for the text displayed in the tooltip.

    • Box Width: Determine the width of the tooltip box for optimal presentation.

    • Precision: Set the number of decimal places to show in the tooltip for numerical values.

    Please Note: To use the Custom option for the Tool Tip configuration, please refer to the Tooltip (Default & Custom) page.

    Range Indicators

    The users get to set ranges and select colors for the ranges and Range Legends by using this Properties option. It is also possible to use Dynamic Range colors from the Range Properties window.

    • Click the Properties icon for the Range Indicators.

    • The Range Properties window opens.

      • Click the Add Range option to insert a new range.

      • Once the new Range gets added, the user can modify the Range Name, Range From, Range Up to limits, and Range Color.

      • The user also gets the option to Delete an existing Range.

      • Click the Save option to apply the selected Range Properties.

    • The users can also choose to apply dynamic colors to the bubble by selecting the Dynamic Range option.

    • After setting the Range colors (manually or dynamically), Enable the Range Color Legend option.

    • Open the chart in the Preview mode.

    • Click the Legend icon.

    • A context menu opens displaying the names and color selection for the inserted ranges.

    Background

    • Gradient Rotation: Adjust the angle of the gradient applied to the background, allowing for a dynamic visual transition between colors.

    • Opacity: Set the transparency level of the background, ranging from fully opaque to completely transparent.

    • Gradient: Enable or disable gradient colors in the background for depth and visual appeal.

      • Click the Gradient icon to access the Background gradient colors dialog box.

      • Click the Add Color option to add multiple colors.

      • Click the Save option to apply the selected background colors.

    • Border: Define the width of the border surrounding the pyramid chart.

    • Border Color: Select the color for the chart's border, enhancing its visibility and aesthetics.

    • Border Radius: Round the corners of the chart's border for a softer, more modern appearance.

    • Shadow: Enable a shadow effect for the background to add dimension and focus to the chart.

    • Shadow Color: Choose the color of the shadow cast by the chart background.

    • Shadow Transparency: Adjust the transparency level of the shadow to control its prominence and intensity.

    Title

    • Title Box Color: Set the background color for the title box, enhancing visual distinction and cohesion with your chart theme.

    • Show Title Box: Enable or disable the display of the title box to frame your chart title appropriately.

    • Show Title: Toggle the display of the chart's main title, providing context or emphasis as needed.

    • Title Bar Height: Adjust the height of the title bar to ensure it fits the title content without overlapping chart elements.

    • Description: Add the title text that you wish to display in the title box.

    • Font Color: Choose the color for the title text, aligning with visual elements for readability and emphasis.

    • Font Size: Specify the size of the title font to match the visual hierarchy of the chart presentation.

    • Font Style: Select the style (e.g., normal, italic) of the title font to differentiate or accentuate the text.

    • Font Weight: Define the boldness of the title font with options like Normal, Bold, 300, 600, and 900 for varying intensity.

    • Font Family: Select the font family for stylistic consistency and readability in your chart title.

    • Align: Set the alignment of the title text (e.g., left, center, right) to position it accurately on the chart.

    • Text Decoration: Apply decorations (e.g., underline) to the title text for additional emphasis or style.

    • Show Dataset Description: Enable or disable the dataset description in the title.

    Please Note: By enabling the Show Dataset Description option the Title will get added from the mapped dataset.

    Subtitle

    Here user can enable the subtitle if the user has any second title and also, the user can change the Name, Font color, size, style, etc.

    X-Axis

    • Show X-Axis Line: Toggle the visibility of the x-axis line.

    • X-Axis Line Color: Select the color for the x-axis line.

    • Label Font Color: Set the color of the x-axis labels.

    • Label Font Size: Adjust the size of the font used for x-axis labels.

    • Label Font Style: Choose the style (e.g., italic, oblique) for label text.

    • Label Font Weight: Define the thickness of the label text.

    • Label Font Family: Select the font type for the labels.

    • Label Decoration: Add text decorations such as underlining to labels.

    • Label Rotation: Specify the angle for rotating x-axis labels.

    • Tilted Label: Enable this to tilt labels for better visibility.

    • Description: Provide a brief description or title for the x-axis.

    • Font Color: Pick a color for the x-axis text elements.

    • Font Size: Change the overall size of text on the x-axis.

    • Font Style: Set the text style for x-axis elements (e.g., normal, italic).

    • Font Weight: Modify the boldness of the text on the x-axis.

    • Font Family: Define the typeface for text along the x-axis.

    • Text Decoration: Apply decorative styles like underlining to x-axis text.

    • Category Tick Marks: Control the appearance and frequency of tick marks on the x-axis.

    • Marker Color: Choose a color for the markers along the x-axis.

    • Horizontal Auto Axis: Automatically adjusts the scale and range of the x-axis based on data points.

    • Horizontal Base Zero: Ensures the x-axis starts from zero, maintaining consistent scale.

    • Horizontal Min Value: Sets the minimum data value to be displayed on the x-axis.

    • Horizontal Max Value: Sets the maximum data value to be displayed on the x-axis.

    • Unit: Defines the unit of measurement for the data represented along the x-axis.

    • Precision: Determines the number of decimal places for the numbers displayed on the x-axis.

    • Currency: Formats the x-axis labels to represent currency values when applicable.

    • Position: Sets the position on the x-axis, such as prefix or suffix.

    • Number Formatter: Applies a specific format to the numerical values on the x-axis like Indian or International.

    • X-Axis Threshold: Establishes a baseline value, distinguishing above or below threshold data points.

    • Minimum Threshold: Specifies the lowest allowable value in a range for the x-axis.

    • Maximum Threshold: Specifies the highest allowable value in a range for the x-axis.

    Y-Axis

    • Show Y-Axis Line: Toggle the visibility of the Y-axis line.

    • Y-Axis Line Color: Select the color for the Y-axis line.

    • Label Font Color: Choose the font color for Y-axis labels.

    • Label Font Size: Specify the size of the font for Y-axis labels.

    • Label Font Style: Set the style (e.g., italic) for Y-axis labels.

    • Label Font Weight: Determine the weight (e.g., bold) for Y-axis label fonts.

    • Label Font Family: Choose the font family for Y-axis labels.

    • Label Decoration: Add decorations (e.g., underline) to Y-axis labels.

    • Description: Add a description for the Y-axis.

    • Font Color: Specify the color of the Y-axis text.

    • Font Size: Set the font size for the Y-axis text.

    • Font Style: Choose the font style (e.g., italic) for Y-axis text.

    • Font Weight: Determine the weight (boldness) of the Y-axis text.

    • Font Family: Select the font family for the Y-axis text.

    • Text Decoration: Add text decorations (e.g., underline) to the Y-axis labels.

    • Y-Axis Threshold: This field sets a specific baseline on the Y-axis, helping users visually distinguish data points that are above or below the defined threshold line. It aids in quickly identifying values that meet or exceed certain criteria.

    • Minimum Threshold: Specifies the lowest permissible value on the Y-axis. Data points below this value may be highlighted or noted for significance, ensuring that users are aware of any entries outside accepted parameters.

    • Maximum Threshold: This field sets the highest allowable value on the Y-axis. Values exceeding this threshold are easily identifiable, allowing users to focus on data points that might need further analysis due to their exceptional nature.

    Legend

    The user can enable the internal legend if the user wants to show it and customize the font size, color, style, etc. for the enabled legend.

    • Show Legend: Toggle the visibility of the chart legend.

    • Font Color: Choose the font color for the legend text.

    • Font Weight: Determine the weight (boldness) of the legend text.

    • Font Size: Specify the size of the font for the legend text.

    • Font Family: Select the font family for the legend text.

    • Font Style: Choose the font style (e.g., italic) for the legend text.

    • Text Decoration: Add text decorations (e.g., underline) to the legend text.

    • Hide on Load: Determine if the legend should be hidden when the chart initially loads.

    Formatter

    • Unit: Define the unit of measurement for the values displayed in the chart.

    • Precision: Set the number of decimal places to display for numerical values.

    • Currency: Format the numbers as a currency with the appropriate symbol.

    • Position: Determine the position of the formatted value (e.g., Prefix or Suffix).

    • Number Formatter: Apply a specific notation or style to the numbers (e.g., Indian, International).

    Axis Setup

    • Auto Axis Setup: Automatically adjust the axis settings based on the dataset.

    • Base Zero: Ensure the axis starts at zero for better data comparison.

    • Min Value: Define the minimum value displayed on the axis.

    • Max Value: Set the maximum value for the axis range.

    • Vertical Marker Line: Place a vertical line at a specific point for highlighting.

    • Horizontal Marker Line: Add a horizontal line at a specified value for reference.

    • Zero Marker Line: Include a line at zero to emphasize the baseline.

    • Zero Marker Color: Customize the color of the zero marker line.

    • Vertical Zero Marker Line: Enable this option to display the zero marker line vertically in the chart.

    • Vertical Zero Marker Color: Set a color for the vertical zero marker line in the chart.

    • Color: Choose the color for the axis and labels.

    • Opacity: Adjust the transparency of the axis and markers.

    Export Options

    • Enable Context Menu: Activate a right-click context menu for quick access to export options in the preview mode of the chart.

    • Export Excel: Save the chart data in an Excel file format (.xlsx).

    • Export CSV: Export the chart data into a CSV file format (.csv).

    • Export JPEG: Export the chart as a JPEG image (.jpg).

    • Export PNG: Export the chart as a PNG image (.png).

    • Export PPT: Export the chart to a PowerPoint presentation (.pptx).

    • Export PDF: Export the chart as a PDF document (.pdf).

    • Show Print: Include an option to print the chart directly.

    • Export Heading: Add a custom heading to the exported file.

    • Export Sub Heading: Add a custom subheading to the exported file.

    • Export File Name: Specify the file name for the exported file/dashboard.

    • Global Export Type: Define the default export format using the drop-down (e.g., Screenshot, Tabular).

    The user can get the Export Context Menu from the preview mode to download the reports in different export formats.

    Dataset Property

    Map a dataset to the dragged Scatter plot component and you can drag the given columns under the X Field. After mapping the data, the user gets the Properties and Indicators tab for the Dataset values to be displayed more effectively.

    Scatter Plot chart after changing its properties

    Sample Data

    Download the given sample data and map it as mentioned below to plot your Scatter Plot chart.

    Please Note: Use all the given fields as X-Axis. The various colors displayed in the Scatterplot chart indicate different data values.

    9KB
    Sample Data_Scatter chart.xlsx
    Open

    Map Chart

    The Map chart is used to position data in a geographical context. Multiple layers are included to cover various information. The users can specify which layer to be marked as an interactive layer as it is the only layer wherein items can be marked.

    Best Situations to Use a Map Chart

    To display widely spread data or processes in the geographical setup.

    Default Chart Image

    Properties of the Map chart

    General

    • Component Name: Assign a unique name to the map chart component. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left & Top: Set the chart's position on the canvas by specifying the left and top margins.

    • Height & Width: Adjust the chart's dimensions to fit within the desired space on the canvas.

    • Initial Visibility: Check this option to ensure the chart is visible on the initial view.

    • Max Button: Use this to maximize the chart view independently.

    • Map Type: Choose between SVG and Leaflet map types.

    • Select Map: Pick a specific map, such as a continent like Asia, from the available options.

    • Geometry Type: Choose from Marker, Line, Polygon, Clustered, Trail, and Trip.

    • Line Type: Select the form of line representation such as Curve, Segment, Step, Reverse Step, Horizontal, and Vertical.

    • Line Thickness: Specify the thickness of the line in the chart.

    • Default Color: Select a default color for the map elements.

    • Roll Over Color: Define a color change when hovering over map elements.

    • Outline Color: Set the color for the outline of map areas or lines.

    • Color Ranges: Apply a range of colors for different values or sections on the map.

    • Solid Color: Choose a single color to fill specific map regions.

    • Opacity: Adjust the transparency level of the map elements.

    • Random Color: Enable random color assignment to map segments for a varied appearance.

    Tooltip

    Configure the tooltip for enhanced map chart interaction.

    • Show Tool Tip: Enable this to display tooltips with information upon hovering over map elements. The user can show the series description and get the tooltip by clicking the Show Tool Tip option.

      • The Tool Tip Configuration window opens.

      • Select any Tool Tip option. The supported Tool Tip is None, Default, Custom.

      • Put a checkmark in the given box to enable the component formatter.

      • Click the Save option.

    • Background Color: Set the background color for the tooltip box to enhance visibility.

    • Opacity: Adjust the transparency level of the tooltip for better presentation over the map.

    • Border Color: Define the color of the tooltip's border to contrast or complement the background.

    • Tooltip Font Size: Specify the font size for the text within the tooltip to ensure readability.

    • Box Width: Determine the tooltip box width to fit content appropriately.

    • Precision: Set the number of decimal places displayed for numeric data within the tooltip.

    Please Note: To use the Custom option for the Tool Tip configuration, please refer to the Tooltip (Default & Custom) page.

    Configuring Tooltip for the Map Chart

    The user can show the series description and get a tooltip by enabling it.

    • Open the Tooltip properties.

    • Click the Show Tool Tip icon.

    • The Tool Tip Configuration dialog box appears.

    • Select the Custom option using the checkbox.

    • Enter the description you want to display for the Tooltip.

    • Click the Save option.

    • The customized tooltip appears for the Map chart.

    Background

    • Gradient Rotation: Modify the angle of the gradient to achieve the desired effect.

    • Opacity: Set the transparency level to balance visibility and aesthetics.

    • Gradient: Choose and customize the gradient colors to match your theme.

      • Click the Gradient icon to access the Background gradient colors dialog box.

      • Click the Add Color option to add multiple colors.

      • Click the Save option to apply the selected background colors.

    • Border: Add a border around the chart for a defined perimeter.

    • Border Color: Alter the border color to complement or contrast with the chart.

    • Border Radius: Round the corners of the chart border for a smoother look.

    • Shadow: Enable shadows to create depth and a 3D-like effect.

    • Shadow Color: Customize the shadow color to blend naturally with the chart.

    • Shadow Transparency: Adjust the transparency level to control the intensity of the shadow effect.

    Title

    • Title Box Color: Choose the background color for the title box.

    • Show Title Box: Enable or disable the display of the title box on the chart.

    • Show Title: Enable or disable the display of the title text.

    • Title Bar Height: Set the height of the title bar.

    • Description: Add a description text below the title.

    • Font Color: Select the color of the title text.

    • Font Size: Specify the size of the title text.

    • Font Style: Choose a Font style using the drop-down menu (e.g., italic or normal).

    • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

    • Font Family: Choose the font family for the title text from the given choices.

    • Align: Align the title text (e.g., left, center, right).

    • Text Decoration: Apply text decorations (e.g., underline) to the title text.

    • Show Dataset Description: Enable or disable the dataset description in the title.

    Please Note: By enabling the Show Dataset Description option, the Title will be added from the mapped dataset with the charting component.

    Subtitle

    The Subtitle properties allow customization of the subtitle within the chart. Here's a breakdown of each field:

    • Show Sub Title: Toggle this option to display or hide the subtitle on the chart.

    • Description: Enter a desired subtitle text to be displayed when enabled.

    • Font Color: Choose a color for the subtitle text.

    • Font Size: Adjust the size of the subtitle text for better readability.

    • Font Style: Select between normal, or italic font style for the subtitle.

    • Font Weight: Modify the thickness of the subtitle text, such as Bold or Normal.

    • Font Family: Pick a font family that suits the design of your chart.

    • Align: Set the alignment of the subtitle text (left, center, right).

    • Text Decoration: Apply decoration options (e.g., underline) to the subtitle text.

    Export Options

    • Enable Context Menu: Toggle this option to provide users with a context menu in the Preview mode, allowing various export functionalities.

    • Export Excel: Select this option to export the map chart data in Excel format, providing a structured spreadsheet for analysis.

    • Export CSV: Choose this option to export the map chart data in CSV format, facilitating easy data import and manipulation.

    • Export File Name: Specify a custom name for the exported file, ensuring it is easily identifiable.

    • Global Export Type: Define a default export format for all charts to streamline the export process and maintain consistency.

    The user can get the Export Context Menu from the preview mode to download the reports in different export formats.

    Map Chart with SVG Type

    Map Chart with Leaflet Type

    Leaflet Auto Zoom

    The user can use the Auto-zoom functionality to cover all the markers in the map component. This functionality is available in the zoom-in map (Leaflet) based on the number of markers and their placed positions so that all markers must be visible at that zoom-in level.

    Leaflet Trip/Trail – Property - Line Type

    The Line Type property is provided in the General tab for the Trip and Trail Geometry type Leaflet maps. The user can show Trip/ Trail map lines in any of the following three categories:

    1. Straight Line

    2. Dotted Line

    3. Dashed Line

    ​​

    Leaflet Trip Type Straight Line Map

    Leaflet Trip Type with Dash Line Map

    Leaflet Trip Type Dotted Line Map

    Please Note:

    • This feature has been provided to the Leaflet Trip/Trail Geometry Type maps only.

    • The width of the line or dot is fixed for all the supported line types.

    Leaflet support for the Glyph and Maki Marker Icons

    The Glyph and Maki marker icons are supported in the Leaflet map type chart. The user needs to set the m_svgicons variable to false using the SDK script. The following three types of icons are supported in the Leaflet map with the Trip Geometry Type:

    1. For Markers with custom icons we use Maki Icons. Please click to check out the link https://labs.mapbox.com/maki-icons/

    ​2. For custom markers we can use Glyph Icons. Please click to check out the link https://getbootstrap.com/docs/3.3/components/#glyphicons​

    3. For custom markers we can also use font icons like bd-filter, bd-

    Please Note:

    • Currently, we provide support for Leaflet Trip Type Non SVG.

    • To get these icons, we must set the m_svgicons variable to 'false' using the SDK script.

    A sample script with m_svgicons variable to false is given below:

    Leaflet Trip Type map with Glyph icon marker
    Leaflet Trip Type map with Maki icons marker​

    Display Circle Data Points in the Leaflet Charts

    The Circle data points in Leaflet charts likely refer to markers displayed on the map in a circle shape. These markers can indicate a specific location or set of coordinates on the map and can be customized in terms of color, size, and other visual properties. BDB Designer draws circles considering the first data point as the center, provided with an option to configure at which data point circle should render.

    Steps to Configure Circle Data Points & Show Marker through Script

    • Add a variable to control geometry type as a circle.

    • Draw marker for other data points when Geometry type is circle.

    Configure Circle as a Data Point

    • By default, it draws a circle considering the first point.

    • The user can control the circle data point through a script. The script is given below.

    Series Indicator

    The Map chart supports Series Color based on the conditions.

    • Open the Dataset properties for the Map component.

    • Select a Series.

    • Open the Indicator tab.

    • Click the Add New Condition icon.

    • The Conditional Color dialog box opens for the selected series field.

    • Select one option out of the Fixed Value Comparison or SVG.

    • Complete the required configuration.

    • Click the Create option.

    • Open the preview of the Map chart to view the conditional color for the set value.

    Sample Data

    Download the given sample data and map it as mentioned below to plot your Map chart.

    • Use the Name column as a Category field, and the Unemployment-rate column as a Series to plot data.

    13KB
    Sample Data_Map chart.xlsx
    Open

    Column Chart

    A column chart is used when you want to compare the values of individual data points with another. They help in bringing out the highs and lows of the data set. The Column chart is a data visualization where each category is represented by a rectangle, with the height of the rectangle being proportional to the values being plotted. Column charts are also known as vertical bar charts.

    Best Situations to Use a Column Chart

    Column charts are suitable for displaying data sets with negative values

    Example: To find the best and worst performers in an organization

    Variations of this chart Use stacked Column charts: Where multiple categories can be clubbed together on top of each other, which makes addressing multiple questions easier.

    Use columns side by side: Where comparison between multiple categories becomes easier instead of toggling between charts.

    Add color for quick insight: Displaying the columns with colors will make users pay quick attention to important tasks.

    Default Chart Image

    The Properties of Column Chart

    General

    • Component Name: Specify a unique identifier for the Column chart component. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left: Determine the horizontal positioning of the chart.

    • Top: Adjust the vertical positioning of the chart.

    • Height: Define the height of the chart in pixels.

    Tooltip

    Tooltips enhance user interaction by displaying additional information about chart elements.

    • Show Tool Tip: Enable this option to display tooltips for the chart series, providing descriptions or data insights.

      • Click the Show Tool Tip icon to access the Tool Tip Configuration window.

      • Select the Default option.

    Please Note: To use the Custom option for the Tool Tip configuration, please refer to the page.

    Background

    • Gradient Rotation: Modify the angle of the gradient to achieve the desired effect.

    • Opacity: Set the transparency level to balance visibility and aesthetics.

    • Gradient: Choose and customize the gradient colors to match your theme.

      • Click the

    Title

    • Title Box Color: Choose the background color for the title box.

    • Show Title Box: Enable or disable the display of the title box on the chart.

    • Show Title: Enable or disable the display of the title text.

    • Title Bar Height: Set the height of the title bar.

    Please Note: By enabling the Show Dataset Description option the Title will get added from the mapped dataset.

    Subtitle

    • Show Sub Title: Enable or disable the display of the sub-title text.

    • Description: Add a description text below the sub-title.

    • Font Color: Select the color of the sub-title text.

    • Font Size: Specify the size of the sub-title text.

    X-Axis

    • Show X-Axis Line: Toggle the visibility of the X-axis line.

    • X-Axis Line Color: Select the color for the X-axis line.

    • Label Font Color: Choose the font color for X-axis labels.

    • Label Font Size: Specify the size of the font for X-axis labels.

    Y-Axis

    • Show Y-Axis Line: Toggle the visibility of the Y-axis line.

    • Y-Axis Line Color: Select the color for the Y-axis line.

    • Label Font Color: Choose the font color for Y-axis labels.

    • Label Font Size: Specify the size of the font for Y-axis labels.

    Legend

    • Show Legend: Toggle the visibility of the chart legend.

    • Font Color: Choose the font color for the legend text.

    • Font Weight: Determine the weight (boldness) of the legend text.

    • Font Size: Specify the size of the font for the legend text.

    Formatter

    • Unit: Define the unit of measurement for the values displayed in the chart.

    • Precision: Set the number of decimal places to display for numerical values.

    • Currency: Format the numbers as a currency with the appropriate symbol.

    • Position: Determine the position of the formatted value (e.g., before or after the number).

    Axis Setup

    • Auto Axis Setup: Automatically adjust the axis settings based on the dataset.

    • Base Zero: Ensure the axis starts at zero for better data comparison.

    • Min Value: Define the minimum value displayed on the axis.

    • Max Value: Set the maximum value for the axis range.

    Export Options

    • Enable Context Menu: Activate a right-click context menu for quick access to export options in the preview mode of the chart.

    • Export Excel: Save the chart data in an Excel file format (.xlsx).

    • Export CSV: Export the chart data into a CSV file format (.csv).

    • Export JPEG: Export the chart as a JPEG image (.jpg).

    • The user can get the Export Context Menu from the preview mode to download the reports in different export formats.

    Dataset Series Properties

    The user can change the color of each series by selecting any of the series from the Dataset properties. The user can enable the Data Label to show the value of each selected data field.

    Various Variants of the Column Chart

    The following variants of the Column chart can be seen by changing the chart properties:

    Clustered Charts

    Clustered chart with Plain Base

    Clustered chart with Rectangle Base

    Clustered chart with Cylinder Base

    Clustered chart with Gradient1 Base

    Clustered chart with Gradient2 Base

    Clustered chart with Gradient3 Base

    Stacked Charts

    Stacked Chart with Rectangle Base

    Stacked Chart with Cylinder Base

    Stacked Chart with Plain Base

    Stacked Chart with Gradient1 Base

    Stacked Chart with Gradient2 Base

    Stacked Chart with Gradient3 Base

    Overlaid Charts

    Overlaid Chart with Rectangle Base

    Overlaid Chart with Cylinder Base

    Overlaid Chart with Plain Base

    Overlaid Chart with Gradient1 Base

    Overlaid Chart with Gradient2 Base

    Overlaid Chart with Gradient3 Base

    100% Charts

    100% Chart with Rectangle Base

    100% Chart with Cylinder Base

    100% Chart with Plain Base

    100% Chart with Gradient1 Base

    100% Chart with Gradient2 Base

    100% Chart with Gradient3 Base

    Sample Data

    Download the given sample data and map it as mentioned below to plot your Column chart:

    • Use the Year column as Category field, and the other columns as Series to plot data.

    Please Note: The Category field can be any data type line, string, or numeric. But, Series fields can be only numeric data type.

    Bubble Chart

    A Bubble chart visualizes data set in three of four dimensions where the first two dimensions are used as coordinates like X-Axis and Y-Axis. There remaining two are used to represent the color and size of the bubbles. It is used mostly to Plot financial data.

    Best Situation to use Bubble Chart

    Three Data Series

    If the data has three series each containing values, then the user can use a Bubble chart for better representation. Generally, the sizes of the Bubble are determined by the values.

    Default Chart Image

    Properties of the Bubble Chart

    General

    • Component Name: Assign a unique identifier to the Bubble chart component for easy reference. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left: Set the horizontal position of the chart within the display area.

    • Top: Define the vertical position of the chart in the display layout.

    • Height: Specify the height of the chart to ensure it fits within the designated space.

    Background

    The user can modify the Gradient properties such as Gradient Rotation, Opacity, and Gradient color using these Gradient properties fields.

    • Gradient Rotation: Modify the angle of the gradient to achieve the desired effect.

    • Opacity: Set the transparency level to balance visibility and aesthetics.

    • Gradient: Choose and customize the gradient colors to match your theme.

      • Click the

    Range Indicators

    The users get to set ranges and select colors for the ranges and Range Legends by using this Properties option. It is also possible to use Dynamic Range colors from the Range Properties window.

    • Click the Properties icon for Range Indicators.

    • The Range Properties window opens.

      • Click the Add Range option to insert a new range.

    • After setting the Range colors (manually or dynamically), Enable the Range Color Legend option.

    • Open the chart in the Preview mode.

    • Click the Legend icon.

    • A context menu opens displaying the names and color selection for the inserted ranges.

    Tooltip

    Tooltips enhance user interaction by displaying additional information about chart elements.

    • Show Tool Tip: Enable this option to display tooltips for the chart series, providing descriptions or data insights.

      • Click the Show Tool Tip icon to access the Tool Tip Configuration window.

      • Select the Default option.

    Please Note: To use the Custom option for the Tool Tip configuration, please refer to the page.

    Title

    • Title Box Color: Choose the background color for the title box.

    • Show Title Box: Enable or disable the display of the title box on the chart.

    • Show Title: Enable or disable the display of the title text.

    • Title Bar Height: Set the height of the title bar.

    Subtitle

    • Show Sub Title: Enable or disable the display of the sub-title text.

    • Description: Add a description text below the sub-title.

    • Font Color: Select the color of the sub-title text.

    • Font Size: Specify the size of the sub-title text.

    X-Axis

    • Show X-Axis Line: Toggle the visibility of the X-axis line through this field.

    • X-Axis Line Color: Select the color for the X-axis line.

    • Label Font Color: Choose the font color for X-axis labels.

    • Label Font Size: Specify the size of the font for X-axis labels.

    Y-Axis

    • Show Y-Axis Line: Toggle the visibility of the Y-axis line.

    • Y-Axis Line Color: Select the color for the Y-axis line.

    • Label Font Color: Choose the font color for Y-axis labels.

    • Label Font Size: Specify the size of the font for Y-axis labels.

    Legend

    • Show Legend: Toggle the visibility of the chart legend.

    • Font Color: Choose the font color for the legend text.

    • Font Weight: Determine the weight (boldness) of the legend text.

    • Font Size: Specify the size of the font for the legend text.

    Formatter

    • Unit: Define the unit of measurement for the values displayed in the chart.

    • Precision: Set the number of decimal places to display for numerical values.

    • Currency: Format the numbers as a currency with the appropriate symbol.

    • Position: Determine the position of the formatted value (e.g., before or after the number).

    Axis Setup

    • Auto Axis Setup: Automatically adjust the axis settings based on the dataset.

    • Base Zero: Ensure the axis starts at zero for better data comparison.

    • Min Value: Define the minimum value displayed on the axis.

    • Max Value: Set the maximum value for the axis range.

    Alerts

    The Alerts properties allow the users to enable the color bands by using the checkbox based on the set Band Properties.

    • Navigate to the Alerts properties.

    • Click the Band Properties icon.

    • The Band Colors window opens.

    • Click the Add Color Band option to insert a new color band to the list.

    • The user can modify:

    • The Color Bands get added to the chart based on the set Band properties.

    Export Options

    • Enable Context Menu: Activate a right-click context menu for quick access to export options in the preview mode of the chart.

    • Export Excel: Save the chart data in an Excel file format (.xlsx).

    • Export CSV: Export the chart data into a CSV file format (.csv).

    • Export JPEG: Export the chart as a JPEG image (.jpg).

    The user can get the Export Context Menu from the preview mode to download the reports in different export formats.

    Dataset Series properties

    The user can change the color of each series by selecting any of the series and also, we can Enable the Data Label which shows the Value of each Revenue & Expense.

    Various Variants of the Bubble chart

    It is possible to get the following variants of the Bubble chart by changing the Properties:

    Bubble Chart with Gradient Base

    Bubble Chart with Plain Base

    Bubble Chart with Ring Base

    Sample Data

    Download the given sample data and map it as mentioned below to plot your Bubble chart:

    • Use the Year column as a Category field and the other columns as Series to plot data.

    Please Note: The Category field can be any data type line, string, or numeric. However, series fields can only be numeric data types.

    sdk.getWidget( 'map2').m_drawTripPath = true; // for linesdk.getWidget( 'map2').m_svgicons = false;var comp = sdk.getWidget( 'map2' );comp.m_mapoptions.center = [44.91209,8.60492];comp.m_mapoptions.zoom =50;//for changing start & end markers & its colorcomp.m_markericon.icon="bd-car";comp.m_startcolor = "#21f110";comp.m_endcolor = "#12e925";//for changing path colorcomp.m_pathcolor = "#bf404d";//for changing path markers & its colorcomp.m_pathicon.icon= "bd-location";comp.m_pathicon.color="#d62728";​
    sdk.getWidget(‘map1).m_geometrytype = “circle”
    sdk.getWidget(‘map1’).m_showmarker = trueva
    sdk.getWidget(‘map1’).m_circleindex = 21;

    Width: Set the width of the chart in pixels.

  • Initial Visibility: Check this option to enable the chart's visibility upon the initial load.

  • Max Button: Enable or disable the maximization button for expanding the chart view.

  • Color From Drill: Allow the chart to inherit colors from a drill-down operation.

  • Base Type: Select the base shape of the columns, such as a Rectangle, Cylinder, Plain, Gradient 1, Gradient 2, or Gradient 3.

  • Chart Type: Choose the chart’s layout, such as Stacked, Clustered, Overlaid, or 100%.

  • Bar Size: Adjust the width of the bars within the chart.

  • Put a checkmark in the box to enable the component formatter.
  • Click the Save option to display Tool Tip in the default display.

  • Background Color: Choose a background color for the tooltip to enhance visibility and match your visual theme.

  • Opacity: Adjust the tooltip's transparency to ensure it doesn't obstruct important chart elements while remaining readable.

  • Border Color: Select a border color that complements the tooltip, ensuring clarity and contrast against the chart background.

  • Tooltip Font Size: Customize the font size to maintain readability, adapting it to the overall chart presentation.

  • Box Width: Define the width of the tooltip box to ensure it fits the content appropriately and maintains a neat appearance.

  • Precision: Set the numerical precision for data values displayed in the tooltip, aiding in clearer data interpretation.

  • Highlighter: Toggle the highlighter to emphasize specific data points on the chart, drawing user attention to crucial information.

  • Gradient
    icon to access the
    Background gradient colors
    dialog box.
  • Click the Add Color option to add multiple colors.

  • Click the Save option to apply the selected background colors.

  • Border: Add a border around the chart for a defined perimeter.

  • Border Color: Alter the border color to complement or contrast with the chart.

  • Border Radius: Round the corners of the chart border for a smoother look.

  • Shadow: Enable shadows to create depth and a 3D-like effect.

  • Shadow Color: Customize the shadow color to blend naturally with the chart.

  • Shadow Transparency: Adjust the transparency level to control the intensity of the shadow effect.

  • Description: Add a description text below the title.

  • Font Color: Select the color of the title text.

  • Font Size: Specify the size of the title text.

  • Font Style: Choose a Font style using the drop-down menu (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the title text from the given choices.

  • Align: Align the title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the title text.

  • Show Dataset Description: Enable or disable the dataset description in the title.

  • Font Style: Choose the font style for the Sub-title (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the sub-title text from the given choices.

  • Align: Align the sub-title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the sub-title text.

  • Label Font Style: Set the style (e.g., italic) for X-axis labels.

  • Label Font Weight: Determine the weight (e.g., bold) for X-axis label fonts.

  • Label Font Family: Choose the font family for X-axis labels.

  • Label Decoration: Add decorations (e.g., underline) to X-axis labels.

  • Label Rotation: Set the rotation angle for X-axis labels.

  • Tilted Label: Enable to tilt X-axis labels for better readability.

  • Description: Add a description for the X-axis.

  • Font Color: Specify the color of the X-axis text.

  • Font Size: Set the font size for the X-axis text.

  • Font Style: Choose the font style (e.g., italic) for X-axis text.

  • Font Weight: Determine the weight (boldness) of the X-axis text.

  • Font Family: Select the font family for the X-axis text.

  • Text Decoration: Add text decorations (e.g., underline) to the X-axis labels.

  • Category Tick Marks: Activate tick marks for categories on the X-axis.

  • Marker Color: Choose the color of the markers on the X-axis.

  • Show Dataset Description: Toggle the visibility of dataset descriptions on the X-axis.

  • Label Font Style: Set the style (e.g., italic) for Y-axis labels.

  • Label Font Weight: Determine the weight (e.g., bold) for Y-axis label fonts.

  • Label Font Family: Choose the font family for Y-axis labels.

  • Label Decoration: Add decorations (e.g., underline) to Y-axis labels.

  • Description: Add a description for the Y-axis.

  • Font Color: Specify the color of the Y-axis text.

  • Font Size: Set the font size for the Y-axis text.

  • Font Style: Choose the font style (e.g., italic) for Y-axis text.

  • Font Weight: Determine the weight (boldness) of the Y-axis text.

  • Font Family: Select the font family for the Y-axis text.

  • Text Decoration: Add text decorations (e.g., underline) to the Y-axis labels.

  • Show Dataset Description: Toggle the visibility of dataset descriptions on the Y-axis.

  • Font Family: Select the font family for the legend text.

  • Font Style: Choose the font style (e.g., italic) for the legend text.

  • Text Decoration: Add text decorations (e.g., underline) to the legend text.

  • Hide on Load: Determine if the legend should be hidden when the chart initially loads.

  • Number Formatter: Apply a specific notation or style to the numbers (e.g., Indian, International).

    Horizontal Marker Line: Add a horizontal line at a specified value for reference.

  • Vertical Marker Line: Place a vertical line at a specific point for highlighting.

  • Zero Marker Line: Include a line at zero to emphasize the baseline.

  • Zero Marker Color: Customize the color of the zero marker line.

  • Color: Set a color for the marker line.

  • Opacity: Adjust the color transparency of the axis marker line.

  • Export PNG: Export the chart as a PNG image (.png).

  • Export PPT: Export the chart to a PowerPoint presentation (.pptx).

  • Export PDF: Export the chart as a PDF document (.pdf).

  • Show Print: Include an option to print the chart directly.

  • Export Heading: Add a custom heading to the exported file.

  • Export Sub Heading: Add a custom subheading to the exported file.

  • Export File Name: Specify the file name for the exported file/dashboard.

  • Global Export Type: Define the default export format using the drop-down (e.g., Screenshot, Tabular).

  • Tooltip (Default & Custom)
    8KB
    Sample Data_Column chart.xlsx
    Open
    Accessing the Export Context menu in Preview
  • Width: Determine the width of the chart to maintain proper aspect ratio and visibility.

  • Initial Visibility: Choose whether the chart is visible when the dashboard or report initially loads.

  • Max Button: Enable a button allowing users to maximize the chart for a larger view.

  • Color From Drill: Use this to apply colors based on the current drill-down state for better data differentiation.

  • Shadow: Enable and configure the shadow effect to add depth to the chart's appearance.

  • Base Type: Assign a base data type or category to dictate chart structure and data mapping.

  • Luminance: Adjust the bubble luminance to impact the visibility and contrast in the chart.

  • Gradient
    icon to access the
    Background gradient colors
    dialog box.
  • Click the Add Color option to add multiple colors.

  • Click the Save option to apply the selected background colors.

  • Border: Add a border around the chart for a defined perimeter.

  • Border Color: Alter the border color to complement or contrast with the chart.

  • Border Radius: Round the corners of the chart border for a smoother look.

  • Shadow: Enable shadows to create depth and a 3D-like effect.

  • Shadow Color: Customize the shadow color to blend naturally with the chart.

  • Shadow Transparency: Adjust the transparency level to control the intensity of the shadow effect.

    • Once the new Range gets added, the user can modify the Range Name, Range From, Range Up to limits, and Range Color.

    • The user also gets the option to Delete an existing Range.

    • Click the Save option to apply the selected Range Properties.

  • The users can also choose to apply dynamic colors to the bubble by selecting the Dynamic Range option.

  • Put a checkmark in the box to enable the component formatter.
  • Click the Save option to display Tool Tip in the default display.

  • Background Color: Choose a background color for the tooltip to enhance visibility and match your visual theme.

  • Opacity: Adjust the tooltip's transparency to ensure it doesn't obstruct important chart elements while remaining readable.

  • Border Color: Select a border color that complements the tooltip, ensuring clarity and contrast against the chart background.

  • Tooltip Font Size: Customize the font size to maintain readability, adapting it to the overall chart presentation.

  • Box Width: Define the width of the tooltip box to ensure it fits the content appropriately and maintains a neat appearance.

  • Precision: Set the numerical precision for data values displayed in the tooltip, aiding in clearer data interpretation.

  • Highlighter: Toggle the highlighter to emphasize specific data points on the chart, drawing user attention to crucial information.

  • Description: Add the title text.

  • Font Color: Select the color of the title text.

  • Font Size: Specify the size of the title text.

  • Font Style: Choose the font style (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the title text from the given choices.

  • Align: Align the title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the title text.

  • Font Style: Choose the font style for the Sub-title (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the sub-title text from the given choices.

  • Align: Align the sub-title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the sub-title text.

  • Label Font Style: Set the style (e.g., italic) for X-axis labels.

  • Label Font Weight: Determine the weight (e.g., bold) for X-axis label fonts.

  • Label Font Family: Choose the font family for X-axis labels.

  • Label Decoration: Add decorations (e.g., underline) to X-axis labels.

  • Label Rotation: Set the rotation angle for X-axis labels.

  • Tilted Label: Enable the X-axis labels to tilt for better readability.

  • Description: Add a description for the X-axis.

  • Font Color: Specify the color of the X-axis text.

  • Font Size: Set the font size for the X-axis text.

  • Font Style: Choose the font style (e.g., italic) for the X-axis text.

  • Font Weight: Determine the weight (boldness) of the X-axis text.

  • Font Family: Select the font family for the X-axis text.

  • Text Decoration: Add text decorations (e.g., underline) to the X-axis labels.

  • Category Tick Marks: Activate tick marks for categories on the X-axis.

  • Marker Color: Choose the color of the markers on the X-axis.

  • Show Dataset Description: Toggle the visibility of the dataset description on the X-axis.

  • Label Font Style: Set the style (e.g., italic) for Y-axis labels.

  • Label Font Weight: Determine the weight (e.g., bold) for Y-axis label fonts.

  • Label Font Family: Choose the font family for Y-axis labels.

  • Label Decoration: Add decorations (e.g., underline) to Y-axis labels.

  • Description: Add a description for the Y-axis.

  • Font Color: Specify the color of the Y-axis text.

  • Font Size: Set the font size for the Y-axis text.

  • Font Style: Choose the font style (e.g., italic) for Y-axis text.

  • Font Weight: Determine the weight (boldness) of the Y-axis text.

  • Font Family: Select the font family for the Y-axis text.

  • Text Decoration: Add text decorations (e.g., underline) to the Y-axis labels.

  • Font Family: Select the font family for the legend text.

  • Font Style: Choose the font style (e.g., italic) for the legend text.

  • Text Decoration: Add text decorations (e.g., underline) to the legend text.

  • Hide on Load: Determine if the legend should be hidden when the chart initially loads.

  • Number Formatter: Apply a specific notation or style to the numbers (e.g., Indian, International).

    Vertical Marker Line: Place a vertical line at a specific point for highlighting.

  • Horizontal Marker Line: Add a horizontal line at a specified value for reference.

  • Zero Marker Line: Include a line at zero to emphasize the baseline.

  • Zero Marker Color: Customize the color of the zero marker line.

  • Color: Choose the color for the axis and labels.

  • Opacity: Adjust the transparency of the axis and markers.

  • Band Name
  • Band Range

  • Band Color

  • Opacity

  • The user also gets an option to Remove the inserted Band details.

  • Click the Save option to save the details.

  • Use a checkmark provided for the Enable Color Bands option.

  • Export PNG: Export the chart as a PNG image (.png).

  • Export PPT: Export the chart to a PowerPoint presentation (.pptx).

  • Export PDF: Export the chart as a PDF document (.pdf).

  • Show Print: Include an option to print the chart directly.

  • Export Heading: Add a custom heading to the exported file.

  • Export Sub Heading: Add a custom subheading to the exported file.

  • Export File Name: Specify the file name for the exported file/dashboard.

  • Global Export Type: Define the default export format using the drop-down (e.g., Screenshot, Tabular).

  • Tooltip (Default & Custom)
    9KB
    Sample Data_Bubble chart.xlsx
    Open
    Default Dataset Properties

    Line Chart

    Check out the below given walk-through on how to use the Line chart component in Designer module.

    A line chart or line plot or line graph or curve chart is a type of chart that displays information as a series of data points called 'markers' connected by straight line segments. It is a basic type of chart common in many fields. The Line charts connect individual numeric data points to create a sequence of values. They are primarily used to display trends over a period.

    Best Situations to Use a Line chart

    To view trends in data over a period.

    Example: To indicate increasing revenue or varying stock price

    Variations of this chart

    Mixed Chart- Combine a line graph with column charts to provide visual cues for further investigation.

    Example: A column chart representing the numeric score of students combined with the line chart corresponding proficiency score

    Default Chart Image

    Properties of the Line Chart

    General

    • Component Name: Specify a unique name for the chart component for easy identification and reference. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left: Set the horizontal position of the chart on the canvas.

    • Top: Set the vertical position of the chart on the canvas.

    • Height: Adjust the height of the chart for a preferred view.

    Threshold Settings

    Steps to configure the Threshold Settings:

    1. Open Threshold Settings: Navigate to the Threshold Settings section within the line chart Properties panel.

    2. Configure Threshold Properties:

      • Show Threshold Line: Use a checkmark in the given box to display the threshold lines in the chart.

    Displaying Fill Threshold in a Line Chart

    • Access the Threshold Settings section using the Line chart properties.

    • Put a checkmark in the Show Threshold Line option.

    • Set the Threshold 1 and Threshold 2 values.

    • Put a checkmark in the given box to Fill the Threshold.

    • Click the Fill Colors

    • The Threshold Fill window opens.

    • You may configure or modify the default information for the following options:

      • Level

      • Color

    • Preview: Check the updated line chart to verify that the threshold lines are correctly displayed. Adjust as necessary.

    Please Note: Click the Cancel option to remove the inserted details.

    Annotation Settings

    Check out the illustration on Annotation Settings for the Line chart.

    Steps to configure the Annotation Settings:

    Pre-requisites: Please create a data connection and map it with the Line chart. To make the data preview easy for the user, a Data Grid component has been mapped with the same data connection.

    1. Open Annotation Settings: Go to the Line chart Properties and locate the Annotation Settings section. Open it with a click.

    2. Configure Annotation: By providing the following information.

      1. Annotations: Put a checkmark in the given checkbox to enable the Annotations.

    1. Preview: Click the Preview icon to ensure the annotation appears correctly.

    1. The user can make any necessary adjustments by re-opening the Annotation Settings.

      1. Select a different color for the annotation lines using the color menu.

      2. Open the preview, the color of the annotation lines will be updated based on your selection in the chart.

    Please Note: Annotation mapping can be done with only CSV and Excel data.

    Tooltip

    The user who wants to show the series description can use the tooltip by enabling it.

    • The user can show the series description and get the tooltip by clicking the Show Tool Tip option.

      • The Tool Tip Configuration window opens.

      • Select any Tool Tip option. The supported Tool Tip is None, Default, Custom.

    • Background Color: Set the color that fills the tooltip's background to ensure it stands out or blends with your design.

    • Opacity: Control the transparency level of the tooltip, allowing for better integration with the chart's design and visibility of underlying elements.

    • Border Color: Define the color of the tooltip's border to highlight or subtly outline the content.

    • Tooltip Font Size

    Please Note:

    • The Custom option for Tool Tip Configuration opens with the following framework to configure a Tooltip.

    Background

    • Gradient Rotation: Modify the angle of the gradient to achieve the desired effect.

    • Opacity: Set the transparency level to balance visibility and aesthetics.

    • Gradient: Choose and customize the gradient colors to match your theme.

      • Click the

    Title

    • Title Box Color: Choose the background color for the title box.

    • Show Title Box: Enable or disable the display of the title box on the chart.

    • Show Title: Enable or disable the display of the title text.

    • Title Bar Height: Set the height of the title bar.

    Please Note: The Title will be added from the mapped dataset if the Show Dataset Description option is enabled.

    Subtitle

    • Show Sub Title: Enable or disable the display of the sub-title text.

    • Description: Add a description text below the sub-title.

    • Font Color: Select the color of the sub-title text.

    • Font Size: Specify the size of the sub-title text.

    X-Axis

    • Show X-Axis Line: Toggle the visibility of the X-axis line.

    • X-Axis Line Color: Select the color for the X-axis line.

    • Label Font Color: Choose the font color for X-axis labels.

    • Label Font Size: Specify the size of the font for X-axis labels.

    Y-Axis

    • Show Y-Axis Line: Toggle the visibility of the Y-axis line.

    • Y-Axis Line Color: Select the color for the Y-axis line.

    • Label Font Color: Choose the font color for Y-axis labels.

    • Label Font Size: Specify the size of the font for Y-axis labels.

    `

    Legend

    • Show Legend: Toggle the visibility of the chart legend.

    • Font Color: Choose the font color for the legend text.

    • Font Weight: Determine the weight (boldness) of the legend text.

    • Font Size: Specify the size of the font for the legend text.

    Formatter

    • Unit: Define the unit of measurement for the values displayed in the chart.

    • Precision: Set the number of decimal places to display for numerical values.

    • Currency: Format the numbers as a currency with the appropriate symbol.

    • Position: Determine the position of the formatted value (e.g., before or after the number).

    Axis Setup

    • Auto Axis Setup: Automatically adjust the axis settings based on the dataset.

    • Base Zero: Ensure the axis starts at zero for better data comparison.

    • Min Value: Define the minimum value displayed on the axis.

    • Max Value: Set the maximum value for the axis range.

    Export Options

    • Enable Context Menu: Activate a right-click context menu for quick access to export options in the preview mode of the chart.

    • Export Excel: Save the chart data in an Excel file format (.xlsx).

    • Export CSV: Export the chart data into a CSV file format (.csv).

    • Export JPEG: Export the chart as a JPEG image (.jpg).

    The user can get the Export Context Menu from the preview mode to download the reports in different export formats.

    Repeater

    The Repeater properties allow users to create dynamic and repetitive chart displays based on a specified category field. Here's a breakdown of the key fields within the Repeater properties:

    • Repeater: Enable this option to activate the feature for generating repetitive charts.

    • Group by Field: Choose the field by which the charts should be grouped. For instance, selecting the "Year" field will produce separate charts for each year.

    • No. of Columns: Define the number of columns to be used when arranging the repetitive charts.

    • Row Height: Specify the height of each row for the charts within the repeater.

    • The chart is displayed grouped by the selected field. In this case, the Year category is selected. Thus, the chart displays yearwise data separately.

    Dataset Series Properties

    The user can change the color of each series by selecting any of the series. The user can enable the Data Label to show the Value of each Revenue & Expense.

    Variants of the Line chart by changing the Properties

    Line Curve Chart

    Line Segment Chart

    Line Step Chart

    Line Reverse Step Chart

    Line Horizontal Chart

    Line Vertical Chart

    Sample Data

    Download the given sample data and map it as mentioned below to plot your Line chart.

    • Use the Year column as Category field, and other columns as Series to plot data.

  • Width: Adjust the width of the chart to fit your layout requirements.

  • Initial Visibility: Enable this option to ensure the chart is visible upon loading.

  • Max Button: Use this option to maximize the chart for a detailed view.

  • Color From Drill: Enable this option to get colors from the source data for consistent display upon drill down.

  • Points: Select this checkbox by deciding whether to show or hide points on the line.

  • Line Form: Choose the style of the line (Curve, Segment, Step, Reverse Step, Horizontal, Vertical) from the drop-down menu.

  • Threshold 1: Set a value for the upper threshold limit.
  • Threshold 2: Set a value for the lower threshold limit.

  • Fill Threshold: Use a checkmark in the given box to fill the color for the entire space between the threshold values.

  • Fill Colors: Choose colors for the threshold fill.

  • Preview: Check the updated line chart to verify that the threshold lines are correctly displayed. Adjust as necessary.

  • icon.

    Opacity

  • Label

  • Label Color

  • Click the Save option to save the inserted details.

  • Manage Annotation: Click the Manage Annotation icon to manage the Annotation Dataset by setting Connection, Label Field, and Annotation Field.

    1. Click the Save option to save the mapped Annotation details.

    2. Click the Reset option to reset the filled information.

  • Line Color: Select a color for the annotation lines.

  • Dash Line: Put a checkmark in the checkbox to draw lines with a dash pattern.

  • Line Width: Set the width of the annotation lines.

  • Line Opacity: Set the opacity of the annotation lines.

  • Tooltip Title: Provide a title to be displayed in the tooltip.

  • Click the Save option.

    : Adjust the text size within the tooltip for readability and emphasis.
  • Box Width: Specify the width of the tooltip box to accommodate content size and maintain a tidy layout.

  • Precision: Select the number of decimal places to display for numerical values within the tooltip, ensuring clarity and precision.

  • Highlighter: Use color indicators to highlight specific bars or data points within the tooltip, facilitating quick visual recognition.

  • To use the Custom option for the Tool Tip configuration, please refer to the Tooltip (Default & Custom) page.

    Gradient
    icon to access the
    Background gradient colors
    dialog box.
  • Click the Add Color option to add multiple colors.

  • Click the Save option to apply the selected background colors.

  • Border: Add a border around the chart for a defined perimeter.

  • Border Color: Alter the border color to complement or contrast with the chart.

  • Border Radius: Round the corners of the chart border for a smoother look.

  • Shadow: Enable shadows to create depth and a 3D-like effect.

  • Shadow Color: Customize the shadow color to blend naturally with the chart.

  • Shadow Transparency: Adjust the transparency level to control the intensity of the shadow effect.

  • Description: Add a description text below the title.

  • Font Color: Select the color of the title text.

  • Font Size: Specify the size of the title text.

  • Font Style: Choose a Font style using the drop-down menu (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the title text from the given choices.

  • Align: Align the title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the title text.

  • Show Dataset Description: Enable or disable the dataset description in the title.

  • Font Style: Choose the font style for the Sub-title (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the sub-title text from the given choices.

  • Align: Align the sub-title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the sub-title text.

  • Label Font Style: Set the style (e.g., italic) for X-axis labels.

  • Label Font Weight: Determine the weight (e.g., bold) for X-axis label fonts.

  • Label Font Family: Choose the font family for X-axis labels.

  • Label Decoration: Add decorations (e.g., underline) to X-axis labels.

  • Label Rotation: Set the rotation angle for X-axis labels.

  • Tilted Label: Enable to tilt X-axis labels for better readability.

  • Description: Add a description for the X-axis.

  • Font Color: Specify the color of the X-axis text.

  • Font Size: Set the font size for the X-axis text.

  • Font Style: Choose the font style (e.g., italic) for X-axis text.

  • Font Weight: Determine the weight (boldness) of the X-axis text.

  • Font Family: Select the font family for the X-axis text.

  • Text Decoration: Add text decorations (e.g., underline) to the X-axis labels.

  • Category Tick Marks: Activate tick marks for categories on the X-axis.

  • Marker Color: Choose the color of the markers on the X-axis.

  • Show Dataset Description: Toggle the visibility of dataset descriptions on the X-axis.

  • Label Font Style: Set the style (e.g., italic) for Y-axis labels.

  • Label Font Weight: Determine the weight (e.g., bold) for Y-axis label fonts.

  • Label Font Family: Choose the font family for Y-axis labels.

  • Label Decoration: Add decorations (e.g., underline) to Y-axis labels.

  • Description: Add a description for the Y-axis.

  • Font Color: Specify the color of the Y-axis text.

  • Font Size: Set the font size for the Y-axis text.

  • Font Style: Choose the font style (e.g., italic) for Y-axis text.

  • Font Weight: Determine the weight (boldness) of the Y-axis text.

  • Font Family: Select the font family for the Y-axis text.

  • Text Decoration: Add text decorations (e.g., underline) to the Y-axis labels.

  • Show Dataset Description: Toggle the visibility of dataset descriptions on the Y-axis.

  • Font Family: Select the font family for the legend text.

  • Font Style: Choose the font style (e.g., italic) for the legend text.

  • Text Decoration: Add text decorations (e.g., underline) to the legend text.

  • Hide on Load: Determine if the legend should be hidden when the chart initially loads.

  • Number Formatter: Apply a specific notation or style to the numbers (e.g., Indian, International).

    Horizontal Marker Line: Add a horizontal line at a specified value for reference.

  • Vertical Marker Line: Place a vertical line at a specific point for highlighting.

  • Zero Marker Line: Include a line at zero to emphasize the baseline.

  • Zero Marker Color: Customize the color of the zero marker line.

  • Color: Set a color for the marker line.

  • Opacity: Adjust the color transparency of the axis marker line.

  • Export PNG: Export the chart as a PNG image (.png).

  • Export PPT: Export the chart to a PowerPoint presentation (.pptx).

  • Export PDF: Export the chart as a PDF document (.pdf).

  • Show Print: Include an option to print the chart directly.

  • Export Heading: Add a custom heading to the exported file.

  • Export Sub Heading: Add a custom subheading to the exported file.

  • Export File Name: Specify the file name for the exported file/dashboard.

  • Global Export Type: Define the default export format using the drop-down (e.g., Screenshot, Tabular).

  • Column Margin: Set the margin between columns in the repetitive chart layout.

  • Row Margin: Define the margin between rows to ensure proper spacing between the repetitive charts.

  • 9KB
    Sample Data _Line chart.xlsx
    Open
    Threshold lines without Fill
    Threshold lines with Fill
    Accessing the Annotation Settings Properties for a line chart

    Bar Chart

    Bar Charts are useful for comparing classes or groups of data. They are one of the most commonly used types of graphs because they are simple to create and very easy to interpret. Several variations are included in the standard bar chart like stacked bar charts, grouped bar charts, and horizontal bar charts.

    Best Situations to Use Bar Chart

    • To interpret small data sets.

    • Users can perform observations over a period.

    • Examples: Quarterly sales of an organization, Percentage of change in sales or revenue.

    Variations of this chart

    • Use stacked bar charts: Where multiple categories can be clubbed together on top of each other, which makes addressing multiple questions easy.

    • Use bars side by side: Where comparison between multiple categories becomes easier instead of toggling between charts.

    • Add color for quick insight: Displaying the bars with colors will make users pay quick attention to important tasks.

    Default Visualization of the Chart

    Properties of the Bar Chart

    General

    The General Properties panel allows you to modify the core attributes of the Bar chart. Here are the fields available:

    • Component Name: Assign a unique identifier to the chart for easy reference. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left: Specify the left position coordinate of the chart component on the canvas.

    • Top: Indicate the top position coordinate for the chart placement.

    • Height: Set the height of the chart to determine its vertical size.

    Slider

    A slider has been added to the Bar chart to adjust and view a specific subset of data based on the selected range. It enhances data visualization by enabling dynamic control over the displayed data, making analyzing various sections of a Bar chart easy.

    The following are the Slider properties provided under the Designer charting properties panel:

    • Show Slider: Enable or disable the Show Slider option to display or hide the slider on the chart.

    • Slider Color: Set the slider color to customize the slider’s appearance.

    • Slider Width Ratio: Adjust the Slider Width Ratio to control the thickness of the slider.

    • Slider Range

    Threshold Settings

    Steps to Configure the Threshold Settings:

    1. Open Threshold Settings: Navigate to the Threshold Settings section within the bar chart Properties panel.

    2. Configure Threshold Properties:

      • Show Threshold Line: Use a checkmark in the given box to display the threshold lines in the chart.

    Displaying Fill Threshold in a Bar chart

    • Access the Threshold Settings section using the Bar chart properties.

    • Put a checkmark in the Show Threshold Line option.

    • Set the Threshold 1 and Threshold 2 values.

    • The Threshold Fill window opens.

    • You may configure or modify the default information for the following options:

      • Level

      • Color

    • Preview: Check the updated bar chart to verify that the threshold lines are correctly displayed. Adjust as necessary.

    Please Note: Click the Cancel option to remove the inserted details.

    Background

    • Gradient Rotation: Modify the angle of the gradient to achieve the desired effect.

    • Opacity: Set the transparency level to balance visibility and aesthetics.

    • Gradient: Choose and customize the gradient colors to match your theme.

      • Click the

    Tooltip

    Tooltips enhance user interaction by displaying additional information about chart elements.

    • Show Tool Tip: Enable this option to display tooltips for the chart series, providing descriptions or data insights.

      • Click the Show Tool Tip icon to access the Tool Tip Configuration window.

      • Select the Default option.

    Please Note: To use the Custom option for the Tool Tip configuration, please refer to the page.

    Title

    • Title Box Color: Choose the background color for the title box.

    • Show Title Box: Enable or disable the display of the title box on the chart.

    • Show Title: Enable or disable the display of the title text.

    • Title Bar Height: Set the height of the title bar.

    Please Note: If the Show Dataset Description option is enabled, the Title description will be displayed based on the Dataset. In this scenario, the title description provided by the user won't reflect in the chart.

    Please Note: By enabling the Show Dataset Description option the Title will be added from the mapped dataset.

    Subtitle

    • Show Sub Title: Enable or disable the display of the sub-title text.

    • Description: Add a description text below the sub-title.

    • Font Color: Select the color of the sub-title text.

    • Font Size: Specify the size of the sub-title text.

    X-Axis

    • Show X-Axis Line: Toggle the visibility of the X-axis line through this field.

    • X-Axis Line Color: Select the color for the X-axis line.

    • Label Font Color: Choose the font color for X-axis labels.

    • Label Font Size: Specify the size of the font for X-axis labels.

    Y-Axis

    • Show Y-Axis Line: Toggle the visibility of the Y-axis line.

    • Y-Axis Line Color: Select the color for the Y-axis line.

    • Label Font Color: Choose the font color for Y-axis labels.

    • Text Wrap: Put a checkmark in the box to wrap the text.

    Legend

    • Show Legend: Toggle the visibility of the chart legend.

    • Font Color: Choose the font color for the legend text.

    • Font Weight: Determine the weight (boldness) of the legend text.

    • Font Size: Specify the size of the font for the legend text.

    Formatter

    • Unit: Define the unit of measurement for the values displayed in the chart.

    • Precision: Set the number of decimal places to display for numerical values.

    • Currency: Format the numbers as a currency with the appropriate symbol.

    • Position: Determine the position of the formatted value (e.g., before or after the number).

    Axis Setup

    • Auto Axis Setup: Automatically adjust the axis settings based on the dataset.

    • Base Zero: Ensure the axis starts at zero for better data comparison.

    • Min Value: Define the minimum value displayed on the axis.

    • Max Value: Set the maximum value for the axis range.

    Export Option

    • Enable Context Menu: Activate a right-click context menu for quick access to export options in the preview mode of the chart.

    • Export Excel: Save the chart data in an Excel file format (.xlsx).

    • Export CSV: Export the chart data into a CSV file format (.csv).

    • Export JPEG: Export the chart as a JPEG image (.jpg).

    • The user can get the Export Context Menu from the preview mode to download the reports in different export formats.

    Dataset Series properties

    The user can change the color of each series by selecting any of the series and enabling the Data Label which shows the Value of each Revenue & Expense.​

    Modified Dataset Pallet Properties

    Various Variants of Bar Chart

    It is possible to get the following variants of the Bar chart by changing the Properties.

    Clustered Charts

    Clustered Chart with Plain Base

    Clustered Chart with Rectangle Base

    Clustered Chart with Chevron Base

    Clustered Chart with Gradient1 Base

    Clustered Chart with Gradient2 Base

    Clustered Chart with Gradient3 Base

    Stacked Charts

    Sacked Chart with Plain Base

    Stacked Chart with Rectangle Base

    Stacked Chart with Chevron Base

    Stacked Chart with Gradient1 Base

    Stacked Chart with Gradient2 Base

    Stacked Chart with Gradient3 Base

    Overlaid Charts

    Overlaid Chart with Plain Base

    Overlaid Chart with Rectangle Base

    Overlaid Chart with Chevron Base

    Overlaid Chart with Gradient1 Base

    Overlaid Chart with Gradient2 Base

    Overlaid Chart with Gradient3 Base

    100% Charts

    100% Chart with Plain Base

    100% Chart with Rectangle Base

    100% Chart with Chevron Base

    100% Chart with Gradient1 Base

    100% Chart with Gradient2 Base

    100% Chart with Gradient3 Base

    Sample Data

    Download the given sample data and map it as mentioned below to plot your Bar chart:

    • Use the Year column as Category field and the other columns as Series to plot data as shown in the given examples below:

    Please Note: The Category field can be any data type line, string, or numeric. But, Series fields can be only numeric data type.

    Plot data on both axes: Data can be plotted on positive and negative axes to identify the trends.
  • Width: Adjust the width of the chart to control its horizontal dimension.

  • Initial Visibility: Enable to ensure the chart appears during the initial preview.

  • Max Button: Enable or disable the max button to allow users to maximize the chart for a more detailed view.

  • Color From Drill: Enable this option to choose whether the colors displayed should derive from drill-down operations.

  • Base Type: Select the base type for bar categorization in the chart.

  • Chart Type: Define the overall chart type, such as stacked or side by side, for displaying data.

  • Bar Size: Configure the size of each bar to adjust spacing and appearance.

  • Actions: Enable this option to get the actions icon to interact with the chart in the preview mode.

  • Animation: Enable animations for the chart to enhance visual transitions and user engagement.

  • : Define the
    Slider Range
    to set the minimum and maximum values for the slider.
  • Slider Range Value: Use the Slider Range Value to specify the current value within the slider range.

  • Slider Position: Change the Slider Position to move the slider to a desired location on the chart.

  • Border Opacity: Control the Border Opacity to adjust the transparency of the slider's border.

  • Selection Opacity: Adjust the transparency of the selected portion of the slider.

  • Container Opacity: Control the transparency of the slider's container.

  • Show Slider Text: Enable or disable the text display on the slider.

  • Default Slider Size: Set the default size of the slider for the initial display.

  • Threshold 1: Set a value for the upper threshold limit.
  • Threshold 2: Set a value for the lower threshold limit.

  • Fill Threshold: Use a checkmark in the given box to fill the color for the entire space between the threshold values.

  • Fill Color: Choose colors for the threshold fill.

  • Preview: Check the updated bar chart to verify that the threshold lines are correctly displayed. Adjust as necessary.

  • Put a checkmark in the given box to Fill the Threshold.
  • Click the Fill Colors icon.

  • Opacity

  • Label

  • Label Color

  • Click the Save option to save the inserted details.

  • Gradient
    icon to access the
    Background gradient colors
    dialog box.
  • Click the Add Color option to add multiple colors.

  • Click the Save option to apply the selected background colors.

  • Border: Add a border around the chart for a defined perimeter.

  • Border Color: Alter the border color to complement or contrast with the chart.

  • Border Radius: Round the corners of the chart border for a smoother look.

  • Shadow: Enable shadows to create depth and a 3D-like effect.

  • Shadow Color: Customize the shadow color to blend naturally with the chart.

  • Shadow Transparency: Adjust the transparency level to control the intensity of the shadow effect.

  • Stack Border Color: Choose the border color that enhances the visual distinction of the stack within the chart.

  • Stack Border Width: Define the thickness of the stack border. Adjusting this value can emphasize the stack separation.

  • Stack Border Radius: Round the edges of the stack border for a softer appearance. This can provide a more polished and cohesive look to the chart elements.

  • Put a checkmark in the box to enable the component formatter.
  • Click the Save option to display Tool Tip in the default display.

  • Background Color: Choose a background color for the tooltip to enhance visibility and match your visual theme.

  • Opacity: Adjust the tooltip's transparency to ensure it doesn't obstruct important chart elements while remaining readable.

  • Border Color: Select a border color that complements the tooltip, ensuring clarity and contrast against the chart background.

  • Tooltip Font Size: Customize the font size to maintain readability, adapting it to the overall chart presentation.

  • Box Width: Define the width of the tooltip box to ensure it fits the content appropriately and maintains a neat appearance.

  • Precision: Set the numerical precision for data values displayed in the tooltip, aiding in clearer data interpretation.

  • Highlighter: Toggle the highlighter to emphasize specific data points on the chart, drawing user attention to crucial information.

  • Description: Add a description text below the title.

  • Font Color: Select the color of the title text.

  • Font Size: Specify the size of the title text.

  • Font Style: Choose the font style (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the title text from the given choices.

  • Align: Align the title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the title text.

  • Show Dataset Description: Enable or disable the dataset description in the title.

  • Font Style: Choose the font style for the Sub-title (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the sub-title text from the given choices.

  • Align: Align the sub-title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the sub-title text.

  • Label Font Style: Set the style (e.g., italic) for X-axis labels.

  • Label Font Weight: Determine the weight (e.g., bold) for X-axis label fonts.

  • Label Font Family: Choose the font family for X-axis labels.

  • Label Decoration: Add decorations (e.g., underline) to X-axis labels.

  • Label Rotation: Set the rotation angle for X-axis labels.

  • Tilted Label: Enable to tilt X-axis labels for better readability.

  • Description: Add a description for the X-axis.

  • Font Color: Specify the color of the X-axis text.

  • Font Size: Set the font size for the X-axis text.

  • Font Style: Choose the font style (e.g., italic) for X-axis text.

  • Font Weight: Determine the weight (boldness) of the X-axis text.

  • Font Family: Select the font family for the X-axis text.

  • Text Decoration: Add text decorations (e.g., underline) to the X-axis labels.

  • Show Dataset Description: Toggle the visibility of dataset descriptions on the X-axis.

  • Label Font Size: Specify the size of the font for Y-axis labels.

  • Label Font Style: Set the style (e.g., italic) for Y-axis labels.

  • Label Font Weight: Determine the weight (e.g., bold) for Y-axis label fonts.

  • Label Font Family: Choose the font family for Y-axis labels.

  • Label Decoration: Add decorations (e.g., underline) to Y-axis labels.

  • Description: Add a description for the Y-axis.

  • Font Color: Specify the color of the Y-axis text.

  • Font Size: Set the font size for the Y-axis text.

  • Font Style: Choose the font style (e.g., italic) for Y-axis text.

  • Font Weight: Determine the weight (boldness) of the Y-axis text.

  • Font Family: Select the font family for the Y-axis text.

  • Text Decoration: Add text decorations (e.g., underline) to the Y-axis labels.

  • Category Tick Marks: Put a checkmark in the box to enable the category tick marks.

  • Marker Color: Specify a marker color using the color pallet.

  • Show Data Set Description: Toggle the visibility of dataset descriptions on the Y-axis.

  • Font Family: Select the font family for the legend text.

  • Font Style: Choose the font style (e.g., italic) for the legend text.

  • Text Decoration: Add text decorations (e.g., underline) to the legend text.

  • Hide on Load: Determine if the legend should be hidden when the chart initially loads.

  • Number Formatter: Apply a specific notation or style to the numbers (e.g., Indian, International).

    Vertical Marker Line: Place a vertical line at a specific point for highlighting.

  • Horizontal Marker Line: Add a horizontal line at a specified value for reference.

  • Zero Marker Line: Include a line at zero to emphasize the baseline.

  • Zero Marker Color: Customize the color of the zero marker line.

  • Color: Choose the color for the axis and labels.

  • Opacity: Adjust the transparency of the axis and markers.

  • Export PNG: Export the chart as a PNG image (.png).

  • Export PPT: Export the chart to a PowerPoint presentation (.pptx).

  • Export PDF: Export the chart as a PDF document (.pdf).

  • Show Print: Include an option to print the chart directly.

  • Export Heading: Add a custom heading to the exported file.

  • Export Sub Heading: Add a custom subheading to the exported file.

  • Export File Name: Specify the file name for the exported file/dashboard.

  • Global Export Type: Define the default export format using the drop-down (e.g., Screenshot, Tabular).

  • Tooltip (Default & Custom)
    10KB
    Sample Data_Bar chart.xlsx
    Open
    Threshold lines without Fill
    Threshold lines with Fill
    Export Context Menu in the Preview Mode
    Annotation Settings in the Line chart

    Mixed Chart

    Check out the walk-through on how to use the Mixed chart component in the Designer module.

    The mixed chart is a combination of a Line chart and a Column chart. It can plot a 3-series of data on the chart. Mainly used to emphasize a different series of information on the chart.

    Best Situations to Use a Mixed Chart

    To compare multiple categories Example: To analyze the company's budget v/s revenue.

    Variations of this chart

    • Use stacked Column charts: Where multiple categories can be clubbed together on top of each other which makes addressing multiple questions easier.

    • Use columns side by side: Where comparison between multiple categories becomes easier instead of toggling between charts and data.

    • Add color for quick insight: Where displaying columns with colors will make users pay quick attention to important tasks.

    Default Mixed Chart Image

    Properties of the Mixed chart

    General

    The Mixed chart offers a versatile way to represent data visually with the following configurable properties:

    • Component Name: Set a unique name for the component identification. This field contains an auto-generated name indicating the sequence of the component in the dashboard.

    • Left: Adjust this setting to position the chart horizontally on the canvas, ensuring it fits within your desired layout.

    • Top: Controls the vertical placement of the chart on the canvas, allowing for precise alignment with other components.

    Each of these properties offers a degree of customization, enabling you to tailor the Mixed chart to best fit your presentation needs and aesthetic considerations.

    Threshold Settings

    Threshold properties allow users to set visual indicators within the Mixed chart to highlight specific data ranges. By configuring these properties, you can enhance data interpretation and visualization.

    • Show Threshold Line: Enable this to draw lines at threshold values, helping users identify critical data points at a glance.

    • Threshold 1: Define the upper-value limit, serving as the maximum critical point in the dataset.

    • Threshold 2: Specify the lower value limit, indicating the minimum important point for analysis.

    • Fill Threshold: Opt to fill the area between the threshold lines with color to emphasize this range.

    • Preview: Click the Preview icon to preview the updated Mixed chart. Check the updated mixed chart to verify that the threshold lines are correctly displayed. Adjust as necessary.

    Displaying Fill Threshold in a Mixed chart

    • Access the Threshold Settings section using the Mixed chart properties.

    • Put a checkmark in the Show Threshold Line option.

    • Set the Threshold 1 and Threshold 2 values.

    • The Threshold Fill window opens.

    • You may configure or modify the default information for the following options:

      • Level

      • Color

    • Preview: Click the Preview icon to preview the updated Mixed chart. Check the updated mixed chart to verify that the threshold lines are correctly displayed. Adjust as necessary.

    Please Note: Click the Cancel option to remove the inserted details.

    Annotation Settings

    Annotation lines in a chart are used to highlight specific points or thresholds for easier analysis and interpretation. They typically represent key events, milestones, or significant values that help provide context or draw attention to important aspects of the data. Annotation Settings allow users to annotate important dates in a chart.

    Steps to configure the Annotation Settings:

    1. Open Annotation Settings: Go to the Mixed Chart Properties and locate the Annotation Settings section. Open it with a click.

    2. Configure Annotation: By providing the following information.

      1. Annotations: Put a checkmark in the given checkbox to enable the Annotations.

    Please Note: Annotation mapping can be done with only CSV and Excel data.

    Tooltip

    The tooltip properties allow customization of the information displayed when hovering over chart elements:

    • The user can show the series description and get the tooltip by clicking the Show Tool Tip option.

      • The Tool Tip Configuration window opens.

      • Select any Tool Tip option. The supported Tool Tip is None, Default, Custom.

    Please Note: To use the Custom option for the Tool Tip configuration, please refer to the page.

    Background

    The background properties offer customization for the chart's appearance:

    • Gradient Rotation: Adjust the angle of the gradient color applied to the chart background.

    • Opacity: Control the overall transparency level of the chart background.

    • Gradient: Enable or disable the use of gradient colors for the chart background. By clicking the gradient option, a Background gradient colors window opens to add more colors.

    Title

    • Title Box Color: Choose the background color for the title box.

    • Show Title Box: Enable or disable the display of the title box on the chart.

    • Show Title: Enable or disable the display of the title text.

    • Title Bar Height: Set the height of the title bar.

    Please Note: By enabling the Show Dataset Description option the Title will get added from the mapped dataset.

    Subtitle

    • Show Sub Title: Enable or disable the display of the subtitle text.

    • Description: Add descriptive text below the subtitle.

    • Font Color: Choose the color for the subtitle text.

    • Font Size: Set the size of the subtitle text.

    X-Axis

    • Show X-Axis Line: Enable or disable the visibility of the X-Axis line.

    • X-Axis Line Color: Select the color for the X-Axis line.

    • Label Font Color: Choose the color for the labels on the X-Axis.

    • Label Font Size: Set the font size of the X-Axis labels.

    Y-Axis

    • Show Y-Axis Line: Enable or disable the visibility of the Y-Axis line.

    • Y-Axis Line Color: Select the color for the Y-Axis line.

    • Label Font Color: Choose the color for the labels on the Y-axis.

    • Label Font Size: Set the font size for the Y-Axis labels.

    Legend

    • Show Legend: Toggle the visibility of the legend in the chart.

    • Font Color: Select the color of the text in the legend.

    • Font Weight: Determine the boldness of the legend text, offering options such as normal, bold, or numerical values like 300 or 600.

    • Font Size: Set the size of the text displayed in the legend.

    Formatter

    • Unit: Specify the unit of measuring currency represented on the chart.

    • Precision: Define the number of decimal places to be displayed for numerical values to ensure accuracy and consistency.

    • Currency: Set the currency type for monetary values, allowing for consistent representation of financial data.

    • Position: Determine the placement of the formatted value about the axis or chart element, such as Prefix or Suffix.

    Second Axis

    The Second Axis provides enhanced control over your chart's data representation, allowing for dual-axis plotting and refined customization.

    • Second Axis: Put a checkmark in the box to get the Second Axis.

    • Unit: Specify the unit of measurement for data values on the second axis, ensuring clarity.

    • Precision: Set the number of decimal places for values on the second axis to maintain accuracy.

    • Currency: Define the currency type for monetary values, ensuring consistent financial representation.

    Axis Setup

    The Axis Setup section provides tools for configuring the appearance and functionality of both axes in your chart. This includes options for automatic settings, value range, and marker lines for enhanced data interpretation.

    • Auto Axis Setup: Automatically configures axis settings to best fit the data, saving time and ensuring optimal display.

    • Base Zero: Sets the starting point of the axis at zero, which can help in certain visualizations by providing a standard baseline.

    • Min Value: Allows manual specification of the minimum value displayed on the axis, giving control over the lower limit of the data range.

    • Max Value

    Export Options

    The Export Options section allows users to easily export their chart data in various formats for reporting and presentation purposes. This feature supports seamless integration with common applications and file types.

    • Enable Context Menu: Activates a context menu on the chart, providing quick access to export functions directly from the chart interface.

    • Export Excel: Allows the data to be exported as an Excel file, suitable for further analysis or sharing in a tabular format.

    • Export CSV: Exports data in CSV format, ideal for importing into databases or other data processing tools.

    • Export JPEG

    The user can get the Export Context Menu from the preview mode to download the reports in different export formats.

    Properties Tab from the Dataset Pallet

    Users can access a Properties tab under the Dataset pallet. This tab is accessible after mapping a data connection to the chart. Refer to the section for more details.

    Dataset Series Properties

    The Series field in the Dataset palette includes a Properties tab to configure key details like Field Name, Display Name, and Axis, along with options for Color, Chart Type (Line or Column), and Point Shape. If the Line chart type is selected, it also allows setting Line Width and Line Type.

    Variants of the Mixed chart by changing the Properties

    Various Stacked Chart & Segment Line

    Mixed Chart with Plain base Stacked Chart & Segment line

    Mixed Chart with Plain base Stacked Chart & Curve line

    Mixed Chart with Rectangle base Stacked Chart & Segment line

    Mixed Chart with Cylinder base Stacked Chart & Segment line

    Mixed Chart with Gradient1 base Stacked Chart & Segment line

    Mixed Chart with Gradient2 base Stacked Chart & Segment line

    Mixed Chart with Gradient3 base Stacked Chart & Segment line

    Clustered Chart & Segment Line

    Mixed Chart with Rectangle base Clustered Chart & Segment line

    Mixed Chart with Cylinder base Clustered Chart & Segment line

    Mixed Chart with Pain base Clustered Chart & Segment line

    Mixed Chart with Gradient1 base Clustered Chart & Segment line

    Mixed Chart with Gradient2 base Clustered Chart & Segment line

    Mixed Chart with Gradient3 base Clustered Chart & Segment line

    Overlaid Chart & Segment Line

    Mixed Chart with Rectangle base Overlaid Chart & Segment line

    Mixed Chart with Cylinder base Overlaid Chart & Segment line

    Mixed Chart with Plain base Overlaid Chart & Segment line

    Mixed Chart with Gradient1 base Overlaid Chart & Segment line

    Mixed Chart with Gradient2 base Overlaid Chart & Segment line

    Mixed Chart with Gradient3 base Overlaid Chart & Segment line

    100% Chart & Segment Line

    Mixed Chart with Rectangle base 100% Chart & Segment line

    Mixed Chart with Cylinder base 100% Chart & Segment line

    Mixed Chart with Plain base 100% Chart & Segment line

    Mixed Chart with Gradient1 base 100% Chart & Segment line

    Mixed Chart with Gradient2 base 100% Chart & Segment line

    Mixed Chart with Gradient3 base 100% Chart & Segment line

    Sample Data

    Download the given sample data and map it as mentioned below to plot your Mixed chart.

    Use the Year column as Category field, and other columns as Series to plot data.

    Height
    : Dictate the overall height of the chart, enabling you to tailor its size to match the visual context of your presentation.
  • Width: Modify this property to set the desired width of the chart, accommodating different amounts of data and emphasizing clarity.

  • Initial Visibility: Toggle this option to define whether the chart should be visible immediately upon display, aiding in managing viewability upon screen load.

  • Max Button: Includes an option to maximize the chart view, providing users with a focused layout for more detailed analysis.

  • Color From Drill: Activates color coding when drilling down within the data, offering a visual cue to assist in data navigation.

  • Points: Enable this feature to display distinct points on the chart's lines, highlighting specific data intervals or events.

  • Base Type: Choose the foundational chart type around which the mixed chart is built, determining the primary display format.

  • Chart Type: Select between different chart representations to best portray the data. Choose from Stacked, Clustered, Overlaid, and 100%.

  • Line Form: Offers a selector to decide on the line type for your chart, with options such as Curve or Segment to match the data trend.

  • Bar Size: Specify the dimensions of the bars in your chart, balancing between comprehensive display and clarity.

  • Fill Color: Select the color used for filling the threshold area, ensuring it contrasts well for easy visibility.

  • Put a checkmark in the given box to fill the threshold.
  • Click the Fill Colors icon.

  • Opacity

  • Label

  • Label Color

  • Click the Save option to save the inserted details.

  • Manage Annotation: Click the Manage Annotation icon to manage the Annotation Dataset by setting Connection, Label Field, and Annotation Field.

    1. Click the Save option to save the mapped Annotation details.

    2. Click the Reset option to reset the filled information.

  • Line Color: Select a color for the annotation lines.

  • Dash Line: Put a checkmark in the checkbox to draw lines with a dash pattern.

  • Line Width: Set the width of the annotation lines.

  • Line Opacity: Set the opacity of the annotation lines.

  • Tooltip Title: Provide a title to be displayed in the tooltip.

  • Preview: Click the Preview icon to ensure the annotation appears correctly.

  • The user can make any necessary adjustments by re-opening the Annotation Settings.

    1. Select a color for the annotation lines using the color menu and enable Dashlines.

    2. Open the preview, the color of the annotation lines will be updated based on your selection in the chart.

  • Put a checkmark in the box to enable the component formatter.
  • Click the Save option.

  • The user can show the series description and get the tooltip by clicking the Show Tool Tip option.

  • The Tool Tip Configuration window opens.

  • Select any Tool Tip option. The supported Tool Tip is None, Default, Custom.

  • Click the Save option.

  • Background Color: Choose the background color of the tooltip.

  • Opacity: Adjust the transparency level of the tooltip background.

  • Border Color: Select the border color for the tooltip box.

  • Tooltip Font Size: Customize the font size of the tooltip text.

  • Box Width: Modify the width of the tooltip box.

  • Precision: Set the number of decimal places shown in the tooltip.

  • Highlighter: Enable highlighting of data points when hovering over them.

  • Click the Gradient icon to access the Background gradient colors dialog box.
  • Click the Add Color option to add multiple colors.

  • Click the Save option to apply the selected background colors.

  • Border: Add a border around the chart for a defined perimeter.

  • Border Color: Select the color of the chart border.

  • Border Radius: Set the roundness of the chart border corners.

  • Shadow: Enable or disable the drop shadow effect for the chart.

  • Shadow Color: Choose the color of the shadow effect.

  • Shadow Transparency: Adjust the transparency level of the shadow effect.

  • Description: Add a description text below the title.

  • Font Color: Select the color of the title text.

  • Font Size: Specify the size of the title text.

  • Font Style: Choose the font style (e.g., italic or normal).

  • Font Weight: Set the weight (boldness) of the font. The supported options are Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the title text from the given choices.

  • Align: Align the title text (e.g., left, center, right).

  • Text Decoration: Apply text decorations (e.g., underline) to the title text.

  • Show Dataset Description: Enable or disable the dataset description in the title.

  • Font Style: Select the style of the subtitle text (e.g., italic or normal).

  • Font Weight: Define the weight (boldness) of the subtitle font, with options such as Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the subtitle text from the available options.

  • Align: Align the subtitle text (e.g., left, center, right).

  • Text Decoration: Apply decorations, such as underlining, to the subtitle text.

  • Label Font Style: Choose the style for the label text (e.g., italic or normal) on the X-Axis.

  • Label Font Weight: Define the boldness of the label text on the X-Axis, with options such as Normal, Bold, 300, 600, and 900.

  • Label Font Family: Select the font family for the X-Axis labels.

  • Label Decoration: Apply text decorations, such as underlining, to the X-Axis labels.

  • Label Rotation: Set the rotation angle for the X-Axis labels.

  • Tilted Label: Enable or disable tilted label orientation on the X-Axis.

  • Description: Add descriptive text related to the X-Axis.

  • Font Color: Choose the color for the additional description text on the X-Axis.

  • Font: Select the font family for the description text.

  • Size: Adjust the size of the description text related to the X-Axis.

  • Font Style: Choose the style for the description text (e.g., italic or normal).

  • Font Weight: Specify the boldness of the description text, with options such as Normal, Bold, 300, 600, and 900.

  • Font Family: Choose the font family for the description text on the X-Axis.

  • Text Decoration: Apply decorations, such as underlining, to the description text.

  • Category Tick Marks: Define the appearance of tick marks on the X-Axis for categories.

  • Marker Color: Select the color for markers on the X-Axis.

  • Show Dataset Description: Enable or disable the display of additional dataset descriptions on the X-Axis.

  • Label Font Style: Choose the style for the label text (e.g., italic or normal) on the Y-Axis.

  • Label Font Weight: Define the boldness of the label text on the Y-Axis, with options such as Normal, Bold, 300, 600, and 900.

  • Label Font Family: Select the font family for the Y-Axis labels.

  • Label Decoration: Apply text decorations, such as underlining, to the Y-Axis labels.

  • Description: Provide descriptive text related to the Y-Axis.

  • Font Color: Choose the color for the additional description text on the Y-Axis.

  • Font Size: Adjust the size of the description text related to the Y-axis.

  • Font Style: Choose the style for the description text (e.g., italic or normal).

  • Font Weight: Specify the boldness of the description text with various options.

  • Font Family: Choose the font family for the description text on the Y-Axis.

  • Text Decoration: Apply decorations, such as underlining, to the description text.

  • Show Dataset Description: Enable or disable the display of dataset descriptions on the Y-axis.

  • Font Family: Choose the font family for the legend text.

  • Font Style: Decide the style of the legend text, such as italic or normal.

  • Text Decoration: Apply text decorations, like underlining, to the legend text.

  • Hide on Load: Choose whether the legend will be initially hidden upon loading the chart.

  • Number Formatter: Customize how numbers are displayed (International or Indian).

  • Position: Choose how the values appear about the axis (as a Prefix or Suffix).

  • Number Formatter: Decide between International or Indian number formats for consistent display.

  • Auto Axis Setup: Enable automatic configuration of axis settings for convenience.

  • Base Zero: Option to start the second axis at zero, useful for certain data visualizations.

  • Min Value: Manually set the minimum values the second axis should display.

  • Max Value: Manually set the maximum values the second axis should display.

  • Second Axis Description: Provide a brief description to label the second axis, improving chart readability.

  • Font Color: Select the font color for labels and values on the second axis to match your design theme.

  • Font Size: Adjust the font for better visibility or stylistic purposes.

  • Font Style: Choose between normal or italicized text styles for axis labels.

  • Font Weight: Set the font weight (e.g., normal, bold, 300, 600, 900) to emphasize axis text.

  • Font Family: Choose a specific font family for a consistent look and feel.

  • Text Decoration: Apply decorations such as underlining for additional styling.

  • : Enables manual setting of the maximum value on the axis, ensuring all key data points are visible.
  • Horizontal Marker Line: Draws a horizontal line across the chart, used to indicate specific values or thresholds along the axis.

  • Vertical Marker Line: Adds a vertical line on the chart, useful for marking events or specific time points in the data.

  • Zero Marker Line: Emphasizes the zero value line on the axis, providing a visual reference for positive and negative values.

  • Zero Marker Color: Customize the color of the zero marker line to match your design theme or to highlight the zero threshold.

  • Second Axis Zero Marker: Similar to the primary axis zero marker, this is used to highlight the zero line on the secondary axis.

  • Second Axis Zero Marker Color: Sets the color for the secondary axis zero marker line, allowing differentiation from the primary axis.

  • Color: Defines the color of axis lines, aiding in visual consistency with the chart's overall theme.

  • Opacity: Adjusts the transparency of axis lines and markers, offering another layer of visual sophistication and focus.

  • : Provides the option to export the chart as a JPEG image, useful for creating static visual representations.
  • Export PNG: Similar to JPEG, but offers a lossless export option in PNG format for clearer image quality in visual presentations.

  • Export PPT: Facilitates exporting the chart directly into a PowerPoint file, streamlining the process of incorporating charts into slideshows.

  • Export PDF: Enables exporting the chart and its data in PDF format, suitable for creating shareable and print-ready documents.

  • Show Print: Displays a print button on the chart, allowing users to print the chart directly from the application.

  • Export Heading: Customizes the heading title for exported files, ensuring clarity and context when distributing chart data.

  • Export Sub Heading: Adds a secondary title or description to exported files, providing additional context or information.

  • Export File Name: Allows customization of the file name for the exported data, ensuring easy identification and organization.

  • Global Export Type: Sets a default export format for all charts, streamlining the export process across multiple datasets.

  • Tooltip (Default & Custom)
    Dataset Properties
    9KB
    Sample Data_Mixed chart.xlsx
    Open
    Default Series Properties
    Modified Series Properties