Dynamic Indicator Switching Through Parameters

Version

Expected Effect

You can dynamically switch the summary indicators of columns and perform flexible queries as needed. And you can switch to view four indicators in the same dimension.

For example, you can switch the data of Browse_Volume, Access_Times, Bounce_Times, and Total_Stay_Time indicators in the Access_Platform dimension through the text drop-down component, as shown in the following figure.

Implementation Method

You can achieve the effect of dynamic column switching by using filter components, dynamic parameters, and the SWITCH function.

Data Preparation

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

2. Click Local Excel and click Upload Data, as shown in the following figure.

You can download the sample data: Internet_Access_Statistics.xlsx.

3. Click OK after the data is uploaded.

4. Click Save and Update to finish creating data.

Creating a Component

Click Component in the lower left corner to go to the component editing page.

Adding a Dynamic Parameter

1. Click the Add Parameter button.

2. Set Parameter Name to Indicator Switching, set Parameter Type to Text, and click OK.

Adding a Calculation Indicator

1 Click the Add Calculation Indicator button.

2. Set Field Name to Indicator Switching and use the SWITCH function to match the text parameter with the summary indicators.

SWITCH(${Indicator Switching},"Access_Times",SUM_AGG(${Access_Times}),"Browse_Volume",SUM_AGG(${Browse_Volume}),"Bounce_Times",SUM_AGG(${Bounce_Times}),"Total_Stay_Time",SUM_AGG(${Total_Stay_Time}),SUM_AGG(${Access_Times}))

If the value of the indicator switching function is Access_Times, return the sum of access times. If the value of the indicator switching function is Browse_Volume, return the sum of the browse value. If the value of the indicator switching function is Bounce_Times, return the sum of the bounce times. If the value of the indicator switching function is Total_Stay_Time, return the sum of the total stay time.

Making a Column Chart

1. Select Multi-Series Column Chart in Chart Type.

2. Set chart fields: Drag Access_Platform to Horizontal Axis and Indicator Switching to Vertical axis.

3. Set the chart style: Drag Access_Platform to Color, and drag Indicator Switching to Label.

Creating a Dashboard

1. Click the Add Dashboard button at the bottom of the analysis subject editing page.

2. Drag the column chart component to the dashboard on the dashboard editing page.

Adding a Text Filter Component

1. Click Filter Component and add Text Drop-down Filter Component to the dashboard.

2. On the filter component setting page, set Filter Method to Single.

3. On the filter component setting page, select Custom Value List, and the custom value list contains Access_Times, Browse_Volume, Bounce_Times, and Total_Stay_Time.

4. On the filter component setting page, select Bind Parameter, and bind the parameter Indicator Switching created in section "Adding a Dynamic Parameter."

Effect Display

You can switch the indicators of the column chart component by switching the value in the text drop-down list, as shown in the following figure.