Format a measurement_summary object into a visual table
Source:R/tableMeasurementValueAsNumeric.R
tableMeasurementValueAsNumber.RdFormat a measurement_summary object into a visual table
Arguments
- result
A summarised_result object.
- header
Columns to use as header. See options with `visOmopResults::tableColumns(result)`.
- groupColumn
Columns to group by. See options with `visOmopResults::tableColumns(result)`.
- settingsColumn
Columns from settings to include in results. See options with `visOmopResults::settingsColumns(result)`.
- hide
Columns to hide from the visualisation. See options with `visOmopResults::tableColumns(result)`.
- style
Named list that specifies how to style the different parts of the table generated. It can either be a pre-defined style ("default" or "darwin" - the latter just for gt and flextable), or NULL which converts to "default" style, or custom code.
- type
Type of table. Check supported types with `visOmopResults::tableType()`. If NULL 'gt' type will be used.
- .options
A named list with additional formatting options. `visOmopResults::tableOptions()` shows allowed arguments and their default values.
Examples
# \donttest{
library(MeasurementDiagnostics)
cdm <- mockMeasurementDiagnostics()
result <- summariseMeasurementUse(
cdm = cdm,
codes = list("test_codelist" = c(3001467L, 45875977L))
)
#> → Sampling measurement table to 20000 subjects
#> → Getting measurement records based on 2 concepts.
#> → Subsetting records to the subjects and timing of interest.
#> → Getting time between records per person.
#> Summarising timings
#> ℹ The following estimates will be computed:
#> • time: min, q25, median, q75, max, density
#> ! Table is collected to memory as not all requested estimates are supported on
#> the database side
#> → Start summary of data, at 2026-01-15 11:42:06.631599
#> ✔ Summary finished, at 2026-01-15 11:42:06.741947
#> → Getting measurements per subject.
#> Summarising subjects
#> ℹ The following estimates will be computed:
#> • measurements_per_subject: min, q25, median, q75, max, density
#> ! Table is collected to memory as not all requested estimates are supported on
#> the database side
#> → Start summary of data, at 2026-01-15 11:42:07.220844
#> ✔ Summary finished, at 2026-01-15 11:42:07.323797
#> → Summarising results - value as number.
#> Summarising value as number
#> ℹ The following estimates will be computed:
#> • value_as_number: min, q01, q05, q25, median, q75, q95, q99, max,
#> count_missing, percentage_missing, density
#> ! Table is collected to memory as not all requested estimates are supported on
#> the database side
#> → Start summary of data, at 2026-01-15 11:42:08.473862
#> ✔ Summary finished, at 2026-01-15 11:42:08.753075
#> → Summarising results - value as concept.
#> Summarising value as number
#> ℹ The following estimates will be computed:
#> • value_as_concept_id: count, percentage
#> → Start summary of data, at 2026-01-15 11:42:09.365153
#> ✔ Summary finished, at 2026-01-15 11:42:09.528592
#> → Binding all diagnostic results.
tableMeasurementValueAsNumber(result)
test_codelist
CDMConnector::cdmDisconnect(cdm = cdm)
# }