We will add a bar chart to our report to display information about the movies rented. Then we will configure the type of chart we want to visualize, its data source, and other characteristics. We will create a chart to display an analysis of the total number of movies rented by rating.
Chart ()
object to the Report Header section under the pie chart.
rating
(the item to be represented by the bars)[sum_amount]
(the value under analysis)[rating]
If we do not specify the series-by-field value, the chart will show us all the bars in the same color and by default place them in Series 1
. By establishing the rating
value, we make each column independent from the others, and as such, each will have a different color.
Total rental by Rating
True
FreeSans-BOLD-14
45.0
FreeSans-PLAIN-10
FreeSans-PLAIN-10
$
False
We added a Chart
object to the Report Header section. Then we edited this object, making it a bar chart and configuring its data source to analyze the total number of films rented by rating. We configured the chart's title, gave the chart a 3D effect, changed the characteristics of the source of the labels that display information about each bar, rotated the x axis labels by 45 degrees, changed the source of the y axis labels, made the y axis values begin with the dollar sign, and hid the chart's legend.
Just like any other object, the behavior of a chart depends on the section of the report where it is added.
If we place a chart in a Header section (Report Header, Details Header, and so on) or a Footer section (Report Footer, Details Footer, and so on), the chart will be shown each time these sections are shown in the report. Usually they are shown once per page. In this case, Chart
will have access to all the rows in the data set.
On the other hand, if we place a chart in the Details section, the chart will be shown once for each row in the section. Usually they are shown many times per page. In this case, the chart will only have access to the data of the row under analysis.
Now we propose that you modify the report you have already made and add a ring chart to show the information from another perspective. A ring chart will be displayed for each new element in the group, in this case for each new country. The report should look like this:
The steps you should follow, broadly speaking, are as follows:
Q1. Which of the following statements are true?