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.

fbtm_analysis_example_field_list

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:

•	Year_DATE_TIME

•	Quarter_DATE_TIME

•	Month_DATE_TIME

•	Day_DATE_TIME

This should result in an output similar to this one (your data will be different of course):

fbtm_analysis_example_grid_1

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.

fbtm_analysis_example_edit_measures

Click Add and edit some data as shown in the following dialog.

fbtm_analysis_example_edit_measure

Click OK. Tick the checkbox of the newly created measure as shown in the following screen.

fbtm_analysis_example_edit_measures_selected

Click OK. A new measure is now available for selection, which is indicated as:

fbtm_analysis_example_grid_2

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:

fbtm_analysis_example_grid_3

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:

fbtm_analysis_example_grid_4

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.

Analysis - Walk Through Analysis Example
Analysis - Walk Through Analysis Example