Create Dashboard in Oracle APEX

Step1: Open application




Step2: Open Home page


Step3: Inside body create one region



Step4: Select Chart as type



Step5: Select type in attribute


. Bar Chart

  • Displays data using horizontal or vertical bars.
  • Best for comparing values across categories.
  • Example: Students in each department.

2. Area Chart

  • Similar to a line chart, but the area below the line is filled.
  • Shows trends over time and emphasizes volume.
  • Example: Monthly attendance count.

3. Box Plot

  • Displays statistical distribution of data.
  • Shows minimum, maximum, median, and quartiles.
  • Example: Salary distribution of employees.

4. Bubble Chart

  • Similar to a scatter chart but includes a third value represented by bubble size.
  • Useful for comparing three dimensions of data.
  • Example: Students (X=Marks, Y=Attendance, Bubble Size=Projects).

5. Combination Chart

  • Combines multiple chart types (e.g., Bar + Line).
  • Useful when comparing different metrics.
  • Example: Student Count (Bar) and Average Marks (Line).

6. Status Meter Gauge

  • Displays progress toward a target value.
  • Example: Course completion percentage.

7. Donut Chart

  • A Pie Chart with a hole in the center.
  • Shows part-to-whole relationships.
  • Example: Male vs Female Students.

8. Funnel Chart

  • Displays stages in a process.
  • Values decrease through stages.
  • Example: Admissions Process (Applied → Selected → Enrolled).

9. Gantt Chart

  • Displays tasks along a timeline.
  • Used for project scheduling.
  • Example: Academic Event Planning Schedule.

10. Line Chart

  • Connects data points with lines.
  • Best for showing trends over time.
  • Example: Monthly Student Registrations.

11. Line with Area Chart

  • Combination of Line and Area chart.
  • Highlights trends and total volume.
  • Example: Daily Attendance Trend.

12. Pie Chart

  • Circular chart divided into slices.
  • Shows percentage contribution of categories.
  • Example: Students by Course.

13. Polar Chart

  • Displays data in a circular coordinate system.
  • Useful for cyclical patterns.
  • Example: Monthly Performance Analysis.

14. Pyramid Chart

  • Similar to a funnel but pyramid-shaped.
  • Shows hierarchical or proportional data.
  • Example: Student Levels (Beginner → Intermediate → Advanced).

15. Radar Chart

  • Displays multiple variables on axes from a central point.
  • Useful for performance comparisons.
  • Example: Student Skills Assessment.

16. Range Chart

  • Shows minimum and maximum values within a range.
  • Example: Temperature range across days.

17. Scatter Chart

  • Displays relationships between two numeric variables.
  • Example: Marks vs Attendance.

18. Stock Chart

  • Specialized chart for financial data.
  • Displays Open, High, Low, Close values.
  • Example: Stock Market Analysis.

 

Step6:Apply Query





Step7: Map column in column mapping


Option

Meaning

Series Name

Creates multiple series/groups

Label

X-axis category/label

Value

Numeric value plotted

Z

Bubble size (Bubble Chart)

Custom Tooltip

Tooltip for chart points

Legend Tooltip

Tooltip for legend items

Label Tooltip

Tooltip for labels

Custom Column

Extra hidden data for advanced use

Step8: Click on run


Step9: Check on UI



 

Comments

Popular posts from this blog

Implementing Authentication and Authorization in Oracle APEX

Mastering Shared Components in Oracle APEX

Designing a Scalable Database Architecture for Oracle APEX Applications