blob: ea2c7de3a20e457a6099725367f86c7b75802091 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
# This file show how the groups can be used in filters.
#
# We search for the greatest value of units sold in France. In order to get the
# expected result, we need to filter first the country in France before
# looking for the greatest value.
dataset = "dataset.toml"
[source]
name = "source"
[sheet]
columns = [
":A",
":C",
":D",
":N",
]
filters = [
":C = 'France'",
":A = max(:A, [:D], [:F])",
]
|
