Raw data and Measure aggregation types

A few of the other Display folders may need a little explanation:

The raw folder contain all columns as dimensions – including columns that would normally be regarded as measure columns.

This can be useful e.g. if you are analyzing a survey where survey participants have rated statements with a score 1 to 5. With the .raw dimension you would be able to categorize data by score value.

E.g., in the screenshot below, Amount.raw has been used as a dimension together with the *.cnt measure.

The information we see here, is that the file contains in total 4,198 records, and that the Amount value of “55,2” appear in 24 of those records.

In the cnt measure folder you will find count measures for each dimension and measure, but these are by default distinct counts. Only the *.cnt will give a full count.
In the screenshot below, a number of different measure types have been added to the crosstab, and each of these are explained below the screenshot.

Columns explained:

• Bill-to Name: This is a standard dimension that has been picked to be displayed along the vertical axis of the crosstab.

• Amount.sum: This is probably the most commonly used measure type. For Adventure Works, we can see that the total / summarized / aggregated value for Amount is 48,516.

• Amount.avg: This is the average value across all transactions. For Adventure Works, the average value is 693, which by the way is equal to Amount.sum divided by *.cnt (48,516 / 70).

• Amount.max: This is the maximum value across all transactions.

• Amount.min: This is the minimum value across all transactions.

• Amount.cnt: This is the distinct count of unique Amount values. For Adventure Works it is 49. Remember that e.g. the value 55,2 is present multiple times, but it is only counted as one here. This is why the Amount.cnt can be less than the total number of transactions (*.cnt = 70).

• Bill-to Name.cnt: Again, this is a distinct count, so unique appearances of Adventure Works will only count as 1 – as it will with any other customers in this crosstab. From the Total row, however, we may see that we have in total 78 distinct customers.

• *.cnt: Counts the total number of transactions for each dimension member. Adventure Works appear in 70 transactions.