Radar Chart In Oracle APEX
In this video, we will create a Radar Chart. Radar chart, also known as a spider chart, web chart, or polar chart, is a graphical method of displaying multi-variate data. It is a two-dimensional chart that consists of multiple variables, typically three or more, represented on axes radiating from a central point. The length of each spoke represents the magnitude of the variable for that data point. The data points are then connected to form a polygon, which helps to visualize the relationships between the different variables. Radar Charts are easy to create and understand. They are used to display a large amount of data in a relatively small space.
This Radar chart is displaying the quantity of apples, bananas, cantaloupe, dates, and grapes, sold at three different stores: Store A, Acme Store, and Shop C.
Series SQL Query
=============================================
select a.product_name, b.quantity, b.customer
from eba_demo_chart_products a, eba_demo_chart_orders b
where a.product_id = b.product_id
and customer = 'Store A'
