|
Combinations
Returns how many distinct combinations of breakdown column values there are below each node in the hierarchy.
Given this data table:
|
Region |
Country |
1 Day Change % (USD) |
Mcap Rank |
1 Month Change % (USD) |
|
Europe |
AT |
-7.4% |
32 |
71.31% |
|
Europe |
AT |
-6.56% |
68 |
51.07% |
|
Europe |
AT |
-2.78% |
66 |
-17.28% |
|
Asia Pacific |
AU |
-0.72% |
57 |
22.35% |
|
Asia Pacific |
AU |
3.28% |
72 |
13.99% |
|
Europe |
BE |
-4.94% |
45 |
49.33% |
|
Europe |
BE |
-9.23% |
48 |
78.89% |
|
Europe |
BE |
4.19% |
28 |
22.68% |
|
Europe |
BE |
-2.63% |
51 |
22.60% |
|
North America |
CA |
-5.19% |
25 |
13.82 |
|
North America |
CA |
12.19% |
41 |
19.11% |
|
North America |
CA |
1.20% |
16 |
17.14% |
Sample 1
Below is the defined breakdown in a Table visualization:
Adding 1 Day Change % (USD) column to the Records variable will produce the following table with the aggregate set to Sum (default):
|
|
1 Day Change % (USD) |
|
|
Asia Pacific |
AU |
0.03 |
|
Europe |
AT |
-0.17 |
|
BE |
-0.13 |
|
|
North America |
CA |
0.08 |
Changing the aggregate of 1 Day Change % (USD) to Count will display how many instance of 1 Day Change % (USD) (rows from the data table) there are in each country:
|
|
1 Day Change % (USD) |
|
|
Asia Pacific |
AU |
2 |
|
Europe |
AT |
3 |
|
BE |
4 |
|
|
North America |
CA |
3 |
Adding Mcap Rank to the Records variable will result to the following table with the aggregate set to Sum (default):
|
|
1 Day Change % (USD) |
Mcap Rank |
|
|
Asia Pacific |
AU |
2 |
129 |
|
Europe |
AT |
3 |
166 |
|
BE |
4 |
172 |
|
|
North America |
CA |
3 |
82 |
Changing the aggregate of Mcap Rank to Combinations will display how many countries (rows in fully expanded visual table) there are.
|
|
1 Day Change % (USD) |
Mcap Rank |
|
|
Asia Pacific |
AU |
2 |
1 |
|
Europe |
AT |
3 |
1 |
|
BE |
4 |
1 |
|
|
North America |
CA |
3 |
1 |
Changing the visible depth in the breakdown to Region should show:
|
|
1 Day Change % (USD) |
Mcap Rank |
|
Asia Pacific |
2 |
1 |
|
Europe |
7 |
2 |
|
North America |
3 |
1 |
Asia Pacific has 1 (AU), Europe has 2 (AT and BE), and North America has 1 (CA).