How to summarize the scores of multiple judges

1. Scenario

When judges score, there are often multiple judges to score and then summarize and display them. So how can we summarize and display the scoring data of multiple judges according to the participating teams?

2. Implementation steps

2.1 Design form

Team Information Table: form page, summarizing the team and team information participating in the competition

Judge score table: The form page is used for judges to score the participating teams respectively. The participating teams in the Judge score table are drop-down radio components and are associated with the participating teams in the participating team information table for judges to choose

Judge score summary table: on the report page, use the table component to display the Judge score table data

2.2 Data Linkage configuration

The participating teams in the judge scoring table are drop-down radio components, which must be associated with the participating teams in the team information table for the judges to select.

2.3 report table configuration

Drag the table component and select data setJudge Score sheet 」, and select the scoring item and the team as the column field, as shown in the following figure:

Turn on the table component to merge cells so that the same columns are automatically merged, as shown in the following figure:

2.4 report filtering settings

The report displays all team Data. When you need to search for and display the scoring data of a team, you can configure a filter box to implement it.

2.5 calculate average score

Add a formula field and name it the average score. Move the average score column behind the team column and set the automatic merge rule.

UseAVG()The formula calculates the average score. The usage is as follows. Set the actual score, add column fields in the table other than the team to the formula[Exclude fields]. After calculating the average score, set the decimal point format.Usage:AVG(,[condition],[exclude field])Introduction:Returns the average result of under [conditions], and [exclude field] does not participate in the sum cross calculation;

3. Achieve results

-------------------- Get the latest information YIDA, welcome to follow US--------------------