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.