Charts

In the configure chart section present in visualise page, you can just change the visualisation formats among well known forms. 

Currently available forms are as follows:

1. Table Chart

How to create a table chart?

In the configure Chart section, just click on table and then click on run query. This way, a table will appear on the visualise area.

2. Bar graph

How to create Bar Chart?

Bar chart can also be created by just clicking over bar graph icon available in configure chart section. Follow these steps to create bar chart:

• Click on bar chart icon, a drop down menu will come up

• In the drop down menu, set the columns you want to appear on x-axis and y-axis.

• Additionally, you can also choose over stacking options and column name appearance.

• Thereafter, click on run query to visualise data.

2. Pie chart

How to create Pie Chart?

Pie chart is usually created when a centre measure attributing to a specific column is required. Pie chart can be created by choosing pie chart among configure chart options. You just need to choose the central measure column and click on run query.

3. Line graph

How to create Line Chart?

Creating a line chart is very simple. Follow the steps listed below

• Select Line chart from configure chart menu, a drop down menu will appear.

• Select x-axis and y-axis columns.

• Click on run query to visualise data.

4. Big Number

How to create Big Number Chart?

In order to create big number chart, just click on big number icon and then choose the column whose number you want to visualise. Thereafter, click on run query to visualise data.

5. Pivot Table

How to create Pivot Table Chart?

• After adding the filter, summarise by, and columns/fields choices that the user desires to add to the data setup section of query builder, the option to select the pivot table chart from the configure chart section becomes available. The user will be able to select the chart, which in this case is a pivot table. 

• When the user picks the pivot table, rows and columns will appear. The pivot table must include at least one row (or column) field and one value field. In the rows and columns area, users must select the dimensions on which they wish to aggregate their data. The values field shall always contain an aggregation. After adding the columns and values, finally the pivot table gets created.