Allows you to define selection conditions for dimension rows.
Usage
filter_dimension(dq, name = NULL, ...)
# S3 method for class 'dimensional_query'
filter_dimension(dq, name = NULL, ...)
Arguments
- dq
A
dimensional_query
object.- name
A string, name of the dimension.
- ...
Conditions, defined in exactly the same way as in
dplyr::filter
.
Details
Conditions can be defined on any attribute of the dimension (not only on
attributes selected in the query for the dimension). The selection is made
based on the function dplyr::filter
. Conditions are defined in exactly the
same way as in that function.
See also
Other query functions:
dimensional_query()
,
run_query()
,
select_dimension()
,
select_fact()
Examples
dq <- dimensional_query(ms_mrs) |>
filter_dimension(name = "when", when_happened_week <= "03") |>
filter_dimension(name = "where", city == "Boston")