Governed Dashboards
  • About Dashboard Designer
    • What is Dashboard Designer?
    • Why is it used?
  • Getting Started
    • Accessing the Designer Module
    • Overview of Designer Module
      • Homepage
        • Guided Tour
        • Left Menu Panel
          • New
          • Manage
          • Open Dashboard
          • Preferences
          • Save As
          • Help
          • Exit
      • Dashboard Canvas Page
        • Right side Panel
          • Connection Page
          • Chart Container
          • Manage Window
          • Script Window
          • Guided Tour
        • Canvas Properties
        • Context Menu Properties
  • Create New Workspace
    • Workspace Creation: Complete Flow
    • Creating a Workspace
    • Renaming a Workspace
    • Deleting a Workspace
  • Create New Dashboard
    • Dashboard Creation: Complete Flow
    • Adding a New Dashboard
    • Create Connection
    • Drag and Drop Charts
    • Associate the Dataset
    • Preview the Dashboard
    • Save the Dashboard
    • User Alert Notification
  • Managing Options for a Dashboard
    • Open Dashboard in Designer
    • Publish a Dashboard
    • Share a Dashboard
    • Dashboard Version Control
    • Action Menu
      • Preview Dashboard
      • Export to Local Disk
      • Rename
      • Delete
      • Moving a Dashboard
      • Information Icon
      • Dashboard as Template
  • Connecting to a Data Source
    • Accessing the Data Connectors
    • Establishing a Data Connection
      • CSV Connection
      • Excel Connection
      • Data Service Connection
      • Data Science Service
      • Data Store Connection
      • Data Sheet
        • Data Sheet Enhancements
      • WebSocket Connection
      • Merged Connection
  • Charts Gallery
    • Charts
      • Area chart
      • Bar Chart
      • Bubble Chart
      • Circumplex Chart
      • Column Chart
      • Funnel Chart
      • Histogram Chart
      • Inverted Funnel
      • KPI Tile
      • Line Chart
      • Map Chart
      • Mito Plot
      • Mixed Chart
      • Pie Chart
      • Project Timeline
      • Pyramid Chart
      • Spark Line
      • Scatter Plot
      • Spider Chart
      • Waterfall Chart
    • Grids
      • Data Grid
      • Paging Grid
      • Data Sheet
      • Scorecard
      • Pivot Grid
    • Filters
      • Checkbox
      • Combobox
      • Hierarchical Combobox
      • List
      • Radio Button
    • Advanced Charts
      • Box Plot
      • Candle Stick
      • Chevron
      • Data Search
      • Decision Tree
      • Group Bar
      • Group Column
      • Heat Map
      • Text Analyzer
      • Time Series
      • Decomposition
      • Tree Map
      • Trellis
      • Word Cloud
    • Other Charts
      • Box
      • Bullet
      • Date Picker
      • Export
      • Filter Chips
      • Filter Saver
      • Gauge
      • Graphics
      • Guided Tour
      • H-Slider
      • Image
      • Info Button
      • Label
      • Legend
      • Progress Pie
      • Semi Gauge
      • Stepper
      • SVG Image
      • Text Box
      • Trend
      • URL Button
      • V-Slider
      • Tab Component
      • Inputbox component
      • Button component
    • Custom Charts
    • Common Chart Properties
      • Background
      • Title & Sub-title
      • X & Y Axis Properties
      • Legend Properties
      • Formatter
      • Axis Setup
      • Export Options
  • Dashboard Objects
    • Manage Dashboard Components
    • Dashboard Objects Properties
  • Configurations
    • Filtering the Data
    • Drill Through
    • Dataset Properties
    • Indicators in Charts
    • Tooltip(Default & Custom)
    • Data Label
    • Geo Mapping
    • Language Mapping
    • Legend Mapping
    • Alerts in Grids
  • Script Help Section
    • Navigate to Script Help page
    • How to use Scripts?
Powered by GitBook
On this page
  • Creating a New CSV Connection
  • Condition
  • Calculated Fields
  • Script on Load for a Data Connection
  • Opening the Scripting Help/ Advanced Scripting
  1. Connecting to a Data Source
  2. Establishing a Data Connection

CSV Connection

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

PreviousEstablishing a Data ConnectionNextExcel Connection

Last updated 2 years ago

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

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.

  • 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.

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.

  • The Script tab appears to trigger a script to produce some action on the data connection.

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

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

Opening the Scripting Help/ Advanced Scripting

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

  • The Scripting Help tab opens with some predefined scripts.

  • Click the Advanced Scripting option to display the chart-wise advanced scripts.

Creating a New Connection
Configuring a Data connection

​

Accessing the Script on Load icon under the Data Connectors page
The Script tab for connection
The Script window for the Dashboard components
The Script window for the Dashboard
Accessing the Help icon
Scripting Help tab with pre-defined scripts
The Advanced Scripting tab displaying the chart-wise advanced scripts