Hello community,
I've got some questions about the new Mashzone 2.1:
1. The Online Help is not working. Do you have similar problems?
2. I need to remove doublets. I want to aggregate one column, but i need to keep the rest of the columns (only the first of the data rows). When i use the operator "Aggregate", then i loose all other columns. Combining of two data sources doesn't help me (one with aggregated column, one with all others columns), because Mashzone can't match one row from one data source with several others from another data source.
Any answers are appreciate d.
Best regards,
Matthias
1 Reply
-
Hi Matthias,
I don't know what's wrong with your installation. Clicking on Help opens a new browser window showing the help in all installations I've seen.
But did you know that there is an offline version of the help (PDF as well as HTML) in your local installation? Please refer to folder docs of your MashZone installation.
Alternatively the most recent version of help can be downloaded from http://www.mashzone.com/en/Support.
.png)
Aggregation. By its very nature aggregate removes rows as well as columns. Aggregating a table as depicted above returned the, e.g. sum of invitations, leads and participants. So columns of type text are removed, only nummerical remain as their values can be aggregated. Columns of type text or date remain only if you group your result by creteria. If grouped by continent there will be another column of type text. The number of row corresponds to the number of distinct text values. In MashZone's aggregation operator you specify group by clauses by selecting columns as dimensions as visualized below.
.png)
Regards
Stephan