Hello everybody,
I have a simple datasource where every column represents a dimension.
|
Dimension 1 |
Dimension 2 |
|
Value A |
Value 1 |
|
Value B |
Value 1 |
|
Value B |
Value 1 |
|
Value B |
Value 2 |
I would like to represent data (referring to 2 dimension) as a crosstab, displaying the number of rows per every combination dimension1 / dimension2
|
|
Value 1 |
Value 2 |
|
Value A |
1 |
0 |
|
Value B |
2 |
1 |
Is it possible in the MashApp table editor or do I have to define a new datafeed? If so, which operation should I use to get a crosstab?
Thanks in advance.
Marco
Markus von den Driesch on
Hi,
if you have a fixed number of values for "Dimension 2", you can create a specific feed that contains a distinct column for value1, value 2 and so on.
In this feed, you split your feed into different streams by filtering on specific values for Dimension 2 and then joining the streams together by using Dimension 1 as key.