userguides
  • Welcome
  • Contact Us
  • Getting Started
    • Quickstart
    • Inside ViewZen
  • ViewZen Accounts
    • Overview
    • Account Owner
    • Home Page
    • Member Profile
      • My Account
      • My Organization
      • Security
      • Permissions
    • Roles and Permissions
      • Standard Roles
      • Custom Roles
    • User Management
    • User Groups
    • Multi factor Authentication
    • Context based Permissions
    • API Keys
  • Appverse
    • Overview
    • Home Page
    • Apps
      • Create an App
        • Folders
          • Create
          • Edit
          • Delete
          • View Contents
        • Roles
        • Forms
          • Create
            • Get Familiar
              • General Properties
              • Hint
              • Appearance
              • Validations
                • Examples
              • List of Values
              • Scope
                • Examples
              • Search Settings
              • Security
              • Expressions
              • Appverse Expressions
                • Examples
              • Choices
              • Instance Name
              • Download Form
              • Import Form
            • Best Practices
            • Create with Form Builder
            • Create with GenAI
            • Create with ODK compatible xls
          • Edit
          • Delete
          • Deploy / Undeploy
          • Settings
            • General Settings
            • Data Display
            • Appearance
            • Languages
            • Auto Numbering
            • Lookup
            • Child Forms
            • Report Template
            • Validations
            • Data Formatting Rules
            • Record Access
            • Quick Filters
          • Allocation
            • Get Familiar
              • General Properties
              • View Permissions
          • Quick Configuration
          • Events and Actions
            • Save to DB
            • Lock Record
            • Update Status
            • Create / Update Record
            • Send Notifications
            • Custom Scripts
          • Conditions in Appverse
          • Advanced Search
          • Data
            • Card Layout
            • Grid Layout
            • Master Detail Layout
          • Dashboards
            • Publish Dataset
            • Dashboard
        • Dashboards
          • Link
      • Edit an App
      • Delete an App
      • List of all Apps
      • Publish an App
      • Export & Import an App
    • User Allocation
    • Library
      • Custom Scripts
      • Custom Queries
      • Report Templates
    • Departments
    • Settings
  • ViewZen Analytics
    • Overview
    • Landing Page
    • Dashboard
      • List of Dashboards
      • Create a Dashboard
        • Get Started
        • Datasets
        • Sheets
        • Version Control
        • Toolbar
          • Place Components
            • Properties
              • Data Properties
                • Data Fields
                • Inbuilt Aggregation Functions
                • Dimensions
                • Measures
                • X-axis and Y-axis
                • Column
                • Data Series
              • Format Properties
                • Title / Sub Title / Label
                • Appearance
                • Legend
                • Viewer Settings
                • General Settings
                • Axis Settings
                • Axis Label Settings
                • Axis Title Settings
                • Label Formatting
                • Sorting
                • Color Formatting
                • Column Formatting
                • Stacked Header
                • Footer
                • Actions and Events
                • Chart Settings
                • Grid Settings
                • Data Series Formatting
                  • Value Series
                  • Column Series
                  • Stacked Column Series
                  • Radar Column Series
                  • Waterfall Series
                  • Line Series
                  • Bubble Series
                  • Pie Series
                  • Donut Series
                  • Funnel Series
                  • Clustered Area Series
              • Tooltip Properties
                • Properties
            • Visuals
              • Cards
              • Charts
              • Grid
              • Textbox
              • Filter
              • Image
              • Zone
            • Visuals Marketplace
          • Edit Components
          • Delete Components
        • Filters
          • Fixed Filters
            • Create Filter
              • Filter Conditional Statements
            • Edit Filter
            • Delete Filter
          • Interactive Filters
            • Create Filter
            • Edit Filter
            • Delete Filter
      • Edit a Dashboard
      • Share a Dashboard
      • Delete a Dashboard
      • View a Dashboard
      • Use Dashboard for Presentations
Powered by GitBook
On this page
  • Adding a Dataset
  • Fields of a added dataset
  1. ViewZen Analytics
  2. Dashboard
  3. Create a Dashboard

Datasets

PreviousGet StartedNextSheets

Last updated 4 months ago

A dataset is a structured collection of data used for analysis and visualization. In ViewZen Analytics, a dataset can correspond to a database table, a database view, or a database query.

  • Each column in a dataset represents a specific variable within the data.

  • Each row contains a collection of variables that form a single data record.

A dataset in ViewZen Analytics can source its data from

  • ViewZen Analytics Store - A dataset may get created in either a PostgreSQL or an ElasticSearch Store when data is imported via ViewZen Pipelines. ViewZen Pipelines may connect to any relational database such as MySQL etc. or a business application or a spreadsheet like Google sheet or excel.

  • Live Databases - It can connect directly to Databases (SQL, NoSQL, Cloud-based databases) post registration. The registration process allows you to associate the dataset to a table or view or a query.

In ViewZen Analytics, a dashboard can be created using multiple different datasets each residing in a different database. This makes ViewZen Analytics a very powerful platform capable of providing integrated analytics from multiple sources.

Adding a Dataset

A dataset can be added to a dashboard in the one of the following ways

  1. While - You can select one or more datasets at the time of creating a new dashboard.

  2. From within the dashboard - New datasets can be added from within a dashboard by opening the dashboard in the edit more i.e. Designer option. This following steps can be followed to add additional datasets to a dashboard

    1. Navigate to the Dashboard: Locate the dashboard to which you want to add additional datasets. Open the dashboard in Edit mode.

    2. Click on "Add dataset" Icon - The "Add Dataset" icon is the first icon located at the right end of the designer toolbar.

    3. Select Additional datasets - Select additional datasets from the "Add Dataset" list and confirm.

Fields of a added dataset

The fields section lists the following

  1. Dataset columns - Dataset wise-columns present in each dataset that is added to the dashboard and their types.

  2. Expressions - Expressions created on added datasets.

  3. Context fields - If a context field is mapped to an added dataset field, the context field will be listed.

  4. Formuale - Any formula created on the added dataset will be listed.

creating a new dashboard
Add dataset