Customizing data tables

The Copernico table component enables the display of complex data, such as participants or teams. This component allows you to create custom display modes adapted to any situation.

In the Participants section you can customize the columns that are displayed. The columns that you have uploaded with the import of participants will be available.

1. How to customize the table

What can we customize in a table?

• Column display: columns, order and size.
• Filter the data.
• Sort the data.
• Group the data.
• Limit the data.

To do this:

1. Click the columns button on the right of the bottom bar. The Personalize table side panel opens with all the available fields.

2. Select the fields you want to see in the table. There is a field search box, a legend explaining the column prefixes and the fields grouped by type (times, attributes…). In the header of each group, the eye icon shows or hides all its fields and the arrow expands the group. Visible fields are highlighted in blue.

3. Sort the columns by drag & drop: Copernico displays a default column order that may not be the one you want. Select the column you want to move, drag it and drop it when it reaches the desired position.
4. Apply the filters you need: in Copernico there are two ways to apply filters, and which one you use depends on whether the field is visible in the table or not.
   • If the field is not visible because the column is hidden: click the filters icon next to the search box. In the Filters side panel, find the field (all fields are listed, visible or hidden), enter the value and apply the filter with the Filter button. The panel also has the Inverted and Search Empty check boxes and the Reset button.

• If the field is visible: place the cursor over the field (column) you want to filter, click the filter icon and select or enter the value you want to filter by.

While filters are active, the bottom bar shows “You are seeing a filtered result set!” and a red button to remove them appears at the top.

5. Sort the values: Copernico allows alphabetical and numerical sorting, ascending or descending. By clicking the arrow at the top of the column, you can set or change the sorting direction.

If you want to sort column values or hidden fields, or if you have more than one sorting criterion, use advanced sorting:

• Click the sorting icon next to the filters icon. The advanced sorting panel opens.
• In the panel, select the Column you want to sort and the sorting Direction (for example, Ascending), and click Apply.
• Add a sorting criterion with the + button: you can first follow one sorting order and, after that criterion, a different one. This can be useful when you make groupings and want to show some data before others. By dragging and dropping the criteria you can change their order. The one at the top takes precedence over the ones below. For example, you can sort first by category and then by position.

For both categories and trophies, the order is from top to bottom. So, in categories, you will have to select the display as a table if you want to change the order.

6. Group by different criteria to display more specific data. For example, group by category to create a specific preset that shows the position by category. With a double or triple grouping you can group by wave and category, to group the winners by category for each of the waves. Groupings are used depending on the needs of the race: groupings by team type or by category are usually common. To group, choose one or more fields in the Group by drop-down of the bottom bar of Participants or Teams. Only fields that can be grouped are listed, such as Team, Type of team, Gender, Category, Status, Event and the attributes.
7. Limit the rows: you can limit the number of athletes or teams to be displayed in the preset. If you set a limit of 10 rows, only 10 athletes or teams will be displayed. But if you have a grouping by categories, the limit applies to each of the categories, i.e. 10 rows will be displayed in each category and, if there are 10 categories, 100 athletes will be displayed. To limit, enter the limit in the Row limit field in the lower right corner of the Participants or Teams screen (shown with the value auto in the image). The same bottom bar also has the Auto-update option.

2. Column sections

In the Personalize table panel, the columns are divided into the following groups:

• All: all the columns. If you cannot find a column, you can expand this group or use the search box.
• Race: race data of the participant: Bib, Tag, Type of team, Category, Status, Number of consecutive missed timing points, Number of missed timing points, Number of seen timing points, Locations, Event and Penalties.
• Personal: personal data of the participant: Name, Surname, Full name, Club, Date of Birth, Team, Gender and Featured.
• Start time config: start time configuration.
• Start times.
• Net times.
• TOD times: passing times as time of day.
• Times.
• Split times: one column for each split of the race and its net version (N). They cannot be edited in the table: to change the time of a split, change the time of the timing points that make it up.
• Overall rankings: overall positions.
• Gender rankings: positions by gender.
• Category rankings: positions by category.
• Diff times: time differences.
• Averages.
• Rankings (attributes).
• Attributes (rankings).
• Commentator.
• Custom rankings. It only appears when the participants have custom ranking positions.

In Teams the groups are different: All, Team, Race, the overall ranking, Split times and Difference.

3. Custom columns

Click the </> icon in the right-hand menu to open the Manage custom columns panel. The panel lists your columns and those of other users in your company; use the icons of each column to edit or delete it, and ENABLE to enable it in the race. To create a column, click Create new column.

Here you can create custom columns in JavaScript. If you have any questions when creating columns, you can contact us for help.

When you click Create new column, a window opens with the Column name, the Field type, the code editor and the Live preview, which shows the value the column returns for a sample of participants. On the right, the Column assistant writes the code for you: describe the column you need (for example, “gap to the category leader”), click SEND and use APPLY CODE to move the code it returns to the editor. Check the preview and click Save to save the column.

There are sample columns (difference from the winner, time with milliseconds, full name, age): click one to add it to your table. Only the sample columns you have not created yet are offered.

You can also modify a column you have selected to match your needs.

More information in Custom columns.