Show or hide variables

TODO (copied stuff en vrac)

Visibility status

In OutbreakTools, there are several visibility status, which can be modified using a button in the OutbreakTools Menu:

  • mandatory: the columns cannot be hidden using the Show/Hide
  • hiden: the columns are internal and cannot be shows using the Show/Hide
  • optional: the linelist user can decide to show or hide the variable based on their needs.

These linelist status correspond to the setup file status property, with the subtility that the setup user can decide for optional columns to show them by default (optional, visible) or hide them by default (optional, hidden), based on the expected frequency of use of the variable.

Show and hide variables

Clicking on the “Show/hide variables” button opens a window listing all the variables in the current sheet.

OutbreakTools tab in the created linelist

The optional, hidden variables in the setup file appear as Hidden by default. However, the user can change the status by choosing Show, in which case the column will become visible.

The “Notification year” variable does not appear in the list of variables because it is in “hidden” status in the setup file.

The optional, visible variables in the setup file appear as Shown by default. However, you can change the status by choosing Hide, in which case the column will no longer be visible.

Mandatory variables in the setup file appear as *Mandatory in the “Show/Hide” pop up, and cannot be hidden.

Technically, the linelist user can forcefully hide/un-hide columns.

Un-hiding hidden (usually calculated) columns is usually desirable during linelist debug or to go check data that may interest you (e.g. a hidden calculated epiweek of exit). You can hide them after consultation without consequences on the rest of the linelist.

It is however more dangerous to forcefully hide “mandatory” columns. These columns are often fundamental variables in the linelist, that are needed for data understanding and analyses (e.g. date of admission, age or sex). If you choose to hide one of these columns, know that some analyses might not function as expected, or not at all because they rely on the hidden columns.

Finally, any change of column visibility that is not made via the “Hide/show variable” button of the linelist will not be recorded and migrated to a new linelist.

Back to top