Analysis - Walk Through Analysis Example
A simple walk through example is discussed in this section. The provided steps should get you started for your own customized analysis requirements. This example will give us the answer for the following question:
"What's the number of events along a date dimension with the following hierarchies: year/quarter/month/day".
Step 1 - Define the date dimension in the row fields area
Open the Field list editor via the toolbar. Here you see all available fields for the Analysis module. If the field is of type DATE, then additional fields like year, quarter, month, week, day are available as child nodes.
Navigate to the first field entry called DATE_TIME. Drag&drop the following child nodes in the here used order onto the row fields area:
This should result in an output similar to this one (your data will be different of course):
Step 2 - Define a new measure aggregating the number of event name occurrences
We now define a new measure, which uses a COUNT aggregate function.
Open the Edit Measures editor via the toolbar.
Click Add and edit some data as shown in the following dialog.
Click OK. Tick the checkbox of the newly created measure as shown in the following screen.
Click OK. A new measure is now available for selection, which is indicated as:
Step 3 - Define the column fields area
We now drag&drop the entire Measure (1) drop-down box shown as a red rectangle in the screen above onto the column fields area. We end up with something like that, our final result:
You now can collapse/expand the various levels along the date dimension. For example, if you are only interested in an annual statistic, either remove the quarter, month and day level completely, or simply collapse them. You then will see something like that:
This can be expanded again or mixed with additional fields available in the Field list editor as you like. I guess you now can imagine what powerful feature the Analysis module is.
What's next: The next section Reuse Possibilities discusses ways to re-use results created with an analysis task.