DataLynx Logo

DataLynx BI Tutorials

Create Chart Tables

Introduction

Chart tables is the advanced copy of your database table. After you import your database table you can customize it to your needs, what you want to focus on. In "Sales" table you may want to focus on sales volume per employee, in this case join "Employees" table to have a more integrated table. And maybe remove column "item number", we don't need it here, so remove it. You get the idea.

DataLynx is all about giving you control over your data. Chart Tables is where you begin to realize this goal, the steps before were just preperation for this and for creating charts, which we will discuss in the next chapter.

create edit chart tables

Available Edit Options

- Edit header names
- Add columns
- Hide columns
- Join DB tables
- Filter rows

Depending on the filter conditions -details below-, you'll have four options of filters:

- Remove row: Removes the row from the table
- Add prefix: Adds prefix before each of the cell's original content
- Add suffix: Adds prefix before each of the cell's original content
- Replace row value: Replaces value with a new value specified by you in the form

You will have to specify the filter condition. For number and date fields, there are four types of conditions, equal, not equal, greater than, and less than. For other types of fields there are equal and not equal.

filter and add columns to chart tables

Adding columns

Adding columns to the table requires two parameters: name and equation. The equation accepts the four math operators only, ie: +-*/

About DataLynx BI

DataLynx BI is a Business Intelligence and Data Analytics SaaS. It connects to multiple databases to create a central data management solution. Claim your 14 days trial period