1. Home
  2. Docs
  3. Reportql
  4. Create Report
  5. Dashboard
  6. Dashboard Components

Dashboard Components

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

Server Table

  • Description: 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.
  • Working Location: Server-side.
  • Example Usage: Used to present a company’s sales data from a central server in table format. Provides fast access to large datasets using SQL queries.

    SELECT * FROM sales_data WHERE year = 2023

Client Table

  • Description: Displays data stored on the client-side in table format. Typically used for small and local datasets.
  • Working Location: Client-side.
  • Example Usage: Used to present a small business’s daily stock data from local storage in table format.

    SELECT * FROM local_stock_data

Pivot Table

  • Description: Presents data in pivot table format. This component facilitates dynamic grouping, summarization, and analysis of data.
  • Working Location: Client-side.
  • Example Usage: Used to analyze monthly sales figures by product category for a sales department.

    SELECT product_category, SUM(sales_amount) FROM sales_data GROUP BY product_category

Content Box

  • Description: Used to display free-form content such as text, images, or HTML content. Ideal for providing information or explanations to the user.
  • Working Location: Client-side.
  • Example Usage: Used to display text or images explaining the purpose of the report on a dashboard.

    <div>

    <h2>Sales Report</h2>

     <p>This report shows the sales data for the year 2023.</p>

     </div>

Pie Chart

  • Description: Visualizes data in the form of a pie chart. It displays the proportions of data slices visually.
  • Working Location: Client-side.
  • Example Usage: Used to show the proportions of total sales from different product categories.

    SELECT product_category, SUM(sales_amount) 

FROM sales_data 

GROUP BY product_category

Donut Chart

  • Description: Similar to a pie chart but with a hole in the middle, showing data percentages.
  • Working Location: Client-side.
  • Example Usage: Used to show the proportions of total revenue from different customer segments.

    SELECT customer_segment, SUM(revenue) 

FROM revenue_data 

GROUP BY customer_segment

Polar Area Chart

  • Description: Displays data in a polar coordinate system in area chart format. Used to visually compare different data groups.
  • Working Location: Client-side.
  • Example Usage: Used to compare the annual performance of different departments.

    SELECT department, performance_score 

FROM performance_data

Line Chart

  • Description: Displays data in the form of a line chart. Used for visualizing time series or continuous data.
  • Working Location: Client-side.
  • Example Usage: Used to show the annual revenue changes of a company.

    SELECT month, revenue 

FROM monthly_revenue 

WHERE year = 2023

Vertical Bar Chart

  • Description: Visualizes data as vertical bars. Used to compare data across different categories.
  • Working Location: Client-side.
  • Example Usage: Used to compare the sales performance of different departments.

    SELECT department, sales 

FROM department_sales

Horizontal Bar Chart

  • Description: Visualizes data as horizontal bars. It is the horizontal version of the vertical bar chart and is used for comparing categories.
  • Working Location: Client-side.
  • Example Usage: Used to show the stock levels of different products.

    SELECT product_name, stock_level 

FROM product_inventory

Reportql Parameter Usage Guide

Reportql simplifies data visualization for users by allowing the use of various parameters. Below is a guide explaining the usage of different parameter types and their integration with dashboard elements.

Static Content

  • Description: Used to display specific text, images, or fixed information. Ideal for providing static information on the dashboard.
  • Example Usage: Dashboard title, description text, or fixed graphic.

    SELECT ‘Report Title’ AS Title, ‘This dashboard displays a specific data set.’ AS Description

Text

  • Description: Allows users to input free text. Ideal for fields like username, description, or comments.
  • Example Usage: Username filter or comment field.

    WHERE user_name = @userName

Integer

  • Description: Allows users to input integer values. Used for numerical data like age, quantity, or ranking values.
  • Example Usage: Age filter or product quantity.

    WHERE age = @userAge

Date

  • Description: Allows users to select dates. Facilitates data entry in date format.
  • Example Usage: Filtering data between start and end dates.

    WHERE transaction_date BETWEEN @startDate AND @endDate

Checkbox

  • Description: Allows users to confirm an option. Used for binary choices like true/false or yes/no.
  • Example Usage: Filtering for active/inactive users.

    WHERE is_active = @isActive

Static Dropdown

  • Description: Allows users to select from predefined options. The list is fixed and cannot be changed.
  • Example Usage: Selection of gender, country, city.

    WHERE country = @country

Query Dropdown

  • Description: Allows users to select from options dynamically pulled from a data source.
  • Example Usage: Product list, customer list.

    SELECT product_name FROM products WHERE category = @category

Static User

  • Description: Allows users to select other users registered in the system. Typically used for task assignment or responsibility designation.
  • Example Usage: Selecting a project manager.

    WHERE assigned_to = @userId

Autocomplete

  • Description: Provides auto-completion suggestions from predefined options as users enter text.
  • Example Usage: Tags, product names, customer names.

    SELECT customer_name FROM customers WHERE customer_name LIKE ‘%’ + @autoparam + ‘%’

Dashboard Parameter Settings

These parameters are configured to affect dashboard elements. For example, selecting a date range can limit data visualization to a specific time period.

With this guide, you can optimize your data visualization processes and create user-friendly dashboards using Reportql.

How can we help?