Segmented Fields
Definition
If key field values in data aggregates contain lists of certain attributes, for example:
- Countiries visited by travellers
- User hobbies
- User spheres of interest
- User languages
- Offered services
- Business areas
Such attributes are presented as segmented fields in the u-Slicer User Interface. Each attribute maps to one segmented field.
Use Case
Assume you have several users with various hobbies (a, b, c, d). When a certain user sees an Impression, all his/her hobbies are recorded into the log as a comma separated list of attributes. All such records are aggregated as follows:
| Hobbies | Impressions |
|---|---|
| a, b, c, d | 1 |
| b, d | 2 |
| c | 3 |
| c, d | 4 |
| d | 5 |
| Total | 15 |
u-Slicer UI displays the number of Impressions for each particular hobby:
| Hobbies | Impressions |
|---|---|
| a | 1 |
| b | 3 |
| c | 8 |
| d | 12 |
| Total | 15 |
Note: In UI Total is not equal to the sum of Impressions in all rows, because each hobby may be included in several combinations of hobbies, and, therefore, real Impressions may be repeated.
You can split by any segmented fields or combinations theirof linked by the AND and/or OR operators.
Typical splits by segmented fields are provided below.
If you filter by key = "d", u-Slicer UI displays the following table:
| Hobbies | Impressions |
|---|---|
| a | 1 |
| b | 3 |
| c | 5 |
| d | 12 |
| Total | 15 |
This UI table is derived from the following original table:
| Hobbies | Impressions |
|---|---|
| a, b, c, d | 1 |
| b, d | 2 |
| c | 3 |
| c, d | 4 |
| d | 5 |
| Total | 15 |
All occurrencies of each hobby in the original table are mapped to 1 row in the UI table. Impressions are added for all occurrencies of each hobby, where d is included in the combination of hobbies.
If you filter by key = "d AND c", u-Slicer UI displays the following table:
| Hobbies | Impressions |
|---|---|
| a | 1 |
| b | 1 |
| c | 5 |
| d | 5 |
| Total | 5 |
This UI table is derived from the same original table.
| Hobbies | Impressions |
|---|---|
| a, b, c, d | 1 |
| b, d | 2 |
| c | 3 |
| c, d | 4 |
| d | 5 |
| Total | 15 |
All occurrencies of each hobby in the original table are mapped to 1 row in the UI table. Impressions are added for all occurrencies of each hobby, where both d and c are included in the combination of hobbies.
If you filter by key = "a OR c", u-Slicer UI displays the following table:
| Hobbies | Impressions |
|---|---|
| a | 1 |
| b | 1 |
| c | 8 |
| d | 5 |
| Total | 8 |
This UI table is derived from the same original table.
| Hobbies | Impressions |
|---|---|
| a, b, c, d | 1 |
| b, d | 2 |
| c | 3 |
| c, d | 4 |
| d | 5 |
| Total | 15 |
All occurrencies of each hobby in the original table are mapped to 1 row in the UI table. Impressions are added for all occurrencies of each hobby, where either a or c are included in the combination of hobbies.