Skip to content
AIV
Search
Cancel
YouTube
Facebook
Twitter
Select theme
Dark
Light
Auto
Introduction
AIV Introduction
Installation and Upgrade
Windows
Windows upgrade
Mac
Linux installation
Linux upgrade
Docker AIV installation
AIV gzip setup
Dashboard
Dashboard Overview
Create Dashboard
Preview - Edit Dashboard
Preview grid
Dashboard widget
Dashboard widget
Table widget
Create Table Widget
Advance Tab
Formatting Tab
Themes Tab
Event Tab
Annotation Tab
Skip Widget from Event Filtering
Custom Column
Custom Column Micro Chart
Custom Column Icon
Custom Column Hyperlink
Selected Column Functions
Chart widget
Charts Overview
Category navigate icon
Column - Bar chart
Create column Bar-Chart
Optional category Grouping
Optional Y Series Grouping
Optional Grouping Color
Chart Grouping & Sorting
X-axis Alignment
Settings
Formatting
General formatting
Category formatting
Value formatting
Series formatting
Legend formatting
Trend Lines formatting
Line - Area Chart
Create Line-area chart
Stacked Line-area chart
Hierarchy
Annotations
Formatting
Formatting Properties
Category Axis
Category Type
Category Cursor Tooltip
Category Labels
Category Font Property
Category Ticks
Category Alternate Fills
Category Line
Category Grid
Category Title
General
Dynamic Dataset
General Properties
Color and Theme
Negative Property
Thousand and Decimal Separator
Sorting
Series Total (Optional Y)
Chart Title
Chart Cursor
Chart Scrollbar
Background Area
Chart Tooltip
Back to Back Chart
Include Null Value
Legend
Legend properties
Legend alignment
Inherit property from series
Legend sort property
Legend font properties
Legend background
Legend markers
Series
Series general
Series property
Series legend shape
Series tooltip
Series bullets
Series labels position
Trend Line
Trend general
Trend bullets
Trend tooltip
Trend series labels position
Value Axis
Value axis properties
Min & max value property
Value cursor tooltip
Number format
Value axis labels
Value axis font property
Value axis ticks
Value axis alternate fills
Value axis line
Value axis value axis grid
Base grid
Value axis title
Positive title
Negative title
Pie - Donut chart
Create pie chart
Formatting
Formatting properties
General properties
Series properties
Legend properties
Other - Advance chart
Funnel chart
Create Funnel Chart
Formatting properties
Pyramid chart
Create Pyramid chart
Formatting properties
Candle stick chart
Create candle stick
Formatting
Candle stick formatting
OHLC chart
Create OHLC chart
Formatting
OHLC formatting
Radar chart
Create Radar chart
Formatting
Radar formatting
General
Chart title
General properties
Color & theme
Chart sorting
Chart tooltip
Thousand decimal separator
Include null value
Value axis
Value axis properties
Min-Max value property
Value axis labels
Value axis line
Value axis property
Value grid
Variable radius chart
Create variable radius radar
Formatting
Variable radius formatting
Treemap chart
Create Treemap
Settings
Formatting
Treemap Formatting
Chart sorting
Chart tooltip
Color & theme property
Thousand decimal separator
Include null value
Series name
Circular Gauge
Create Circular Gauge
Settings
Formatting
Circular Gauge formatting
Chart & pointer
Angle & direction
Label style
Chart line style
Chart Major-ticks
Chart Minor-ticks
Heat map
Create Heat map
Settings
Formatting
Heatmap formatting
Map widget
Map Overview
Create Geo Maps
Create Leaflet Maps
Create Geo-Country Map
Formatting
Map Setting
Map Series
Reports Widget
Card Widget
Card Widget
Create Card Widget
Custom visualization
Image and Text Widget
Overview
Pivot Widget
Pivot Overview
Create Pivot
Formatting Pivot
Conditional Formatting
Pivot Event
Pivot Drill Disable
Pivot Analysis Download
Pivot Value Column Feature
Embedlink with Pivot using filter
Spreadsheet
Introduction
Edit spreadsheet
Home
Insert
Formulas
Data
View
Document Widget
Overview
Add new document
Add bookmark
Add header-footer and page number
Add image
Add link
Add table
Add comment
Search feature
Insert footnote and endnote
Restrict editing
Track changes
File manager
Analysis widget
Diagram
Introduction
BPMS shapes
Connectors
Flow shapes
Interactive features
Logic circuit
Network shapes
UML shapes
Scheduler widget
Gantt chart
OLAP Widget
OLAP Overview
Create OLAP
Hierarchy Configuration
Drill Down OLAP
Notebook
Form builder
Dynamic view - Widget layer
Layer widget
Layers, Views & Tabs
Layer Widget
Layer filter
Layer sorting
Dynamic linking
Dashboard view
Layer change event
External apps
Alerts
Marketplace AIV
Widget Basket
Section & Blank Widget
Dashboard Tab
Dashboard tabs
Embed Dashboard
Embed Overview
What is Embed Link
How to use Embed Link
Embed Filter
Embed Filter With Global Parameter
Embed Filter with Pivot
Embed with-Without Bypass
Embed within extra label Property with filter
Embed within extra label property
Filters
Filters Overview
Create Filters
Filters List
Filter Widget
Filter Validation
Link Filters-Widgets
Filter View
Dummy Filter using Custom Visualization
Filter Condition
Hide Grid option in filter setting
Select all on Parent change
Tab to Tab Filters
Filter With Report Parameter
Cascade Filters
Layer to layer filter
Event Filter with Report
Ellipsis menu
Multilayer
Download Widget
Dynamic link
Click Event Expression Using console.log
Custom Date Range Filter
Widget Settings
Introduction
Socket
Dashboard Internationalization
Dashboard Settings
Miscellaneous Operations
Prediction in Dashboard
Annotation widget hover
Calling Detail Dashboard with Event Tab
Calling Detail dashboard from Table custom column with filter
Share-Edit Dashboard
Documents
Introduction
Report
Introduction
Schedule Reports
Time Schedule
Right Now
Once
Recurring
Event Schedule
Hide Report Options
Hide Grid in Report Export
Parameter
Single Sheet Option
Report Management
Merge Report
Introduction
Create Merge Reports
Edit Merge Reports
Clone Reports
Schedule Reports by Time
Schedule Reports by Time Right Now
Schedule Reports by Time Once
Schedule Reports by Time Recurring
Schedule Reports by Event
Adhoc Reports
Introduction
Table
Chart
Image
Annotation
Text
Pivot
Predefined Component
Bind Parameters
Adhoc Embed Link
Adhoc Analysis
Adhoc Analysis
Filter Conditions
Quick Run
Introduction
Create Quickrun
Execute Quickrun
Edit Quickrun
Mappings
Introduction
Mappings
Edit Mapping
Shared Resources
Group Report
Report Bursting
Introduction
Bulk Report Sharing
Dynamic Output Format Reports
Report Bursting Dataset Guide
Report Bursting Mapping Guide
User Specific Reports
Master Data
Introduction
Datasource
Introduction
Create Datasource
Edit Datasource
Delete Datasource
Custom Datasource
Data EndPoints Datasource
Datasource Connections
Datasource Introduction
Datasource Google Analytics
Cdata Cloud Connection
Datasource with Hsqldb
Datasource Using MongoDB
Datasource Using BigQuery
Airbyte Local Deployment
Connecting with Asana
Connecting with Close.com
Connecting with Freshdesk
Connecting with Github
Connecting with Monday.com
BambooHR Connection
Airbyte Description
Connecting with Airtable
Connecting with Apify
Connecting with Hubspot
Connecting with Openweather
UScensus Connection
Datasource Odoo
Datasource Connection
Datasource Access
Datasource ActCRM
Datasource Active Directory
Datasource ActOn
Datasource Acumatica
Datasource Adobe Analytics
Datasource ADP
Datasource Airtable
Datasource Alfresco
Datasource with DynamoDB
Datasource Amazon Market Place
Datasource Amazon S3
Datasource Asana
Datasource Authorize_net
Datasource Autify
Datasource Avalare AvaTax
Datasource Avro
Datasource AWS Managment
Datasource Azure Analysis Services
Datasource with Azure Data Catalog
Datasource Azure DevOps
Datasource Azure Management
Datasource Azure Synapse
Datasource Basecamp
Datasource BigCommerce
Datasource Blackbaud FE NXT
Datasource Btrieve
Datasource Cassandra
Datasource Cloudant
Datasource CockroachDB
Datasource Cosmos DB
Datasource Couchbase
Datasource CouchDB
Datasource Databricks
Datasource DB2
Datasource Dynamics Gp
Datasource eBay
Datasource eBay Analytics
Datasource EDGAR Online
Datasource with Elasticsearch
Datasource EnterpriseDB
Datasource Exact Online
Datasource FreshBooks
Datasource Freshdesk
Datasource with Google Data Catalog
Datasource Greenplum
Datasource with Hbase
Datasource with Hive
Datasource with HPCC System
Datasource IBM Informix
Datasource Impala
Datasource JDBC - ODBC Bridge
Datasource Magento
Datasource with MariaDB
Datasource with Marklogic
Datasource MYOB AccountRight
Datasource with MySQL
Datasource Open Exchange Rates
Datasource Oracle
Datasource PayPal
Datasource PostgreSQL
Datasource Quandl
Datasource QuickBooks
Datasource QuickBooks Online
Datasource QuickBooks POS
Datasource Reckon
Datasource with Redshift
Datasource SAP Business One
Datasource SAP Concur
Datasource SAP Fieldglass
Datasource SAP Hana
Datasource SAP Hana XS Advanced
Datasource SAP Hybris C4C
Datasource with SAS Dataset
Datasource ShipStation
Datasource Shopify
Datasource Single Store
Datasource with Snowflake
Datasource with Spark
Datasource SQL Analysis Services
Datasource with SQLite
Datasource SQL Server
Datasource Square
Datasource Stripe
Datasource Sybase
Datasource Sybase IQ
Datasource TaxJar
Datasource Teradata
Datasource TSheets
Datasource with Vertica
Datasource Wave Financial
Datasource WooCommerce
Datasource Workday
Datasource X-Cart
Datasource xBase
Datasource Xero
Datasource Zoho Books
Datasource Zuora
Datasource Bing Ads
Datasource Box
Datasource Bugzilla
Datasource Bullhorn CRM
Datasource Confluence
Datasource CSV
Datasource DigitalOcean
Datasource DocuSign
Datasource Dropbox
Datasource Dynamics 365 Business Central
Datasource Dynamics 365 FinOp
Datasource Dynamics 365 Sales
Datasource Dynamics CRM
Datasource Email
Datasource Epicor ERP
Datasource Evernote
Datasource Excel
Datasource Exact Online
Datasource Excel Services
Datasource Facebook
Datasource Facebook Ads
Datasource FinancialForce
Datasource FTP
Datasource Gmail
Datasource Google Ad Manager
Datasource Google Ads
Datasource Google Calender
Datasource Google Campaign Manager
Datasource Google Cloud Storage
Datasource Google Contacts
Datasource Google Drive
Datasource Google Sheets
Datasource HDFS
Datasource Highrise
Datasource HubSpot
Datasource IBM Cloud Object Storage
Datasource Instagram
Datasource Jira
Datasource Jira Service Desk
Datasource JSON
Datasource Kintone
Datasource LDAP
Datasource LinkedIn
Datasource LinkedIn Ads
Datasource Mailchimp
Datasource Marketo
Datasource Microsoft Dataverse
Datasource Microsoft Exchange
Datasource Microsoft OneDrive
Datasource Microsoft Planner
Datasource Microsoft Project
Datasource Microsoft Teams
Datasource NetSuite
Datasource Office 365
Datasource OneNote
Datasource Oracle Eloqua
Datasource Oracle Sales
Datasource Parquet
Datasource Pinterest
Datasource QuickBase
Datasource RaiseEdge NXT
Datasource REST
Datasource RSS
Datasource Sage 300
Datasource Salesforce
Datasource Salesforce Chatter
Datasource Salesforce Einstein
Datasource Salesforce Marketing
Datasource Salesforce Pardot
Datasource SAP
Datasource SAP Business Objects BI
Datasource SAP Business Online DI
Datasource SAP ByDesign
Datasource SAP NetWeaver Gateway
Datasource SAP SuccessFactors
Datasource SAS XPT
Datasource SendGrid
Datasource ServiceNow
Datasource SFTP
Datasource SharePoint
Datasource Slack
Datasource Smartsheet
Datasource Snapchat Ads
Datasource Splunk
Datasource Streak
Datasource Sugar CRM
Datasource Suite CRM
Datasource SurveyMonkey
Datasource Trello
Datasource Twilio
Datasource Twitter
Datasource Twitter Ads
Datasource Veeva
Datasource Veeva CRM
Datasource Wasabi
Datasource WordPress
Datasource XML
Datasource YouTube Analytics
Datasource Zendesk
Datasource Zoho CRM
Datasource Mapping
Datasource Mapping
Dataset
Dataset Introduction
Create Datasets
Dataset Terminology
General Tab
Output Columns Tab
Preview Tab
Create Dataset
Create Parameter Dataset
Parameter Button Details
Dataset Using CSV
Dataset Using Excel
Dataset Using External DS
Dataset Using Flatfiles
Dataset Using JSON
Create Dataset using Client Script
Create Dataset using Server Script
Group Dataset [Stash Dataset]
Create Dataset Using Hierarchy
Create Dataset using Stored Procedure
Create Dataset using View
Create Dataset Using noSQL
Create Dataset Using Google BigQuery
Create Dataset using Union
Create Dataset using Join
Dataset using Simple Query
Join Window Terminology
CDS dataset
Edit Dataset
Create Dataset Mapping
Run Dataset Mapping
Schedule Dataset
Schedule Dataset
Schedule by Time
Time Schedule
Once
Recurring
Right Now
Schedule by Event
Event Schedule
External Dataset
Embed Dataset
Group Dataset
Group Dataset [Stash Dataset]
Parameters
Parameters
Edit
Cascade Parameter
Pipeline
Introduction
How to create pipeline
Inner Join
Left Join
Right Join
How to Filter Node Columns
Embed Pipeline
Language Parameter
How to change Alias of column
How to change pipeline configuration
Create Reverse Join Pipeline
Hide Column in Pipeline
Export Data in Excel
Condition Pipeline
Schedule Pipeline
Change Alias of column
Group Condition in Pipeline
Request
Introduction
Notifications
Introduction
Approvals
Messages
Alerts
Requests
Introduction
Cancel
Retry
Clone
Delete
Archive Job
Purge Job
Cleaner Job
Select User
Request Fail
Alerts
Introduction
Alert section
Alert Report
Notification–Request Approval
Notification - Message
Administration
Introduction
Repository
Department
Introduction
Create Department
Users
Introduction
Create User
Edit User
Assign Role
Roles
Introduction
Create Roles
Edit User Role
Email Users
Introduction
Create Email User
Edit Email User
Supported File Types
Introduction
Create File Type
Edit File Type
Delete File Type
SSO & External security
SSO Code Explanation
External Security Code Explanation
Dynamic SSO Code Explanation
LDAP Code Explanation
License
AIV Configuration
AIV License Request and Update
AI Buddy
AI Dashboard Buddy
AI Visual Buddy
AI Global Buddy
AI SQL Buddy
Dynamic Message
Introduction
Create Message
Edit Messages
Preview
Comment
Generate Report
Annotation
Annotation
Create Group
Create Item
Control Panel
Introduction
User Profile
Switch User
Save Alert
Common Functions
Audit
Clone
Create Folder
Copy
Delete
Download
Move
Property
Save as quicklink
Share
Upload
Version
Mark As Unarchive
Mark As Unpurge
Connected Apps
Asana
Salesforce with Data Endpoints
Freshdesk
Jira
Monday
Salesforce
Market Place
Developer Corner
API Integration
Event Based Scheduling
AIV Usecases
Index
AIV Patch update
AIV Server Migration Windows
Backup Restore MySQL database in Windows
Backup & Restore MySQL DB linux
Backup Restore PostgreSQL database in Windows
Backup Restore PostgreSQL database in linux
Decimal values in chart tooltip
Decimal point in dynamic labels
PostgreSQL database Backup Restore
Server migration changes if not placed at the same location
Change Log Levels
Advance
Sectigo PositiveSSL Certificate Installation
Secure JDBC Password
SSL in Tomcat
Zip Upload
Apply Global Theme
Customize Header content of AIV
How to customize the login page
Extract JSON Value Using SQL
How to use python script in AIV
Login bypass link
Create Datasource Externally
SSO with KeyCloak AIV
Dynamic SSO with KeyCloak
Tomcat as Window Service
Configure SSL Certificate
AIV Cluster Manager Setup
Folder Sharing Security
Security
AIV SSO
Solution
Project Management Dashboard
Reference
Example Reference
Release Note
Intro
Sections
All section
Dashboard
Dashboard widget
Document
Masterdata
Request
Administration
Select theme
Dark
Light
Auto
Datasource Avalare AvaTax
Updating Soon…