Donut & Range Charts | Minimum & Maximum Quantities | with Legends Oracle APEX - Part 26
Summary
TLDRIn this Tech mining video, viewers are introduced to the visualization of sales data through interactive charting options. The presentation includes a donut chart that highlights sales figures upon hovering and allows for data series hiding through legend item selection. Additionally, a range chart is featured, which displays ordered quantities and links to a detailed product page. The tutorial guides through the setup of these charts, emphasizing their dynamic nature and the ability to drill down into specific product details, ultimately enhancing user engagement with the data.
Takeaways
- 📊 The video presents a tutorial on creating donut and range charts to display sales data for different products in two separate regions.
- 🖱️ Viewers can interact with the charts by hovering the mouse cursor to see sales figures and clicking on legend items to hide or show data series.
- 🔗 The second chart, a range chart, includes a link to access a detailed product page (Page 6) when a specific product bar is clicked.
- 🛠️ The video guides viewers through creating a segment with a step-by-step approach, similar to previous tutorials.
- 💰 The donut chart highlights sales figures in US dollars when a data item is hovered over.
- 📈 The range chart displays the maximum and minimum ordered quantities for each product, helping to visualize sales ranges.
- 🔑 The tutorial explains how to set up the chart properties, including defining labels for the x-axis and specifying low and high column names.
- 📝 Source code for creating the charts is provided in the video description, allowing viewers to replicate the process.
- 📚 The video script mentions a 'part 8 folder' which contains the file necessary for creating the charts, indicating a series of tutorials.
- 🔍 The charts are designed to allow for easy comparison of sales data across different categories and products.
- 📘 The final takeaway is the ability to drill down into product details by interacting with the charts, enhancing data exploration and analysis.
Q & A
What is the main focus of the Tech mining video?
-The main focus of the Tech mining video is to present category and product sales data in two separate regions using different charting options.
What is a donut chart and how does it work in the video?
-A donut chart is a type of circular chart that is used to display data in a way that allows for easy comparison. In the video, moving the mouse cursor over each segment of the donut chart displays the respective sales figures, and deselecting a legend item hides its associated data series.
How can viewers interact with the range chart in the video?
-Viewers can interact with the range chart by moving the mouse cursor over the chart to see the respective sales figures. The chart also has a drill-down feature where clicking on a bar representing a product will take the viewer to Page 6 to view product details.
What is the purpose of the 'on Hover' feature in the donut chart?
-The 'on Hover' feature in the donut chart allows all data items to be dimmed when not currently hovered over, and highlights only the current data item with its respective order figures in US dollars.
How does the 'hide and show' behavior work in the donut chart?
-The 'hide and show' behavior is performed by clicking a legend item, which causes the chart to rescale as you select or deselect a legend item. This is useful for series with largely varying values.
What is the source code for the charts mentioned in the video?
-The source code for the charts is provided in the video description, accessible by opening the part 8 folder, which contains the file used for the charts.
What is the second chart in the video used for?
-The second chart is a range chart used to display the maximum and minimum ordered quantities for each product.
How are the labels of the x-axis on the range chart defined?
-The labels of the x-axis on the range chart are defined using the product name column specified in the chart settings.
What is the purpose of the link created in the last six properties of the range chart?
-The link created in the last six properties of the range chart is used to access Page 6 to browse details of the selected product when a bar on the chart is clicked.
How can viewers access the page with the charts?
-Viewers can access the page with the charts by running the application, opening the reports page, and clicking on the 'Sales by Category and Product' card.
What happens when a viewer clicks on a bar representing a product in the range chart?
-When a viewer clicks on a bar representing a product in the range chart, the system will drill down to Page 6 to show the details of that specific product.
Outlines
📊 Interactive Data Visualization with Donut and Range Charts
This paragraph introduces a video on Tech mining, focusing on presenting sales data for different product categories in two distinct regions using interactive charting options. The video showcases a donut chart that allows viewers to hover over segments to see specific sales figures in US dollars. Deselecting items in the legend hides the corresponding data series, and clicking a legend item rescales the chart, which is beneficial for comparing series with significantly different values. Additionally, a link to page 6 is created for detailed product information, demonstrated by clicking on a bar representing 'Jr Phantom Vision', which drills down to page 6. The source code for these visualizations is available in the video description, and the process of creating these charts is outlined in a step-by-step approach.
🔍 Accessing Detailed Sales Data and Product Information
The second paragraph guides viewers on how to access the interactive sales data page within the application. It explains that by navigating to the 'Sales by Category and Product' card on the reports page, users can view two charts displaying graphical data for category and product sales. Hovering over the charts reveals sales figures, and deselecting items in the legend hides the associated data series. The paragraph also highlights the drill-down feature, where clicking on a specific product bar, such as 'Jr Phantom Vision', leads to page 6 for an in-depth look at the product details. The video concludes with a thank you note to the viewers.
Mindmap
Keywords
💡Tech mining
💡Donut chart
💡Sales figures
💡Legend item
💡Range chart
💡Drill down
💡Page 6
💡Source code
💡X-axis labels
💡Low and high column names
💡Sales by category and product
Highlights
Introduction to Tech mining video presenting sales data with charting options.
Demonstration of a donut chart with interactive mouse-over feature to display sales figures.
Explanation of how to deselect legend items to hide or show associated data series on the chart.
Introduction of a range chart for specifying low and high values with column names.
Link creation to access page 6 for detailed product information from the range chart.
Drill-down feature to page 6 from clicking on a bar representing a product.
Guidance on creating a segment with the same approach as previous videos.
Description of the 'dim on hover' feature for highlighting current data item with sales figures.
Explanation of the hide and show behavior when clicking legend items for rescaling the chart.
Availability of source code in the video description for further exploration.
Instruction on how to create a range chart with maximum and minimum ordered quantities.
Selection of product name column for defining labels on the x-axis of the chart.
Link creation to access page 6 for browsing details of the selected product from the chart.
Demonstration of the final page with two regions containing graphical data for sales.
Interactive feature allowing users to see sales figures by moving the mouse cursor over charts.
Instruction on how to access the created page and view the charts with sales data.
Final note thanking viewers for watching the Tech mining video.
Transcripts
a very warm welcome to Tech mining
in this video we'll present category and
products sales data in two separate
regions using different charting options
this is a donut chart move the mouse
cursor over each chart and see
respective sales figures
deselecting a legend item will hide its
Associated data series on the chart this
hide and show behavior is performed when
you click this Legend item
[Music]
this second chart is a range chart which
specify low and high column names to be
used for defining the low and high
values on this chart here we also create
a link to access page 6 to browse
details of the selected product click
this bar representing Jr Phantom Vision
the system will drill you down to Page 6
to show the details of this product
[Music]
let's create this segment
go through same approach as we did in
previous videos to create a blank page
[Music]
foreign
[Music]
thank you
[Music]
this first region will display the donut
chart
[Music]
for this dim on Hover by selecting yes
dims all data items when not currently
hovered over and highlights only the
current data item hovered over with
respective order figures in US dollars
[Music]
this hide and show behavior is performed
when you click a legend item the chart
rescales as you select or deselect a
legend this is useful for series with
largely varying values
foreign
[Music]
source code is provided in description
of this video by opening part 8 folder
you will get the file used
[Music]
foreign
[Music]
this second region will carry a range
chart which will display maximum and
minimum ordered quantities for each
product
[Music]
thank you
[Music]
foreign
[Music]
we select this product name column which
will be used for defining the labels of
the x-axis on the chart
here we specify low and high column
names to be used for defining the low
and high values on this chart
in these last six properties we are
creating a link to access page 6 to
browse details of the selected product
foreign
[Music]
by clicking the save page button
to access this page
run the application
open this reports page click this sales
by category and product card
you will see the two charts as shown in
start of this video the page has two
regions containing graphical data for
category and product sales move the
mouse cursor over each chart and see
respective sales figures
deselecting a legend item will hide its
Associated data series on the chart
[Music]
foreign
chart click this bar representing Jr
Phantom Vision the system will drill you
down to Page 6 to show the details of
this product
[Music]
thanks for watching
[Music]
関連動画をさらに表示
Oracle APEX Chart | Stack Unstack | Horizontal Vertical Orientation - Part 25
Faceted Search In Oracle APEX - Part 37
Line With Area & Bar Charts with Region Display Selector Oracle APEX - Part 27
Single + Multiple Series Box Plot Charts Oracle APEX - Part 31
Pyramid Chart | Oracle APEX - Part 32
Interactive Report & Form Page Oracle APEX - Part 7
5.0 / 5 (0 votes)