Icon

    It is recommended to get familiar with memberSum function and its variations before proceeding with this tutorial.

    The goal of this tutorial is to display the frequencies of visits based on visit counts in individual countries.

    Icon

    Visit frequencies are defined as formula indicators described below.

    Download: Demo structure & data.

    Simple Frequencies

    Use memberSum function to force BellaDati to aggregate data on specific level. Since frequencies for particular countries are calculated, apply Country attribute as memberSum parameter.

    Icon

    Formula of this indicator will count frequencies of exactly two visits. Create new calculated indicator and change condition to record other frequencies.

    Frequencies by Categories

    Extend eachMember function parameters by Category attribute to add another dimension to your frequency analysis.

    Icon

    Formula of this indicator will count frequencies of exactly two visits. Create new calculated indicator and change condition to record other frequencies.

    Frequencies by Categories and Regions

    Add another parameter to memberSum function in order to further extend dimensionality.

    Icon

    Formula of this indicator will count frequencies of exactly two visits. Create new calculated indicator and change condition to record other frequencies.

    Icon

    Note that frequencies will not be displayed correctly when adding another drill-down on the right side of the table in current version. Use filters instead. This can be also combined with report variables.

    Next Steps