Displaying Comments Dynamically Based on Content Obtained by Filter

Expected Effect

You need to automatically generate comments for the most critical data results, making the results more intuitive, as shown in the following figure.

If you select Philippines, the corresponding comment will be generated automatically, in which the top shop by sales in Philippines and the corresponding sales are displayed.

You can also display statistical measures such as the mean, maximum value, minimum value, and percentage distribution within a specified timeframe or range.

Implementation Method

You can use Custom Chart to realize the effect and select Text in Graphic Property.

Data Preparation

1. Log in to the system as the admin, click My Analysis, select a folder, and click New Subject, as shown in the following figure.

2. Choose Local Excel > Upload Data, and upload the table data, as shown in the following figure.

Sample data: Store Sales Data.xlsx

3. Click OK after the data is uploaded, as shown in the following figure.

Component Creation

1. Click Component in the lower left corner, as shown in the following figure. (The added component is also referred to as the comment component in the following part.)

2. Select Custom Chart in Chart Type and select Text in Graphic Property, as shown in the following figure.

3. Drag the Store Name and Sales fields into the Text bar, as shown in the following figure.

In this case, all shops and the corresponding sales are displayed, but what you want is the top shop by sales and its sales.

4. Filter the Sales field and obtain the top sales, as shown in the following figure.

5. Add descriptive text.

After filtering, only the top sales and the corresponding store are displayed. Edit the text, as shown in the following figure.

Enter the descriptive text and modify the colors of Shop Name and Sales to red, as shown in the following figure.

Dashboard Creation

You can filter the Country field by Filter Component. In this case, the top shop by sales and the corresponding sales within the selected country can be displayed in the comment component.

1. Create a dashboard and add the component to the dashboard, as shown in the following figure.

2. Enter the dashboard and add the Text Drop-Down filter component, as shown in the following figure.

3. Drag the Country field from the comment component to the filter component and bind the field to the filter component to associate the filter component with the comment component, as shown in the following figure.

Table Adding

In this example, the component with a table is not required and is only used as an auxiliary component to help verify generated comments.

Add a component and set a table, as shown in the following figure.

Effect Display

Hide the title of the comment component and select a country. The following figure shows the effect.