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.