# Welcome to Dataflake

Welcome to Dataflake! Here, you'll find relevant articles help you on a specific feature or quick tutorials, making the most of our powerful data visualization tool.

### What is Dataflake?

Dataflake is a data visualization tool to help data analysts from Startups and Small & Medium Businesses who are obsessed to tell better data story easily and quickly with our intuitive data visualization experience without design, sharing, embedding and cost constraints.

### Dataflake features

**Highly Customizable Data visualization**

Creating interactive dashboards has never been easier by easy-to-use features and advanced styling options. Visualize charts and share actionable insights to stakeholders easily.

#### Dashboard Delivery Schdedule 

Configure sending dashboard via email easily with many advanced options. Set up time, subject and description to deliver your Dashboard to certain recipients. Configure your dashboard delivery to repeat daily, weekly, monthly, or even create a custom schedule. 

**Shared/ Embedded Analytics**

Share or embed yoru dashboard/ analytics quickly and securely with advanced embedding configuration. 

**Manage queries in a single page (Coming soon)**

Edit your queries, communicate and add reviews with your teammates to track the health of queries. Also, quickly see all query changes to get work done faster. All is in just one place.

### Need Help?

If you have any questions or encounter issues, our support team is here for you. Reach out to us at <hello@dataflake.co>

### More resources <a href="#od_16906b91" id="od_16906b91"></a>

[Upcoming features](https://www.dataflake.co/upcoming-features)\
[Dataflake Blog](https://www.dataflake.co/blog)\
[Beta Program](https://www.dataflake.co/beta-program)<br>

<br>


# FAQs

Frequently asked questions

### 1. Which data sources do Dataflake support?&#x20;

We are currenly supporting puopular Data Sources including: PostgreSQL, ClickHouse, BigQuery, MySQL, Microsoft SQL Server, Flat files

<figure><img src="/files/vU0KWORSx90LzGdGRGMA" alt=""><figcaption></figcaption></figure>

### 2. Does Dataflake store your data?&#x20;

Dataflake doesn’t store any of our your data. Dataflake will send the query to your database server, take the result and send directly to viewer.

However, in case you use cache, Dataflake will store the query result in Dataflake based on the cache time. This will help us display the dashboard faster for viewer, and reduce the load for your database server.

### **3. Which permissions database role/user need (Readonly database)?**

Dataflake sends the query directly to your database and no more than that, so the database user just needs the SELECT (Read) permission on tables used in the SQL. We always recommend giving enough permissions to your user to keep your database safer from cyber attacks

### 4. What makes Dataflake diffferent from other data visualization tools?&#x20;

Dataflake is designed for Data Analysts from Small and Medium-Sized Businesses (SMBs) and Startups who are obsessed to tell better data story easily with highly customizable data visualization, and sharing, embedding analytics on websites or applications quickly and securely.

Dataflake aim to bring our users with seamless experience with high security and low cost   so that you can empower your data visualizations without constraints.


# Create my first dashboard&#x20;

No matter which journey you are on, you are playing around with Dataflake in order to make the final decision of purchase or you are on a free plan. We're sure that you need information so that you can easily analyze data  with Dataflake, and without obstacles. This article will deliver you a specific and visionable guild, therefore, you can build your first Dashboard in a matter of minutes

### Create a workspace

After finishing creating your account with Dataflake, you have to create a workspace. A workspace is a place that gathers members involved in a project or campaign that shares all of your related dashboards present.&#x20;

<figure><img src="/files/fnytyxu9kutXF8MYU3YW" alt="" width="348"><figcaption></figcaption></figure>

### Create a dashboard

Within your workspace, you will quickly see the **New Dashboard** button. Just click this button and name your dashboard, then you will navigated to **Dashboard Editor**, where you are about to dive into your Dashboard creation

<figure><img src="/files/UaZqR6Xq3kZwmHFYxbXu" alt=""><figcaption></figcaption></figure>

### Connect to a Data Source&#x20;

Dataflake allows you to connect to databases including: PostgreSQL, BigQuery, ClickhHouse, MySQL, Microsoft SQL Server, and Imported flat Files. Stay tuned, other databases will come soon to streamline your work.&#x20;

All you need to do is choose your type of database and fill in required security credentials. Don’t forget to set the name for your database so that you can quickly search it while creating charts

<figure><img src="/files/w6cw7yyzPs8d9PoB5X5L" alt=""><figcaption></figcaption></figure>

You can read this [section](/data-sources/postgresql) to learn more about how to connect to a data source&#x20;

### Query

Once you have successfully connected a data source, it’s time that you wrote a query to gather and structure data you want from your database using SQL. With Dataflake, you can directly query in the right panel within your dashboard. It is to help you save your time instead of navigating different page

<figure><img src="/files/AWP7tTJiw3dbdRAAYqkT" alt=""><figcaption></figcaption></figure>

### Add Charts/ Visualizations&#x20;

When you get your query results after retrieving from the database, you start with visualizing charts. Dataflake provides multiple types of charts to highlighted tell your story, so, you can select type of chart that fits your needs

Additionally, you can beautify your dashboard by adding other styling elements such as: image or shape.&#x20;

Another thing to consider is customizing your visualizations to make your Dashboard attractive yet digestible so that you can captivate your audience. You can directly style your Chart title, Label, Legend, axis, etc in the toolbar. It is easy-to-use and time-saving<br>

<figure><img src="/files/zdUwYo1iXMRzfXKf1CpI" alt=""><figcaption></figcaption></figure>

### Build Dashboard

Make a great combination amongst visualizations, text, images, color, annotations, structure, so forth to turn into aesthetic and actionable dashboards. Make sure your audience can grasp your message that you want to deliver throughout your dashboard.

###

<br>

<br>

\ <br>

<br>

&#x20;

<br>


# Share my dashboard

### Send dashboard via email

Dataflake supports automatically sharing your Dashboard with your colleagues via email based on your condition setting, what we call as Email Delivery. Configure recipients, title, body of email like you send normal email. Set starting time, ending time and repetition so that your report will be automatically sent to the right member. &#x20;

<figure><img src="/files/En5cNoxpkbRB3yVdEcpK" alt=""><figcaption></figcaption></figure>

### Share/ embed your Dashboard

Another way of sharing your Dashboard is embedding dashboards to websites, applications or portals. Setting password, sealing and other authentication to ensure the right people are able to access the right Dashboards

<figure><img src="/files/J0D29LiHC9Eww1hhG8QG" alt=""><figcaption></figcaption></figure>


# PostgreSQL

In this page, we'll show you how to add a PostgreSQL source to Dataflake.

From the top navigation bar click on the ![](/files/zw6JvJWMtfhKoFHuDj6a) icon.

Choose the **Connection strings** tab.

Click the **Add** button.

Enter the Name of your connection.

Select **PostgreSQL** from the Connection type.

Enter your connection string.&#x20;

1. **Hostname:** where your database is hosted&#x20;

{% hint style="info" %}
You can paste the host url in the Host box to connect to your database quickly
{% endhint %}

2. **Port:**&#x20;

* The port the database server uses
* For example, the default port number for PostgreSQL is 5432&#x20;

3. **Database:** name of your database&#x20;
4. **User:** username of the Database you want to connect&#x20;
5. **Password:** password of the Database you wish to connect

Click **Next** then Click the **Complete** button to establish your Connection.

<figure><img src="/files/w6cw7yyzPs8d9PoB5X5L" alt=""><figcaption></figcaption></figure>


# MySQL

In this page, we'll show you how to add a MySQL source to Dataflake.

Steps to connect MySQL source to Dataflake is like connecting PostgreSQL to Dataflake. Read this [section](/data-sources/postgresql) to learn more&#x20;

**To connect to MySQL,** from the top navigation bar click on the ![](/files/P80MayqVkDi5KjbUatdt) icon.

Choose the **Connection strings** tab.

Click the **Add** button.

Enter the Name of your connection.

Select **MySQL** from the Connection type.

Enter your connection string.&#x20;

1. **Hostname:** where your database is hosted
2. **Port:** add port name
3. **Database:** name of your database&#x20;
4. **User:** username of the Database you want to connect&#x20;
5. **Password:** password of the Database you wish to connect

Click **Next** then Click the **Complete** button to establish your Connection.

<figure><img src="/files/3p2i0r2pDBFq4LQWnvPc" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
You can paste the host url in the Host box to connect to your database quickly
{% endhint %}


# ClickHouse

In this page, we'll show you how to add a Clickhouse source to Dataflake

Steps to connect ClickHouse source to Dataflake is like connecting PostgreSQL to Dataflake. Read this [section](/data-sources/postgresql) to learn more&#x20;

From the top navigation bar click on the ![](/files/joOvHWcqF24qGOvFCAxR) icon.

Choose the **Connection strings** tab.

Click the **Add** button.

Enter the Name of your connection.

Select **ClickHouse** from the Connection type.

Enter your connection string.

1. **Hostname:** where your database is hosted
2. **Port:** default port number for ClickHouse is 8123
3. **Database:** name of your database
4. **User:** username of the Database you want to connect
5. **Password:** password of the Database you want to connect

Click **Next** then Click the **Complete** button to establish your Connection.

<figure><img src="/files/ZYcVcpv0Hre4cxYJ80VG" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
You can paste the host url in the Host box to connect to your database quickly
{% endhint %}


# BigQuery

In this page, we'll show you how to add a BigQuery source to Dataflake

Steps to connect BigQuery source to Dataflake is like connecting PostgreSQL to Dataflake. Read this [section](/data-sources/postgresql) to learn more&#x20;

From the top navigation bar click on the ![](/files/ENoZ0NsFqV0GdJloJjv4) icon.

Choose the **Connection strings** tab.

Click the **Add** button.

Enter the Name of your connection.

Select **BigQuery** from the Connection type.

Enter your connection string .

Click **Next** then Click the **Complete** button to establish your Connection.

<figure><img src="/files/jgiEgv40Xw6sJQFfSb4B" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
You can paste the host url in the Host box to connect to your database quickly
{% endhint %}


# Microsoft SQL Server

In this page, we'll show you how to add a Microsoft SQL Server to Dataflake

Steps to connect Microsoft SQL Server source to Dataflake is like connecting PostgreSQL to Dataflake. Read this [section](/data-sources/postgresql) to learn more&#x20;

From the top navigation bar click on the ![](/files/1l9J7Hc61GOOhStXl8ru) icon.

Choose the **Connection strings** tab.

Click the **Add** button.

Enter the Name of your connection.

Select **Microsoft SQL Server** from the Connection type.

Enter your connection string.

1. &#x20;**Server**: domain, port, for example: 127.0.0.1,1433
2. **Database:** name of your database
3. **User:** username of the Database you want to connect
4. **Password:** password of the Database you want to connect

Click **Next** then Click the **Complete** button to establish your Connection.

<figure><img src="/files/K7lCRKoqCh5y7y46ZqFr" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
You can paste the host url in the Host box to connect to your database quickly
{% endhint %}


# Flat files

In this page, we'll show you how to import a flat file into Dataflake

Currently, we do not support import flat files (csv, tsv format) directly into Dataflake.&#x20;

However, if you have your databases which Dataflake support to connect, you can import flat files (csv, tsv or custom format) to them, then you can continue executing to connect your database to Dataflake.

**To import your flat files into your database:**

From the top navigation bar, click on the ![](/files/1l9J7Hc61GOOhStXl8ru) icon.

Choose the **Connection strings** tab.

Select the data source that you want to import your flat file in. Make sure that you already connect the data source to Dataflake

Click ![](/files/vFNGw6IGCnJ4ntxa802C)to import your flat file to the data source

<figure><img src="/files/6gauXyXfSmjwXH84RYF6" alt="" width="375"><figcaption></figcaption></figure>

Browse the file you want to add.

Select the type of file.

Name your Table.

Check this option if you want to consider the first row as the Header.

Click **Next**

<figure><img src="/files/alpNBC8zfhUsXXTJPbei" alt=""><figcaption></figcaption></figure>

Configure Data types for each column.

You can rename columns

Click **Import**

<figure><img src="/files/Xo6SAjjfz2gx8Hc9XKHi" alt=""><figcaption></figcaption></figure>


# Public Dataset

If you don't have your SQL database but want to explore Dataflake. No worries! We have curated, public Dataset for you

From the top navigation bar click on the ![](/files/P80MayqVkDi5KjbUatdt) icon.

Choose the **Connection strings** tab.

Click the **Add** button.

Click Use public dataset to connect to our public dataset&#x20;

<figure><img src="/files/UnAwiG5BhvQE10CASBZa" alt=""><figcaption></figcaption></figure>


# Edit, Rename, Delete a Data Source

### Edit a data source <a href="#od_6ce0d3b1" id="od_6ce0d3b1"></a>

You can easily edit Data Sources in just a few steps.

1. Select **data sources** icon
2. Select **Connection Strings**. Then you will see your connection
3. Click the **edit** icon on the right

You can edit the name, connection type and database.

<figure><img src="/files/oyVkSBFbnIrcfNLQ3gPV" alt="" width="375"><figcaption></figcaption></figure>

{% hint style="info" %}
Viewer can not see data source. Only owner admin can read and edit data source
{% endhint %}

### Rename a data source <a href="#od_098c8495" id="od_098c8495"></a>

Like edit a data source, you just need to change the name of your data source, then click Next to save the renamed data source.

### Delete a data source <a href="#od_80ea6484" id="od_80ea6484"></a>

1. Select **data sources** icon
2. Select **Connection Strings**
3. On the right, click on **Delete** button
4. Confirm the delete by clicking yes

<figure><img src="/files/3PvQzqusL1YMUmpGnpZj" alt="" width="375"><figcaption></figcaption></figure>

###


# Add a query

When you successfully connect to a database, you begin create query by writing SQL. Follow these instructions to add the query successfully!

To add a query:&#x20;

1. Choose **Queries** tab&#x20;
2. Click **Add** button to add a query
3. Choose the connection&#x20;
4. Fill in the query name.&#x20;
5. You can choose cache time. Cache time help us display the dashboard faster for viewer, and reduce the load for your database server.
6. Write your SQL in the query box. You can view Schema and Table to help you while you are executing your query
7. After completing these steps, select **Next** to finish the process

That’s done, you already add a query to Dataflake!

<figure><img src="/files/AWP7tTJiw3dbdRAAYqkT" alt=""><figcaption></figcaption></figure>


# Edit, Delete a query

### Edit a query <a href="#od_146b6a39" id="od_146b6a39"></a>

To edit a query:

1. Select **Queries tab** then we can see all the queries with edit buttons at the right
2. Selecting **Edit** button

<figure><img src="/files/7691hrx2mJtN4JEnJ8Rs" alt="" width="375"><figcaption></figcaption></figure>

3. We can edit data source, the query, its name, cache time, and other information
4. Click **Next** to successfully edit the query

<figure><img src="/files/ZdOIxRY51E2Il1DL5aPJ" alt="" width="375"><figcaption></figcaption></figure>

### Delete a query <a href="#od_15fd9017" id="od_15fd9017"></a>

To delete a query

1. Select **delete** button

<figure><img src="/files/izdQXrSQSsAvYp7Cqc5O" alt="" width="375"><figcaption></figcaption></figure>

2. Select **yes** to delete your query

<figure><img src="/files/3NxjYhgHYNv7jdapftll" alt="" width="336"><figcaption></figcaption></figure>

{% hint style="info" %}
&#x20;You can not undo your action when you delete your query
{% endhint %}


# Create a chart

Follow steps below to create your Chart.

Click ![](/files/3ieBjGR7mJQiLDeRWxJd)icon in the left menu bar and choose your desired chart you want to create

Click to add the chart on the canvas

On the right panel, choose connection and choose your created query

Move to the Data tab, you can see the available fields, which are from your created query

Drag and drop columns in availables field to create your Chart

Finalize the charts by adding title, choosing colors and style the graph

<figure><img src="/files/zdUwYo1iXMRzfXKf1CpI" alt=""><figcaption></figcaption></figure>

**If you haven't written your query before you add a chart, you can add a query and chart simultaneously**

Click ![](/files/3ieBjGR7mJQiLDeRWxJd)icon in the left menu bar and choose your desired chart you want to create

Click to add the chart on the canvas

On the right panel, choose connection and write SQL on the query box, you can view the Schema and Table&#x20;

Name your query after writing

Choose Cache time and Tags if you want

Move to the Data tab, you can see the available fields, which are from your created query

Drag and drop columns in availables field to create your Chart

Finalize the charts by adding title, choosing colors and style the graph

<figure><img src="/files/nuXV8GEHfSzRyUrkBzpT" alt=""><figcaption></figcaption></figure>


# Chart types

Learn types of charts that Dataflake is supporting!

Making your data impactful is the first thing you need to consider when compiling your Dashboard. That is why you need to know how to transform data into proper and efficient visualization. Different charts embody different purposes, and tell different stories, therefore, understanding each type of chart definitely does wonders for your Dashboard creation.

Dataflake highly customizable visualizations help you to ease your work with advanced styling options. But first, in this article, let's learn about Chart Types in Dataflake: Bar Chart, Line Chart, Mixed Chart, Card Chart, Table Chart, Bubble Chart, Horizontal Chart, Scatter chart, Sankey Diagram, Map Chart

### Pie chart <a href="#od_f2d44f71" id="od_f2d44f71"></a>

Pie chart is used to illustrate the share of total. It presents well with simple proportions such as one-half, one-third, or one-quarter. Pie charts do not show changes over time such as bar and line charts.

![](https://api.filerobot.com/opendocs-global/v1/get/05a46eb2-35ca-5457-a055-ead97eb50000)

### Bar Chart <a href="#od_0a64e439" id="od_0a64e439"></a>

Bar chart is to describe the changes in a given period of time or to compare the difference between categories.

![](https://api.filerobot.com/opendocs-global/v1/get/309cd2e6-36a8-55e5-a11c-9a41ad950000)

### Stacked Bar chart <a href="#od_ca3b1ab3" id="od_ca3b1ab3"></a>

Stacked bar charts show totals and their shares, so we can see the comparison between categories in a given period of time.

![](https://api.filerobot.com/opendocs-global/v1/get/6a8f4afe-c1be-5a98-a724-ee8b25950000)

### Line chart <a href="#od_a67e1e84" id="od_a67e1e84"></a>

Line chart is to illustrate the changes overtime for one or more than two categories.

![](https://api.filerobot.com/opendocs-global/v1/get/dccf0497-c120-5022-989e-6423cd850000)

### Mixed Chart <a href="#od_a6e740d5" id="od_a6e740d5"></a>

Mixed chart is the combination of different types of charts. It is used to visualize the differences between different sets of data.

![](https://api.filerobot.com/opendocs-global/v1/get/086f6f7f-4079-5664-b73c-eb4661050000)

### Card Chart <a href="#od_e5a8becf" id="od_e5a8becf"></a>

Data card is to illustrate the overview of dashboards.

![](//store.filerobot.com/opendocs-global/ab89a7c477f905496b21cdb2b54328339487c54c772ddbddbb1c4da872b54f1c.png)

### Table Chart <a href="#od_03933969" id="od_03933969"></a>

Table arranges data in rows and columns, which shows detailed and comprehensive data.

![](https://api.filerobot.com/opendocs-global/v1/get/12ca0fab-63a4-5666-b518-63fde0650000)

### Bubble Chart <a href="#od_0ca37bda" id="od_0ca37bda"></a>

Bubble chart is much like a scatter chart, but a third column is added to show relationships amongst 3 numeric variables. The size of bubble illustrates the data points

![](https://api.filerobot.com/opendocs-global/v1/get/f296bfa6-542c-50e9-9fe8-8533b0150000)

### Horizontal Chart <a href="#od_92577d3f" id="od_92577d3f"></a>

Horizontal Chart is a bar graph that draws horizontally. The data categories are presented on the vertical axis. The data values are on the horizontal axis. It is great to use in case the name of categories is long&#x20;

![](https://api.filerobot.com/opendocs-global/v1/get/737510e0-d896-5bce-b81c-d212c0750000)

### Scatter chart <a href="#od_9a95cec9" id="od_9a95cec9"></a>

As known as scatter plot, scatter chart displays the relationship between two variables, helping to know a relationship or trend.

![](https://api.filerobot.com/opendocs-global/v1/get/154bfd6d-16ae-5d5c-8c5c-db6852d50000)

### Sankey Diagram <a href="#od_80c184fe" id="od_80c184fe"></a>

Sankey Diagram is used to illustrate a flow from several entities (aka nodes) to another. Several entities are displayed in rectangles or text. The connections (aka links) are displayed by arrow. The wider the arrow, the more important the flow amount.\
Sankey Diagram is for mapping particular kinds of domains, for example, flow of electrical energy from source to destination.

![](https://api.filerobot.com/opendocs-global/v1/get/f11e0aae-9188-5d28-8e96-95e39cd50000)

### Map Chart <a href="#od_dff14acf" id="od_dff14acf"></a>

Map chart is to represent geographical data. It is to show data distributed across a particular region.

When creating map chart in Dataflake, you must add the[ 2-digit country codes](https://www.iban.com/country-codes) or [3-digit country codes](https://www.iban.com/country-codes) in your data to show on map chart

![](https://api.filerobot.com/opendocs-global/v1/get/5c4a414c-3f9b-5bde-a748-b686b4150000)


# Bar chart

### When should we use a bar chart? <a href="#od_89fc757a" id="od_89fc757a"></a>

Bar charts are useful in various situations, and they are particularly effective when you want to display and compare the values of different categories or groups.&#x20;

### Create a bar chart&#x20;

Read this section to learn about how to create a chart [here](/visualizations/create-a-chart)&#x20;

### Style a bar chart&#x20;

Read [this section](/custom-charts/quick-styling-toolbar) to learn about how to use quick styling toolbar&#x20;

### Advanced styling options&#x20;

Read this section to learn about styling chart with many advanced options [here](/custom-charts/right-styling-panel)&#x20;


# Pie chart

### When should we use a pie chart? <a href="#od_89fc757a" id="od_89fc757a"></a>

Pie charts are useful in certain situations when you want to represent parts of a whole and emphasize the proportion of each component relative to the entire set.

### Create a pie chart&#x20;

Read this section to learn about how to create a chart [here](/visualizations/create-a-chart)&#x20;

### Style a pie chart&#x20;

Read [this section](/custom-charts/quick-styling-toolbar) to learn about how to use quick styling toolbar&#x20;

### Advanced styling options&#x20;

Read this section to learn about styling chart with many advanced options [here](/custom-charts/right-styling-panel)&#x20;


# Line chart

### When should we use a line chart&#x20;

A line chart is a type of graph that displays data points connected by straight line segments. It is commonly used to represent and visualize trends in data over a continuous interval or time span.

### Create a line chart&#x20;

Read this section to learn about how to create a chart [here](/visualizations/create-a-chart)&#x20;

### Style a line chart&#x20;

Read [this section](/custom-charts/quick-styling-toolbar) to learn about how to use quick styling toolbar&#x20;

### Advanced styling options&#x20;

Read this section to learn about styling chart with many advanced options [here](/custom-charts/right-styling-panel)&#x20;


# Horizontal bar chart

### When should we use a horizontal bar chart? <a href="#od_89fc757a" id="od_89fc757a"></a>

A horizontal bar chart is a variation of the traditional bar chart where the bars are plotted horizontally instead of vertically. In a horizontal bar chart, the categories or groups are displayed along the vertical axis, while the numerical values are represented by the length of the bars along the horizontal axis.

### Create a horizontal bar chart&#x20;

Read this section to learn about how to create a chart [here](/visualizations/create-a-chart)&#x20;

### Style a horizontal bar chart&#x20;

Read [this section](/custom-charts/quick-styling-toolbar) to learn about how to use quick styling toolbar&#x20;

### Advanced styling options&#x20;

Read this section to learn about styling chart with many advanced options [here](/custom-charts/right-styling-panel)&#x20;


# Mixed chart

### When should we use a mixed chart? <a href="#od_89fc757a" id="od_89fc757a"></a>

A mixed chart, also known as a combination chart, combines two or more different types of charts in a single visual representation. This approach allows you to present diverse sets of data and relationships in a more comprehensive manner.

### Create a mixed chart&#x20;

Read this section to learn about how to create a chart [here](/visualizations/create-a-chart)&#x20;

### Style a mixed chart&#x20;

Read [this section](/custom-charts/quick-styling-toolbar) to learn about how to use quick styling toolbar&#x20;

### Advanced styling options&#x20;

Read this section to learn about styling chart with many advanced options [here](/custom-charts/right-styling-panel)&#x20;


# Card chart

### When should we use a card chart? <a href="#od_89fc757a" id="od_89fc757a"></a>

Card chart is a simple and concise visualization that displays a single, specific data point or metric. It is often presented in the form of a card or a small panel and is designed to provide a quick and easily digestible overview of a critical piece of information.

### Create a card chart&#x20;

Read this section to learn about how to create a chart [here](/visualizations/create-a-chart)&#x20;

### Style a card chart&#x20;

Read [this section](/custom-charts/quick-styling-toolbar) to learn about how to use quick styling toolbar&#x20;

### Advanced styling options&#x20;

Read this section to learn about styling chart with many advanced options [here](/custom-charts/right-styling-panel)&#x20;


# Table

### When should we use a table? <a href="#od_89fc757a" id="od_89fc757a"></a>

A table is a structured arrangement of data in rows and columns, where each intersection of a row and a column represents a specific data point. Tables are commonly used to organize and present data in a systematic and easy-to-read format.

### Create a table&#x20;

Read this section to learn about how to create a [here](/visualizations/create-a-chart)&#x20;

### Style a table&#x20;

Read [this section](/custom-charts/quick-styling-toolbar) to learn about how to use quick styling toolbar&#x20;

### Advanced styling options&#x20;

Read this section to learn about styling chart with many advanced options [here](/custom-charts/right-styling-panel)&#x20;

### Configure conditional format

Conditional format in Dataflake helps you highlight cells with a single color or multiple colors based on cells' values.

To Add conditional format, Click ![](/files/wr1M2wZzStf9a22uxNMH) button on the quick styling toolbar

<figure><img src="/files/HY11xbPbKXdFMfl699PB" alt=""><figcaption></figcaption></figure>

On the right panel, click **Add condition format**&#x20;

<figure><img src="/files/IOP6zYVpEO1ClzwVvCnG" alt=""><figcaption></figcaption></figure>

#### **Single color**

Color style

* Color style enables you to define the color for one row in one column or entire rows.
* Select rows to format conditions
* Select text color
* Select cell's color

**Format rules**

If the cell's value is text, the conditions are as below:

* Is
* Is not
* Is not empty
* Is empty
* Not containing
* Contains
* Ends with
* Starts with
* Match with (Regex)

If the cell's value is number, the conditions are as below:

* Greater than
* Greater than or equal
* Less than
* Less than or equal
* Equal
* Not equal

<figure><img src="/files/EtBC38ik1ZU35EiM9Q3W" alt=""><figcaption></figcaption></figure>

#### **Color scale**

Format based on\
Choose the column value that you want to set format

<figure><img src="/files/YQrfvKM7WdOQTJ7ZtHZs" alt=""><figcaption></figcaption></figure>

**Color & style**\
Apply on: The column that you want to apply the color scale.\
Click on save to apply conditional formatting


# Bubble chart

### When should we use a bubble chart? <a href="#od_89fc757a" id="od_89fc757a"></a>

A bubble chart is a type of scatter plot in which data points are represented as bubbles. Each bubble typically has three dimensions: the horizontal position (X-axis), the vertical position (Y-axis), and the size of the bubble (diameter or area). The third dimension (size) is used to represent a quantitative value associated with each data point.

### Create a bubble chart&#x20;

Read this section to learn about how to create a bubble [here](/visualizations/create-a-chart)&#x20;

### Style a bubble chart&#x20;

Read [this section](/custom-charts/quick-styling-toolbar) to learn about how to use quick styling toolbar&#x20;

### Advanced styling options&#x20;

Read this section to learn about styling chart with many advanced options [here](/custom-charts/right-styling-panel)&#x20;


# Scatter chart

### When should we use a scatter chart? <a href="#od_89fc757a" id="od_89fc757a"></a>

A scatter chart, also known as a scatter plot, is a two-dimensional graphical representation of a set of data points. Each data point in a scatter chart is represented by a marker (such as a dot) that is placed on the chart based on its values for two variables - one plotted along the horizontal axis (X-axis) and the other along the vertical axis (Y-axis).

### Create a scatter chart&#x20;

Read this section to learn about how to create a chart [here](/visualizations/create-a-chart)&#x20;

### Style a scatter chart&#x20;

Read [this section](/custom-charts/quick-styling-toolbar) to learn about how to use quick styling toolbar&#x20;

### Advanced styling options&#x20;

Read this section to learn about styling chart with many advanced options [here](/custom-charts/right-styling-panel)&#x20;


# Sankey Diagram

### When should we use a sankey diagram? <a href="#od_89fc757a" id="od_89fc757a"></a>

A scatter chart, also known as a scatter plot, is a two-dimensional graphical representation of a set of data points. Each data point in a scatter chart is represented by a marker (such as a dot) that is placed on the chart based on its values for two variables - one plotted along the horizontal axis (X-axis) and the other along the vertical axis (Y-axis).

### Create a sankey diagram&#x20;

Read this section to learn about how to create a chart [here](/visualizations/create-a-chart)&#x20;

### Style a sankey diagram

Read [this section](/custom-charts/quick-styling-toolbar) to learn about how to use quick styling toolbar&#x20;

### Advanced styling options&#x20;

Read this section to learn about styling chart with many advanced options [here](/custom-charts/right-styling-panel)&#x20;


# Map chart

### When should we use a map chart? <a href="#od_89fc757a" id="od_89fc757a"></a>

A map chart, also known as a geographical map or choropleth map, is a type of chart that visualizes data based on geographic locations. It uses color-coded or shaded regions to represent values of a variable across different geographical areas.

### Create a map chart

Read this section to learn about how to create a chart [here](/visualizations/create-a-chart)&#x20;

### Style a map chart&#x20;

Read [this section](/custom-charts/quick-styling-toolbar) to learn about how to use quick styling toolbar&#x20;

### Advanced styling options&#x20;

Read this section to learn about styling chart with many advanced options [here](/custom-charts/right-styling-panel)&#x20;


# Manage charts


# Copy a chart

### Copy a chart within a page of a dashboard <a href="#od_c93a225c" id="od_c93a225c"></a>

There are two ways that allow you to copy a Chart

**You can use the shortcut**

1. In the current page, select graph/chart.
2. Use **Ctrl C** (Copy) (use C**ommand C** if you use Macbook). Use **Ctrl V** (Paste) (use **Command V** if you use Macbook).&#x20;
3. The copied chart will overlap with the previous chart.&#x20;
4. Let’s drag a copied chart to another space on the canvas.

**Or you can use copy element**

1. Select the graph/chart and click on the right mouse
2. Choose copy element
3. Press **Ctrl V** / **command V**

<figure><img src="/files/69PYNo1xDF5tds26SKnl" alt="" width="375"><figcaption></figcaption></figure>

### Copy a Chart across pages of a dashboard <a href="#od_75a2cf80" id="od_75a2cf80"></a>

**You can use a shortcut**

1. In the current page, select graph/chart
2. &#x20;Use **Ctrl C** (Copy) (use **Command C** if you use Macbook)&#x20;
3. Move to your desired page
4. Use **Ctrl V** (Paste) (use **Command V** if you use Macbook)

**Or you can use copy to pages**&#x20;

1. Select the graph/chart and click on the right mouse
2. Choose copy to pages and choose the page that you want to paste a chart&#x20;
3. The chart will be copied to the new page

<figure><img src="/files/KKO6diDsfjJM8ZryjDyi" alt="" width="375"><figcaption></figcaption></figure>


# Delete a chart

To delete a Chart, you can:&#x20;

1. Select the graph and click on the right mouse&#x20;
2. Select **Delete**

<figure><img src="/files/1soMaioyrLQmpOmkFnp1" alt="" width="375"><figcaption></figcaption></figure>

3. Confirm delete by selecting **Yes**

<figure><img src="/files/exwt2bAWC9FtojbP9CQ6" alt="" width="342"><figcaption></figcaption></figure>

**Another quick way is:**

1. Click the graph you want to delete
2. Press **Delete** key on the keyboard
3. Confirm delete by selecting Yes

{% hint style="info" %}
You can delete several charts by dragging the area containing charts, click **Delete** key on the keyboard and choose **Yes**
{% endhint %}


# Move a chart

You can move a chart from the current page to another page within a dashboard. Follow steps below:

1. Select the graph/chart and click on the right mouse
2. Choose move to pages and choose the page that you want to move the chart to
3. The chart will be moved to the new page

<figure><img src="/files/CUcjLvkiWkg67LI5e2Vs" alt=""><figcaption></figcaption></figure>


# Duplicate a chart

To duplicate a Chart

1. Select the graph and click on the right mouse
2. Select duplicate element

<figure><img src="/files/8ZSbRBr5kVQ47tFgNYJn" alt="" width="375"><figcaption></figcaption></figure>


# Custom charts


# Quick styling toolbar

Styling your chart easily and quickly with quick styling toolbar

### **Box**

When you style a box, it means that you style all components in your chart

Elements in Box include:

* Text color
* Background color
* Boder (Weight, Radius, Border line, Border color)
* Shadow

<figure><img src="/files/60ftOU5w6k0eVWWMEGNn" alt=""><figcaption></figcaption></figure>

### **Title**

Style elements for Title

* Font text
* Font size
* Text format (Bold, Italic)
* Title color

<figure><img src="/files/NbnLJsLvdwHoUeBNEut2" alt=""><figcaption></figcaption></figure>

### **Header**

{% hint style="info" %}
Apply for table chart&#x20;
{% endhint %}

You can click the header section or click “Header” in the toolbar

Below are some options you can see to style the header (name of column) in the table From the left to the right, let’s discover

Font family: Change the font of your header&#x20;

Fontsize: Change the size of your header&#x20;

Bold: Bold your header&#x20;

Italic: Format your header with italic side&#x20;

Text Color: Color your header&#x20;

Fill color: Fill color to your header area&#x20;

Text Alignment: Align your header to the left, central, right&#x20;

<figure><img src="/files/mO7r87QNzs4xK0NWztpk" alt=""><figcaption></figcaption></figure>

### **Legend**

A legend is an explanation of characters, symbols in chart. Like style title, there are some options you can do to style legend

* Font text for legend
* Font size
* &#x20;Legend text format (Bold, Italic)
* &#x20;Legend color

<figure><img src="/files/mnnSbuhwd8yxmEY03YNw" alt=""><figcaption></figcaption></figure>

### **Graph**

<figure><img src="/files/xUF84YQXS7owJBo7LuT0" alt=""><figcaption></figcaption></figure>

#### **Bar chart**

You can enable&#x20;

Bar stacking

Set stacking percentage

Unit type: choose unit type for your label

* Digital storage: B, KB, MB, GB, TB. For example: 1MB = 1024B
* Digital storage 10 base: B, KB, MB, GB, TB. For example: 1MB = 1000B
* Metric length: Mm, cm, dm, m, dam, hm, km
* Percentage: %
* Time: Microseconds, milliseconds, seconds, minutes, hours
* Other

**For data label, there are many choices you should style:**

Enable data labels: labels will show on bar graph

Label position: Above, Center, Below

Label orientation: Vertical, Horizontal

Font family: Choose font family for the label

Font size: Choose font size for the label

Font format : Bold, Italic

Color: Color your label

#### **Pie graph**

Chart type: Pie chart and donut-pie chart

Donut style: Choose inner radius to select the thick of donut chart

Slice label: Allow to choose percentage or label

Unit:

* Digital storage: B, KB, MB, GB, TB. For example: 1MB = 1024B
* Digital storage 10 base: B, KB, MB, GB, TB. For example: 1MB = 1000B
* Metric length: Mm, cm, dm, m, dam, hm, km
* Percentage: %
* Time: Microseconds, milliseconds, seconds, minutes, hours
* Other

**For data label, there are many choices you should style:**

Enable data labels: labels will show on bar graph

Label position: Above, Center, Below

Label orientation: Vertical, Horizontal

Font family: Choose font family for the label

Font size: Choose font size for the label

Font format : Bold, Italic

Color: Color your label

#### Line chart

Line style: Enable stacking line or/ and 100% stacking

**For data label, there are many choices you should style:**

Enable data labels: labels will show on bar graph

Label position: Above, Center, Below

Label orientation: Vertical, Horizontal

Font family: Choose font family for the label

Font size: Choose font size for the label

Font format : Bold, Italic

Color: Color your label

#### Horizontal bar chart

Horizontal bar chart is like bar chart, but it rotates to the horizontal style. You can style horizontal like style bar chart.

Note

{% hint style="info" %}
Bottom axis of horizontal bar chart is the left axis of bar chart

Left axis of horizontal bar chart is the bottom axis of bar chart
{% endhint %}

#### Mixed chart&#x20;

Line style

* Line weight: the visual lightness, darkness, or heaviness of a line within a drawing from 0 to 14
* Curve: Smooth, Straight, Stepline
* Area: toggle to enable

Bar style

* Column width: Extremely narrow, narrow, Default, Wide&#x20;
* Data label: See style a bar chart

Y axis

Reverse: reverse y axis to the opposite

Show value: Show or hide y axis value

#### Card chart

Mostly card chart are text and number, so, there are box and title options we can style

#### Table

Click the header section or Click “Data” in the toolbar Below are some options you can see to style your Data

From the left to the right, let’s discover

Select Column: Choose column to style. You can choose all columns

Font: Change the font of your data&#x20;

Fontsize: Change the size of your data&#x20;

Bold: Bold your data&#x20;

Italic: Format your data with italic side&#x20;

Text Color: Color your data&#x20;

Fill color: Fill color to your data area&#x20;

Text alignment: Align your data to the left, central, right&#x20;

#### Bubble chart

Size: pull to choose the size of node

**For data label, there are many choices you should style:**

Enable data labels: labels will show on bar graph

Label position: Above, Center, Below

Label orientation: Vertical, Horizontal

Font family: Choose font family for the label

Font size: Choose font size for the label

Font format : Bold, Italic

Color: Color your label

#### Scatter chart

Size: pull to choose the size of node

**For data label, there are many choices you should style:**

Enable data labels: labels will show on bar graph

Label position: Above, Center, Below

Label orientation: Vertical, Horizontal

Font family: Choose font family for the label

Font size: Choose font size for the label

Font format : Bold, Italic

Color: Color your label

#### Sankey Diagram&#x20;

**Nodes**

Aligment: Align nodes to the left, center, right or justify

Sort: Auto, Acsending, Descending, Input

Thickness: Adjust the thickness for nodes

Spacing: Identify the space beetween the source and the target

Border radius: Set for the nodes

**Links**

Enable gradient: enable to show gradient, unenable to unshow

Link contract: Adjust the size of link contract

**Format**

Unit: choose the unit for the value:

* Digital storage: B, KB, MB, GB, TB. For example: 1MB = 1024B
* Digital storage 10 base: B, KB, MB, GB, TB. For example: 1MB = 1000B
* Metric length: Mm, cm, dm, m, dam, hm, km
* Percentage: %
* Time: Microseconds, milliseconds, seconds, minutes, hours
* Other

**For data label, there are many choices you should style:**

Enable data labels: labels will show on bar graph

Label position: Above, Center, Below

Label orientation: Vertical, Horizontal

Font family: Choose font family for the label

Font size: Choose font size for the label

Font format : Bold, Italic

Color: Color your label

#### Map chart

Color: Choose the range of color topresent in the map

Border: Choose to set the border weight for area border

Unit type:

* Digital storage: B, KB, MB, GB, TB. For example: 1MB = 1024B
* Digital storage 10 base: B, KB, MB, GB, TB. For example: 1MB = 1000B
* Metric length: Mm, cm, dm, m, dam, hm, km
* Percentage: %
* Time: Microseconds, milliseconds, seconds, minutes, hours
* Other: Choose the unit for the value

### **X axis**&#x20;

{% hint style="info" %}
X axis is applicable for bar chart, horizontal bar chart, line chart, mixed chart, bubble chart, scatter chart
{% endhint %}

**Show value:** Click to show x axis, Hide to disappear x axis

**X scale:** scale the x axis

* Datetime: show time series in x axis. You can custom the date time format in “x tooltip format” field
* Category: show a dimension in x axis
* Numeric: order by number

**Reverse:** change the data’s x axis to the opposite

**Dimension position:** Horizontal, Incline, Vertical&#x20;

<figure><img src="/files/sODlZ3IWGQuFg6OUDXzX" alt=""><figcaption></figcaption></figure>

### Y axis&#x20;

{% hint style="info" %}
Y axis is applicable for bar chart, horizontal bar chart, line chart, mixed chart, bubble chart, scatter chart
{% endhint %}

**Show value:** Click to show left axis, Hide to disappear left axis

**Min/max value:** Min y axis value & Max y axis value Min & max value can be a number or math which is used to set max or min value for y axis

* max(a, b, c,...): to get max value
* min(a, b, c,...): to get min value

**Reverse:** change the data’s y axis to the opposite

<figure><img src="/files/5e7CTjTg2TLyi4ROpKfF" alt=""><figcaption></figcaption></figure>

### **Toolbar**

**Show toolbar:** You can see the toolbar shown on the right, click to download chart as file svg, png, csv

**Hide toolbar:** Toolbar will disappear in your chart

**Toolbar Position:** Position the toolbar within a chart

<figure><img src="/files/7wEoMATsKghNGMZ6RXoK" alt=""><figcaption></figcaption></figure>

###

&#x20;

###


# Right styling panel

Style a chart on the right panel

### Nagivate from quick styling toolbar to right panel <a href="#od_7864ef65" id="od_7864ef65"></a>

<figure><img src="/files/oFddORnxkGlBkKjj9Tm4" alt=""><figcaption></figcaption></figure>

### Right styling panel

Watch video below for more advanced stlyling chart on the right panel

<figure><img src="/files/YCMXjz089POrneOq4n00" alt=""><figcaption></figcaption></figure>


# Dashboard


# Add a dashboard

From the landing page, click to the **New Dashboard** button in the upper left side.

Then name the dashboard in the box and click **Create**

You’ll be directed to the **Dashboard Editor**&#x20;

<figure><img src="/files/XFQ1hPKtSYE6ZKuqeD4m" alt=""><figcaption></figcaption></figure>


# Dashboard Templates

When you access Dataflake, you can see many Dashboard templates with different purposes so that you can create a Dashboard from the template and start to customize it.

<figure><img src="/files/8YD0n7I2TW1TnWYc2egO" alt=""><figcaption></figcaption></figure>

1. Hover over the mouse to the template you want to choose and click **Use template** button
2. Name your Dashboard, then you will have the Dashboard like this
3. Begin customizing the Dashboard by modifying Connection string, query, chart styles and other elements if you wish

Dashboard template is the great option for you to quickly create a Dashboard without thinking too much on the styles and color. However, you can easily change them to meet your needs with customizable Dataflake styling options

![Photo alt #responsive](https://api.filerobot.com/opendocs-global/v1/get/f8e09c11-39ab-54b9-b558-b18c07650000)


# Manage Dashboard

### Create a new page <a href="#od_4659737a" id="od_4659737a"></a>

In the left of toolbar, click on ![](/files/WaVRTR6FIWl3AegsikkB) page icon to expand the full page list

At the bottom of the list, click ![](/files/b9G6ZvWqeMEW21Tzu7tD) icon to create a new page

<figure><img src="/files/UkBJFStKircNutg9LUuA" alt="" width="375"><figcaption></figcaption></figure>

### Page list options <a href="#od_39d86755" id="od_39d86755"></a>

**Rename the page:** click right away on the name and type to rename

**Delete and Duplicate page**

Click on the ![](/files/M1bpmEt0Yo7Lh3Weh2hR) icon on the right of page. There are two options:

<figure><img src="/files/ClbYblWsV07uSfwT2WGy" alt="" width="375"><figcaption></figcaption></figure>

**Delete:** remove page from the dashboard

**Copy**: duplicate page&#x20;

### Page Reordering <a href="#od_86fe16e0" id="od_86fe16e0"></a>

Follow steps as below:

1. Click and hold a page from the list
2. While click and hold a page, move the page up and down to reorder the page list

<figure><img src="/files/3VCM44tcmnEhyFYjc5yP" alt=""><figcaption></figcaption></figure>

### Hide page in view mode <a href="#od_ba9a05ff" id="od_ba9a05ff"></a>

Unable ![](/files/ecxwuJECTuqGSLVCosZL)on the right of the page name **to hide page in view mode**&#x20;

<figure><img src="/files/18TlKruq8i3Z22tKOLTt" alt="" width="375"><figcaption></figcaption></figure>

### Page setting <a href="#od_a7df7207" id="od_a7df7207"></a>

**Current page setting**&#x20;

Click the ![](/files/nOyJqCu5N8KcA8zcxTBr) in the top right toolbar

* Adjust width and height
* Adust background color
* Enable box shadow
* Set time for auto refresh

Choose **Free style canvas** or **Grid layout** if you want

<figure><img src="/files/aybt3rCvOfa1OhJTLk9i" alt="" width="375"><figcaption></figcaption></figure>

### Layout Settings <a href="#od_e05c0cbe" id="od_e05c0cbe"></a>

Hover ![](/files/wYhWwCJaMZ2WSFSHSZzc)on the top right of the Dashboard editor to see all Dashboard Management options

Click ![](/files/QUzEyfS35By8mWGLnMbD)to set Header or Footer of the page

**Header**\
Show header: show/hide header\
H: add height for the header comparing to the furthest upper canvas\
Background color: Choose color for the header background

<figure><img src="/files/8Yn6zOOdSUDWj2oWzO44" alt="" width="375"><figcaption></figcaption></figure>

**Footer**\
Like header section, you can do the same to set the footer

<figure><img src="/files/az573sIqwjQqlup4z1CK" alt="" width="375"><figcaption></figcaption></figure>


# Manage Legend Color

Universally assign color to a legend

### **Create a new legend color** <a href="#od_773571c0" id="od_773571c0"></a>

Hover ![](/files/wYhWwCJaMZ2WSFSHSZzc)on the top right of the Dashboard editor to see all Dashboard Management options

Click ![](/files/5CuGxsu4lNmq1ZXc3Kca)to set a color for the legend you want

Column name: Enter the field you want to set color for the legend&#x20;

Click on icon to create the new legend color

{% hint style="info" %}
All legends color that are set in this tool will be universally updated all throughout the dashboard for all charts using the same field
{% endhint %}

<figure><img src="/files/FtvcLzy0LAuZy9cThFy5" alt=""><figcaption></figcaption></figure>

To make update to a field for a single chart, you can edit fields individually for each single chart. You can delete by clicking ![](/files/mXKxJirIUupcKAO1fi9T)icon


# Manage chart labels

Universally create and edit chart labels

### **Create a new label** <a href="#od_c1662b49" id="od_c1662b49"></a>

Click ![](/files/Wx3mYJYKQ23Rs64KcvWM) icon in the top right of the Dashboard

**Column name:** enter the field you’d like to change the name for the label&#x20;

**Label:** enter the name you’d like to use for the field instead of the original field name

Click **Add** to add the new label

{% hint style="info" %}
All fields that are renamed in this tool will be universally updated all throughout the dashboard for all charts using the same field
{% endhint %}

<figure><img src="/files/UH8pYOiG1NKYAMTDSRzU" alt="" width="375"><figcaption></figcaption></figure>

To make update to a field for a single chart, you can edit fields individually for each single chart. You can delete by clicking ![](/files/Fyl8E4dJlCOoBc3Ymbrm) icon


# UI elements&#x20;

### **Text** <a href="#od_a86e0fe5" id="od_a86e0fe5"></a>

Add titles, headings, and descriptions to your reports using text.&#x20;

#### **Add Text**

Select the ![](/files/HM2rGP6c055xryzDOgeC) icon from left toolbar.

Click on the canvas to place a box

Fill up the blanks with your text.

![Photo alt #responsive](https://api.filerobot.com/opendocs-global/v1/get/0f703a38-de35-520f-b264-c512a2250000)

#### **Style Text**

1. Select the text you want to use.
2. Change the font, size, color, alignment, overflow settings, border settings and other properties of the text in the toolbar underneath

![Photo alt #responsive](https://api.filerobot.com/opendocs-global/v1/get/01324194-7f58-5211-a7b8-47a8b9b50000)

### **Shape** <a href="#od_bc5f5413" id="od_bc5f5413"></a>

Shape is used to visually separate data components, banners, and other graphical effects

**Add Shape**

1. Select the **Shape** icon from the toolbar to create a shape
2. Square
3. Triangle
4. Octagon
5. Oval / Circle

<img src="https://api.filerobot.com/opendocs-global/v1/get/e9a1e568-5838-5e6c-a2c5-49c8e1450000" alt="Photo alt #responsive" width="188">

On the canvas, click to place a box where you want the shape to appear.

![Photo alt #responsive](https://api.filerobot.com/opendocs-global/v1/get/1b4ff947-1968-55b3-b3aa-b5d10b150000)

#### **Style a shape**

To adjust the shape’s look, use the shape **Style** toolbar underneath the shape

1. **Shape tyle:** change type of shape
2. **Border style:** include solid, dashed, dotted
3. **Border color:** remove or set colors for border
4. **Shape color:** choose colors for shape
5. **Border**

* Border weight: set the lightness or thickness for the border.
* Border radius: make rounded corners for shapes
* Style and color of border

![Photo alt #responsive](https://api.filerobot.com/opendocs-global/v1/get/e3e18de3-08c5-5a7f-9b20-0f7128f50000)

### **Image** <a href="#od_82bb69ae" id="od_82bb69ae"></a>

Images are used to add logos and pictures to your dashboard

#### **Add an image**

Select the ![](/files/58Uw9pnNoQaewAN3vAVb) icon from the toolbar.

<img src="https://api.filerobot.com/opendocs-global/v1/get/f62c82a6-edde-5a12-8c3a-c1402e150000" alt="Photo alt #responsive" width="188">

Choose the type of image you would like to upload.\
**From URL link:** type in the URL for a web-based image.\
**Upload from your computer:** choose an image from your hard drive and insert it into the canvas.

On the canvas, place a box where you want the image to display. The image’s size is determined by the size of the box.

**Choose image size type.**

**Fit:** The image is sized automatically to fit the frame (the image ratio will change depending on the frame size)\
**Contain:** The image is scaled to maintain its aspect ratio.\
**Cover:** The image is sized to maintain its aspect ratio while filling the frame

**Style image with background color and border radius option**


# JSON Card

Display JSON response data from API

### **How to add a JSON card** <a href="#od_5576d085" id="od_5576d085"></a>

To add a JSON card to your reports,

1. Click the ![](/files/zjDlovAY94ri5vXwvHtT) icon on the left toolbar.
2. Drag select an area you want to add the JSON card on the report.

<img src="https://api.filerobot.com/opendocs-global/v1/get/53949235-9775-53dc-aff3-1fa166b50000" alt="Photo alt #responsive" width="375">

* **URL:** enter the full URL that you want to get data from. Note:
* Because of security policies, your URL have to use https scheme.
* Can include a param and allow user to change it in a filter.
* Example: <https://my-domain/path/{path_param}?query_param={query_param}>
* **Request method:**
* Get: retrieve data from a server at the specified resource.
* Post: send data to a server to create/update a resource.
* **Request timeout:** maximum time when trying to call API. When request time exceeds the maximum, we will show an error.\
  Note: Leave it empty if you don’t want to set a maximum time.
* **Data path:** path to a property of response JSON object (in case user don’t want to display whole response object)\\
* Note: leave it empty to display whole response
* Example: When your api response with: { status: “success” data: { propertyA: “valuable data”\
  } } And you want to show only “valuable data", you can config data path = data.propertyA

#### **Style a JSON Card** <a href="#od_1725a03a" id="od_1725a03a"></a>

Choose the look for your JSON card

<img src="https://api.filerobot.com/opendocs-global/v1/get/ad6efe65-9fe8-55c5-a8ef-082fc1950000" alt="Photo alt #responsive" width="375">

1. Click on tab “Style” in the right panel
2. Tooltip note: Note on the box, then you can see the question mark on the top right corner of filter
3. The rest styling options appear on the bottom toolbar

<img src="https://api.filerobot.com/opendocs-global/v1/get/c803ab77-73e4-5027-919c-b46f80350000" alt="Photo alt #responsive" width="188">

**JSON Card style**

1. **Fill color:** Fill color to the box
2. **Border:**
3. **Weight:** choose weight for the line of filter box
4. **Radius:** Choose to round filter box
5. **Style:** Style the line of filter box

<img src="https://api.filerobot.com/opendocs-global/v1/get/b5806d34-a313-564f-8f5b-9b57dea50000" alt="Photo alt #responsive" width="375">

6. **Add box shadow:** enable if you want to give the log element a more prominent look

<img src="https://api.filerobot.com/opendocs-global/v1/get/6dd9258e-e1e3-5bb8-b0a7-03f223450000" alt="Photo alt #responsive" width="188">


# Drilldowns


# Zoomed-in Analysis

Analyze a specific range of a graph.

### **Zoomed-in analysis of a single chart**

You can further analyze a chart in depth for a custom range to your needs.

Open in a view mode

1. On the chart you’d like to analyze, click the "box" icon
2. Drag select a specific range you’d like to analyze
3. **To unselect:** click outside the selected area to deselect the selection
4. **To extend or reduce the range selection:** drag right and left the icon to extend
5. Once the range has been selected, right click and select **Zoom analysis this range**

![Photo alt #responsive](https://api.filerobot.com/opendocs-global/v1/get/a8012e8e-69cf-586b-8493-e4e277c50000)

### **Analysis comparison between multiple charts**

Ability to do the same analysis as single zoomed-in analysis but can compare between multiple charts.

1. On the chart you’d like to analyze, click the **box** icon
2. Drag select a specific range you’d like to analyze

* To unselect: click outside the selected area to deselect the selection
* To extend or reduce the range selection: drag right and left the icon to extend
* Once the range has been selected, right click and select **Zoom and compare this range**

A zoom analysis popup will show up

![Photo alt #responsive](https://api.filerobot.com/opendocs-global/v1/get/61986a13-3cde-5f2e-908b-9e781a750000)

{% hint style="info" %}
Zoomed-in analysis works in case types of chart are: Line chart, mix chart and bar chart, as well as, X scale = datetime&#x20;
{% endhint %}


# Table Chart Comparison & Running

### **Comparison Calculations** <a href="#od_6883bdd7" id="od_6883bdd7"></a>

You can include metrics that compare the overall value of a column to each row of your data.

1. In **Columns** section, click the **pen** icon

<figure><img src="/files/9Wv0vDYhQ2PghOmbHI9B" alt="" width="375"><figcaption></figcaption></figure>

1. Click on the down arrow in the **Comparison calculation** field to select the type of comparison calculation you want to use
2. Percent:total - the current row's value divided by the total for that field.
3. Percent:max - the current row's value divided by the maximum value for that field.
4. Diff:total - the total for that field minus the current row's value.
5. Diff:max - the current row's value minus the maximum value for that field.
6. Percent-diff:total - the total for that field minus the current row's value divided by the total for that field.
7. Percent-diff:max - the current row's value minus the maximum value for that field divided by the total for that field.

<figure><img src="/files/yrPesh2Q5GeyvpCdTOqp" alt="" width="375"><figcaption></figcaption></figure>

{% hint style="info" %}
**Another quick way to turn on the running calculations box is click the icon near the header of the table chart**
{% endhint %}

<figure><img src="/files/T3buau4OU85gRxfLiJv7" alt="" width="275"><figcaption></figcaption></figure>

### **Running calculations** <a href="#od_cf3d17cc" id="od_cf3d17cc"></a>

Running computations produce a set of summary outcomes based on a set of data. They produce a result for each row of input, indicating how that row relates to the rest of the collection.

1. In **Columns** section, click the **pen** icon
2. Click on the down arrow in the **Running calculation** field to select the type of comparison calculation you want to use

* Running sum: sum all value from current row up
* Running min: minimum value from current row up
* Running max: maximum value from current row up
* Running count: current row value
* Running average: average value from current row up
* Running delta: value of current row - value of the row above

<figure><img src="/files/zJWvaBRz34z2OUDktyhG" alt="" width="375"><figcaption></figcaption></figure>

{% hint style="info" %}
Another quick way to turn on the running calculations box is click the icon near the header of the table chart
{% endhint %}

<figure><img src="/files/6KARN8EvURLWCOFmbbei" alt="" width="268"><figcaption></figcaption></figure>


# Graph Max/ Min/ Average

Display the max/ min/ average values on the chart

1. On the chart you’d like to show the max/ min/ average values right on the chart, go to **Style** tab on the right panel
2. Scroll down to section Max./ Min./ Average
3. Toggle **ON** the value you want to show on the chart

When enabled, the value will show on the bottom of the chart

<figure><img src="/files/ni5F3pCnEdc51dPfv5Yg" alt=""><figcaption></figcaption></figure>


# Filter/ Data Control

### **Date range filter** <a href="#od_0ca98877" id="od_0ca98877"></a>

#### **Create a date range filter**

Date range filter allows you to filter your report data based on **a date and time range.**

1. Click on the ![](/files/AFKtVFP4GsMA3BaZXSTC)icon on the left toolbar to show the list of available filters

<img src="https://api.filerobot.com/opendocs-global/v1/get/521139a2-4520-5a43-89c2-a34332950000" alt="Photo alt #responsive" width="188">

1. Select **Date range filter** to begin adding this type of filter to the canvas
2. Drag select an area on the canvas to place the filter on the dashboard&#x20;

<img src="https://api.filerobot.com/opendocs-global/v1/get/7ffe738a-1222-50be-aa22-5a0fbb050000" alt="Photo alt #responsive" width="375">

1. In the right panel, fill out the following fields in **Filter** tab to customize the functionality of the filter
2. **Label:** enter the name you want to name the filter
3. **Key:** select the parameters you’d like to use for the filter
4. **Default value:** select the from and to date range for the date filter
5. **Show time select:** select when you’d like to show the filter for time in addition to the date range
6. **Hide when exist on URL:** You can show or hide filter when you share via URL

#### **Style a date range filter**

1. **Search:** Search option you want to appear by text in the box
2. &#x20;**Label font size:** Choose the size for label
3. **Data font size:** Choose the size for Data
4. **Line break between and input:** Allow to break a line between label and data\
   a. Tick box to enable\
   b. Untick box to disable

<img src="https://api.filerobot.com/opendocs-global/v1/get/5ab62194-4e97-54ad-b0af-7a5f35150000" alt="Photo alt #responsive" width="375">

5. **Show description:** Note on the box, then you can see the question mark on the top right corner of filter

**Like style your chart, you can style your filter box by looking at the bottom toolbar below**

**From the left to the right:**

1. **Font:** Choose font for your filter
2. **Font size:** Choose size for your filter
3. **Format:** Bold, Italic
4. **Text color:** Color the filter text
5. **Fill color:** Fill color to the filter box
6. **Vertical alignment:** align the filter to top, center, bottom
7. **Border:**

* Weight: choose weight for the line of filter box
* Radius: Choose to round filter box
* Style: Style the line of filter box
* Color: Color the line of filter box

<img src="https://api.filerobot.com/opendocs-global/v1/get/4cd62560-54e8-589a-9336-4690d7650000" alt="Photo alt #responsive" width="375">

8. **Box alignment:**

Align the content inside the filter box to the side you want to set

<img src="https://api.filerobot.com/opendocs-global/v1/get/e71bda26-ce0e-5eb9-bc3a-9ccf47850000" alt="Photo alt #responsive" width="375">

9. **Box shadow:**\
   Tick box to enable box shadow Untick box to unable box shadow

<img src="https://api.filerobot.com/opendocs-global/v1/get/ec15c409-98f9-5759-9ebb-d41892a50000" alt="Photo alt #responsive" width="188">

### **Text filter** <a href="#od_7a2666ee" id="od_7a2666ee"></a>

Filter for matching text.

#### **Create a text filter**

1. Click on the **"filter"** to show the list of available filters

<img src="https://api.filerobot.com/opendocs-global/v1/get/26e5ad49-7ba8-59d7-9516-2b6a2ee50000" alt="Photo alt #responsive" width="188">

2. Select **“Text”** to begin adding this type of filter to the report canvas
3. Drag select an area on the canvas to place the filter on the report
4. In the right panel, fill out the following fields in **“Filter”** tab to customize the functionality of the filter

* **Label:** enter the name you want to name the filter
* **Key:** select the parameters you’d like to use for the filter c. Hide when exist on URL:\
  When enabled, this filter will be hidden when its param exists on the URL.<br>

Ex: filter is using params @my\_param&#x20;

Case 1: url is <https://app.dataflake.co/s/xxx/?my_param=value> => Filter is hidden&#x20;

Case 2: url is <https://app.dataflake.co/s/xxx>=> Filter is visible&#x20;

Case 3: url is <https://app.dataflake.co/s/xxx/?not_my_param=value> => Filter is visible

* **Select input:** if enabled, set settings for the following&#x20;

**Multiple select:** enabled if you want to allow viewers to apply multiple filter options at once\
**Default all options:** set default to all when using options from a datasource&#x20;

**Enabled** **Disabled:** will need to set **“Default value”** if disabled&#x20;

**Condition:** set the condition to be check against the value input

<img src="https://api.filerobot.com/opendocs-global/v1/get/f7018f3d-7bbc-56e7-831f-ad85d9250000" alt="Photo alt #responsive" width="375">

&#x20;**Options source**

**Manual:** input filter options by hand

* Click “Add an option” to manually add an option
* All added options are listed under “Options”

**Data source:** pull filter options from data through queries

<img src="https://api.filerobot.com/opendocs-global/v1/get/b10a4b09-dba8-5b4b-b958-2ce387e50000" alt="Photo alt #responsive" width="375">

* Choose database connection you would like to pull options from
* Choose a query from an already existing query
* Click **"+"** icon to add a new query

#### **Style a text filter** <a href="#od_1855638a" id="od_1855638a"></a>

To style the look of the filter, click on **Style** tab

1. **Search**: Search option you want to appear by text in the box
2. **Label font size**: Choose the size for label
3. **Data font size:** Choose the size for Data
4. **Line break between and input:** Allow to break a line between label and data

* Tick box to enable
* Untick box to disable

5. **Show description:** Note on the box, then you can see the question mark on the top right corner of filter

<img src="https://api.filerobot.com/opendocs-global/v1/get/2b6c2f3b-8ce3-5a14-a358-422825250000" alt="Photo alt #responsive" width="375">

**Like style your chart, you can style your filter box by looking at the bottom toolbar below:**

From the left to the right:

1. **Font:** Choose font for your filter
2. **Font size:** Choose size for your filter
3. **Format:** Bold, Italic
4. **Text color:** Color the filter text
5. **Fill color:** Fill color to the filter box
6. **Vertical alignment:** align the filter to top, center, bottom
7. **Border:**
8. **Weight:** choose weight for the line of filter box
9. **Radius:** Choose to round filter box
10. **Style:** Style the line of filter box
11. **Color:** Color the line of filter box

<img src="https://api.filerobot.com/opendocs-global/v1/get/bd9c6d9d-49a6-5bd9-9441-5e3a0d950000" alt="Photo alt #responsive" width="375">

12. **Box alignment**

Align the content inside the filter box to the side you want to set

<img src="https://api.filerobot.com/opendocs-global/v1/get/654a8ff2-d1ad-5dc0-9af4-943b7a850000" alt="Photo alt #responsive" width="188">

13. **Box shadow:**\
    Tick box to enable box shadow Untick box to unable box shadow

<img src="https://api.filerobot.com/opendocs-global/v1/get/8b66ab30-ae49-5b25-9267-82a332350000" alt="Photo alt #responsive" width="188">

### **Absolute time range** <a href="#od_ff16cef9" id="od_ff16cef9"></a>

#### **Create an absolute time range**

Use this filter if you would like to use something similar to **“Date range”** filter but with advanced customization options.

1. Click on the![](/files/fcFJKjEvBJ9ItXBZ9nfo)to show the list of available filters

<img src="https://api.filerobot.com/opendocs-global/v1/get/4c25c392-e286-5249-8cf9-31134bb50000" alt="Photo alt #responsive" width="188">

1. Select **Absolute time range** to begin adding this type of filter to the report canvas
2. Drag select an area on the canvas to place the filter on the report
3. In the right panel, fill out the following fields in **Filter** tab to customize the functionality of the filter

* **Label:** enter the name you want to name the filter
* **Key:** select the parameters you’d like to use for the filter&#x20;

**Default value**&#x20;

a. **Absolute time range:** enter the custom days from now () for from and to you would like to set&#x20;

b. **Around fixed value:** the day you would like to use as “now()”&#x20;

c.**Relative time range:** select a relative time range from now, Ex: when select “last 5 minutes” query params will have values “now()” and “now() - 5 minutes”

<img src="https://api.filerobot.com/opendocs-global/v1/get/63164c01-432e-5474-b31d-85a82f850000" alt="Photo alt #responsive" width="375">

#### **Style an absolute time range filter**

To style the look of the filter, click on **“Style”** tab

1. **Search:** Search option you want to appear by text in the box
2. **Label font size:** Choose the size for label
3. **Data font size:** Choose the size for Data
4. **Line break between and input:** Allow to break a line between label and data Tick box to enable Untick box to disable
5. **Description note:** Note on the box, then you can see the question mark on the top right corner of filter

<img src="https://api.filerobot.com/opendocs-global/v1/get/81309e20-5fef-5b35-bb34-b3c6e9750000" alt="Photo alt #responsive" width="375">

**Like style your chart, you can style your filter box by looking at the bottom toolbar below:**

From the left to the right:

1. **Font:** Choose font for your filter
2. **Font size:** Choose size for your filter
3. **Format:** Bold, Italic
4. **Text color:** Color the filter text
5. **Fill color:** Fill color to the filter box
6. **Vertical alignment:** align the filter to top, center, bottom
7. **Border:**
8. **Weight:** choose weight for the line of filter box
9. **Radius:** Choose to round filter box
10. **Style:** Style the line of filter box
11. **Color:** Color the line of filter box

<img src="https://api.filerobot.com/opendocs-global/v1/get/bd70d8e8-7077-5d71-b6a4-cedf53850000" alt="Photo alt #responsive" width="375">

12. **Box alignment**

Align the content inside the filter box to the side you want to set

<img src="https://api.filerobot.com/opendocs-global/v1/get/e7ce07de-f388-5555-aac3-30f301a50000" alt="Photo alt #responsive" width="375">

13. **Box shadow:**\
    Tick box to enable box shadow Untick box to unable box shadow

<img src="https://api.filerobot.com/opendocs-global/v1/get/f1b0917d-5859-532e-8722-074f31650000" alt="Photo alt #responsive" width="375">


# Create an email delivery Schedule

Email Delivery helps to ease your repetitive work by automatically sending dashboards periodically based on your configuration.

Set conditions for scheduling periodic email dashboards which contain your dashboard. When the recipient receives and clicks the email, they will easily access the dashboard

This article will show you how to schedule an email delivery.

1. Open the Dashboard you want to schedule in view mode by clicking on the ![](/files/vN1jETilO1IKJH8Aw46u)icon&#x20;

{% hint style="info" %}
**You must be an owner or editor of this Dashboard**
{% endhint %}

2. In the upper right, click **Share** button
3. Click **Schedule email delivery** to begin scheduling a dashboard. The email delivery will be shown as below, to schedule the email, you can:

![Photo alt #responsive](https://api.filerobot.com/opendocs-global/v1/get/20504b65-effa-5e20-9b58-228d42b50000)

4. Enter the email address(s) of the recipients you want to send the dashboard to.
5. **(Optional)**: Custom email subject and message.

![Photo alt #responsive](https://api.filerobot.com/opendocs-global/v1/get/c4ad8717-d4ba-5872-b42a-7459b2a50000)

6. Set the **date and time** you want to send the dashboard.

![Photo alt #responsive](https://api.filerobot.com/opendocs-global/v1/get/12b8d8f1-20b1-5d4a-b9e2-495b26b50000)

7. Set the delivery frequency. Choose **Custom** to create a personalized schedule according to your needs.

![Photo alt #responsive](https://api.filerobot.com/opendocs-global/v1/get/f74605f5-3f5c-5d2e-8690-1eb165850000)

The dashboard then will be sent to the email that you enter before

### &#x20;<a href="#od_68cb9529" id="od_68cb9529"></a>


# Stop email delivery

When you want to stop delivering Dashboard via email, you just need a few clicks

1. Open the dashboard you want to stop the email delivery schedule in **view mode**. Make sure that you must be an owner or editor of this dashboard.
2. In the upper right, click **Share**
3. &#x20;Click **Email delivery** to go to the delivery schedule settings.

![Photo alt #responsive](https://api.filerobot.com/opendocs-global/v1/get/c7aeb1de-ea99-54e9-947c-f06075e50000)

4. At the bottom of the popup, click **Stop schedule**

![Photo alt #responsive](https://api.filerobot.com/opendocs-global/v1/get/5fc1fe96-88e8-5187-b879-049d99b50000)

The dashboard then **will not be sent** to the email that you enter before


# Share/ Embed Dashboard link

You can create an URL to a Dataflake report that you may distribute, utilize in web sites, or do anything else with links. The dashboar’s current settings, such as styling, can be included in the URL.

### Create a new share configuration&#x20;

1. Open Dashboard editor
2. In the top right corner of the Dashboard, click **Share** button to generate a new share configuration
3. Click **Create a new share config** button

<figure><img src="/files/BgRUzDWYQMNgFSVadSkW" alt="" width="375"><figcaption></figcaption></figure>

4. Enter the following information to set up and customize the share configuration

* **Title:** enter title for the share configuration
* **Role:** the role of the user who has access to this share configuration
* **Authentication method:** select whether users need to enter a password to access the report
* **Password:** enter password if selected to authenticate with password
* **Pages:** select pages to be shared for the share configuration
* By default pages that are chosen to **Hide in view mode** are not selected to be shared. If you would like to still share those pages, please make sure that you select those pages
* **Default page:** the very first page the user will see upon accessing the report

<figure><img src="/files/DtMoWFNlqlopdrcBjaaw" alt="" width="375"><figcaption></figcaption></figure>

**Create sealing for your report**

1. **Disable:** no sealing for the report. Be careful when choosing **Disable** option because Your Dashboard is not protected when sharing external without sealing.
2. **Quick:**

{% hint style="info" %}
**Quick seal** seals some parameters values, in alpha order (ex. \&token=**xyz** \&customer=**abc**\&date1=2020 will use **abcxyz** as sealing string, if you use "customer,token" or "token,customer" as sealing parameters, because **customer** before **token** in alpha order)
{% endhint %}

* **Hash function**&#x20;

A hash function processes an input value, such as a string, and produces a consistent, fixed-length output. There are 3 hash functions: MD5, SHA-1, SHA-25&#x20;

MD5 creates a 128-bit hash, whereas SHA1 creates a 160-bit hash (20 bytes). The SHA-256 algorithm returns hash value of 256-bits, or 64 hexadecimal digits

For example, Your string: to\_date = 2023-12-12 (param value you want to seal using Hash function)

**MD5 Hash:** Df491bce52045a447683f82bf9936173

**SHA1 Hash:** 889e732df68ae54778977e2869a5210102dd9d46

Now, the URL link returns: <https://app.dataflake.co/s/………?to\\_date> = 2023-12-12\&quick\_seal=Df491bce52045a447683f82bf9936173

* **Salt**

To the high level of protection, hash salting generators matter. Salt is a cryptographically strong random string applied to a password before hashing. This salt is stored alongside the hash, enhancing security by thwarting attempts to decipher the original plaintext unless both sources are accessible to an attacker.

The applied secret key formula: **Secret key = hash (params + salt)**

When you want to create a secret key, you just need to enter plain text to compute the hash and type **“salt”**. For instance,&#x20;

<figure><img src="https://assets-global.website-files.com/640aa66687a187b529748057/65129d904c84be0d0ff1de4f_mgcJuVM-X61SNwQ-xD0jXQd7z9G7Ps9XN6MWBMio6dwAfXrwXCFaK7T1afhpMYtvRZavhTfU7ue6W2BHF3xX4BGHiS-lnfvTRNDSwzNOLoa_7NRsaZpAksqSIY9r3txTypHbEM-CNZIYlHn_AExnZTc.png" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/e8ce3zwOLXPr90PgSzZG" alt="" width="375"><figcaption></figcaption></figure>

‍3. **Advanced:** coming soon

Click **Save** to save the new share configuration

### Share Dashboard URL&#x20;

1. Click **share configuration** you created before

<figure><img src="/files/0DFtAHVi8EoxGYoxHl0l" alt="" width="375"><figcaption></figcaption></figure>

2. Go to **Share demo** section

<figure><img src="/files/Q1mj16Zs1sdGieShsgJF" alt="" width="375"><figcaption></figcaption></figure>

3. Select **URL** in the **Share type** field
4. Enter **seal params value** if any
5. Copy paste the URL and share it with your teams

Or you can embed the Dashboard link into the application or website&#x20;


# Embed Iframe

You can embed it into any other website that supports iframes, making it easy to share your data story as widely as possible.

### **How embedding works**

* Any website or app that supports the HTML iframe tag can be used to incorporate an embed report.
* Dataflake automatically generates the iframe code, which contains a link to your report. There is no need to know HTML.
* Anyone who visits your page can access the embedded report according to the share configuration you have set up.
* Users viewing reports are under viewing only mode.
* Filters and date range controls work as they should in embedded reports. Due to the lack of a navigation bar, users are unable to edit, copy, or distribute the report.
* The data in display cannot be refreshed by viewers. Data only refreshes following the cache settings.

### **Embed via HTML iframe**

1. Set up a new share configuration.&#x20;

See this section to learn how to set up a new share configuration [here](/share-embed/share-embed-dashboard-link)&#x20;

2. Save the new share configuration
3. Go to **Share demo** section
4. Select **Embed** in the **Share type** field

<figure><img src="/files/ahD1RMRWfAUmlhbk8YmM" alt=""><figcaption></figcaption></figure>

5. Enter **seal params value** if any
6. Change the **width** and **height** of the report to be embedded to your preference

<figure><img src="/files/q8gBcNjZTiQs5iySmkkh" alt="" width="375"><figcaption></figcaption></figure>

7. Copy paste the iframe to your site


# Security Overview

Ensuring your data security is our top priority

Go to our [Security](https://www.dataflake.co/security) Page

### Where are Dataflake Data Centers located?

* Asia-Pacific Data Center is located in Singapore
* Western Europe Data Center is located in Germany

### Does Dataflake store my Data?&#x20;

**Dataflake does not** **store** your data in our servers. You take full control over your data.&#x20;

Dataflake sends the query directly to your database and no more than that, so the database user just needs the **SELECT (Read)** permission on tables used in the SQL. We always recommend giving enough permissions to your user to keep your database safer from cyber attacks

However, if you use cache, Dataflake will store the query result in Dataflake based on the cache time. This will help us display the dashboard faster for viewer, and reduce the load for your database server. When the cache time is expired, we no longer store your cache data in Dataflake servers.&#x20;

### How do Dataflake protect your database credentials?  <a href="#since-our-database-credentials-are-stored-in-holisticss-system-how-do-you-protect-them" id="since-our-database-credentials-are-stored-in-holisticss-system-how-do-you-protect-them"></a>

We prioritize the utmost security for your data credentials throughout our data visualization process. From the moment you input your information, we employ SSL encryption to ensure a secure transfer, protecting your credentials from any potential unauthorized access. Once in our systems, your credentials are stored with the highest level of protection using public key cryptography, adding an extra layer of security to deter unauthorized access.&#x20;

To minimize the risk of exposure, we adhere to a decrypt-only-when-necessary approach, ensuring that your credentials are only decrypted during specific query executions, thus avoiding any inadvertent leaks. Additionally, we take meticulous care to conceal your credentials in returned responses, providing an added layer of protection against accidental disclosure.&#x20;

### Privacy Policy&#x20;

Go to [Privacy Policy](https://www.dataflake.co/privacy-policy) Page&#x20;

### Terms and Conditions

Go to [Terms and Conditions](https://www.dataflake.co/terms-and-conditions) Page