Shulou(Shulou.com)06/03 Report--

In our daily report analysis process, we always encounter a variety of problems, such as how to solve complex report problems, we have learned to use multi-granularity expressions. So how to show the data we want according to the business indicators in the report analysis? Here we need to filter the data. Today we will introduce the functions and usage scenarios of the Yonghong BI filtering component.

1. Scene and analysis

The following scenes are pure fiction, and coincidences are identical.

Manager Wang, the head of the market data department of a brand in eastern China, the brand's monthly sales report-[figure 1], shows the details of the national sales performance through bar charts and tables. The table contains hundreds of rows of data. If Manager Wang wants to know the monthly performance of the provinces in the eastern market he is responsible for, two problems will be exposed when looking at the sales performance report:

The data of the bar chart is a summary of the data of all provinces on a monthly basis, so it is impossible to see the data trend of the eastern market, let alone the data trend of the provinces of the eastern market.

The table data contains the performance data of each month and each region in the past, and it is also very troublesome to find the data of the area you are responsible for through mouse scrolling and naked eyes.

Figure 1

2. Combined with the practical application of Yonghong BI

In order to solve the above two problems, the business staff of the data department filtered the data through the screening component in Yonghong BI, and Manager Wang was able to quickly analyze the performance of the provinces in the eastern market according to the business indicators, and then locate the reasons for the provinces that did not meet the standards and give some business guidance, and encourage the provinces to meet the standards and rank among the top provinces in the form of awards, so as to promote more and more high-performance orders.

The final filterable report of the data department-- see [figure 2]

Figure 2

Add two parameter components of market distribution and province, and add a filter to filter out the data of specific provinces in the eastern market, which can solve the above problems 1-to directly see the performance data trend of a province.

Add a filter to the table to filter out all the monthly data of the eastern market, and the above problem 2 can be solved.

3. Introduction of Yonghong BI filtering components

Yonghong BI filtering component includes [filter component] and [parameter component].

[filter component] A component that allows you to select data items and filter data automatically is called a filter component.

Such components include list filtering components, tree filtering components, date filtering components, and range filtering components. When the options on the filter component are modified, all output components (such as charts, tables, text, and meters) that have the same data source as the component automatically filter out the data. This kind of behavior is called data linkage.

[parameter component] Parameter component is an input object, and its function is to assign values to parameters and filter data.

Parameter components include text parameter components, drop-down parameter components, and list parameter components. The name attribute of the parameter component is critical and represents a parameter name. For example, a parameter component is named an and the input is BeiJing. It is equivalent to defining a parameter of a=BeiJing. The parameter a can be used when filtering conditions are added to output components, such as charts, tables, crosstab, text, and instruments.

For example, add a filter condition "city=? {a}" to the city field, indicating that the data city=BeiJing is filtered out. As the user enters different values, different results are filtered.

[similarities and differences in functions]

Differences:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.