Dashboard Components

Dashboard components are the building blocks that display your data in an accessible and interactive manner. Common components include:

Data Tables

Grid Serverside

Displays data stored on the server in table format. This component pulls data from large databases or server-based data sources and presents it to the user. This component works server side. This means that for all the operations you do (such as paging, filtering, sorting), it automatically prepares the relevant queries and runs them on the server and returns the results. For this reason, it is suitable for big data.

• Features: Paging, Sorting, Filtering, Column Chooser, Excel Export

• Allow Define Reports: If enabled, users can create their own reports using this datatable.

This component does not support complex queries (cursor, union etc).

Grid Clientside

Displays data stored on the client-side in table format. Typically used for small and local datasets. This component works client side. This means that it pulls all the data from the query result to the client side and performs the subsequent operations (such as filtering, sorting) through the client. This component can be used for more complex queries (cursor, union etc.)

• Features: Paging, Sorting, Filtering, Column Chooser, Grouping, Chart, Excel Export

• Chart: If it's enabled, users can create charts with this component.

Pivot Table

Presents data in pivot table format. This component facilitates dynamic grouping, summarization, and analysis of data.

• Working Location: Client-side

Content Box

Used to display free-form content such as text, images, or HTML content. Ideal for providing information or explanations to the user.

Charts

You need to run the query once to fill the following fields in all chart components.

Pie Chart

Visualizes data in the form of a pie chart. It displays the proportions of data slices visually.

Donut Chart

Similar to a pie chart but with a hole in the middle, showing data percentages.

Polar Area Chart

Displays data in a polar coordinate system in area chart format. Used to visually compare different data groups.

Line Chart

Displays data in the form of a line chart. Used for visualizing time series or continuous data.

Vertical Bar Chart

Visualizes data as vertical bars. Used to compare data across different categories.

Horizontal Bar Chart

Visualizes data as horizontal bars. It is the horizontal version of the vertical bar chart and is used for comparing categories.