...
Measures | Description | Explanation |
Group Activities | Total amount of group activities during the given period. | Note that this measure is not distinctly count, hence it is a summary of the number of all group activity occurrences during the given period. |
Group Activities LY | Total amount of group activities during the given period last year. | No further explanation needed. |
Group Activities per Visitor | The total number of group activities per visitor in the given period. | No further explanation needed. |
Members Group Participant | Share of members that are participating in group activities in the given period. | Calculation: count({<_FlagSubscription={1}, _FlagMemberActive={1},"Group Participant"={1}>}distinct %PersonID)/[Potential Members] Members that have been participating in a group activity during the given period will be included in this measure. A person is a potential member when he or she has a subscription where the selected period in BI falls within the interval of start date and end date of the subscription. |
Members Group Participant LY | Share of members that are participating in group activities, the same period last year. | No further explanation needed. |
Number Of Slots | The total number of slots that are bookable for a group activity. | No further explanation needed. |
Occupancy % | The number of participants is divided by the number of slots for the group activity shown in percentage. | No further explanation needed. |
Occupancy % LY | The number of participants divided by the number of slots for the group activity is shown in percentage for the same period last year. | No further explanation needed. |
Occupancy Avg % | The average number of participants in group activities grouped by activity in percent. | No further explanation needed. |
Participants | The number of participants in a group activity. | The number of participants that actually showed up to the group activity, hence “no shows” are not included. |
Participants Avg | The average number of participants in group activities grouped by activity. | Total amount of participants per group activity divided by number of occurrences of each group activity |
Participants LY | The number of participants in a group activity. | No further explanation needed. |
Participants per Group Activity | The average number of participants in group activities. | Same as above. |
Participants per Group Activity LY | The average number of participants in group activities. | No further explanation needed. |
Unique Participants | Unique persons participating in group activities | No further explanation needed. |
Bookings
Measures
Description
Explanation
Measures | Description | Explanation |
Booking Quantity | Booked quantity in the given period. | Number of service activities during a given period. For example, booking a personal trainer, a massage or a tennis court. All service activities are summarized here, regardless of whether a dedicated resource is associated with each activity or not. Calculation: sum([Service Activity]) |
Booking Quantity Diff | Booked quantity in a given period against the same period last year. | No further explanation needed. |
Booking Quantity Diff % | Booked quantity in a given period against the same period last year shown in percentage. | No further explanation needed. |
Booking Quantity LY | Booked quantity the same period last year. | No further explanation needed. |
Resource Booking Quantity | Number of resource bookings during the selected period | Sum of resource bookings during the given period, both facilities and staff bookings are included. In contrast to “Booking Quantity”, “Resource Booking Quantity” takes into consideration that a each service activity summarized in fact should be associated with a dedicated resource. Calculation: sum({<_FlagHasResource={1}>}[Service Activity]) |
Resource Booking Quantity Diff | Number of resource bookings during the selected period against the same period last year. | No further explanation needed. |
Resource Booking Quantity Diff % | Number of resource bookings during the selected period against the same period last year shown in percentage. | No further explanation needed. |
Resource Booking Quantity LY | Number of resource bookings during the selected period LY. | No further explanation needed. |
Resource Scheduled | Scheduled resources in the given period. | Resource scheduled is presented as fraction of the 24 hour day. If the resource in question is associated with a schedule this schedule will decide what is presented as “scheduled/planned time”. For example see below how it could look when selecting just one specific date:  Scheduled time can also be defined by a resource work shift hours. |
Resource Scheduled LY | Scheduled resources in the given period against the same period last year. | No further explanation needed. |
Resource Usage % | Resource usage in the given period is shown in percentage. | Calculation: [Resource Worked]/[Resource Scheduled] |
Resource Usage LY % | Resource usage in the given period shown in percentage | No further explanation needed. |
Resource Worked | Worked time for a resource in the given period. | Resource worked is presented as fraction of the 24 hour day. Data displayed in BRP resource planner will be mirrored here. Same fraction logic applies here as for the measure “Resource scheduled”. |
Resource Worked LY | Worked time for a resource the same period last year. | No further explanation needed. |
Service Product Sales Amount | Sales amount in the given period. | Sum of register amount with product type marked as “Service”. Calculation: Sum({<[Product Type]={'SERVICE'}>}[Register Amount]) |
Service Product Sales Amount Diff | Sales amount in a given period against the same period last year. | No further explanation needed. |
Service Product Sales Amount Diff % | Sales amount in a given period against the same period last year shown in percentage. | No further explanation needed. |
Service Product Sales Amount LY | Sales amount the same period last year. | No further explanation needed. |
Sales
Resource Sales Amount | Sales amount in the given period. | Total sales in the given period, booked to revenue accounts 3000-3999, and associated with a resource. Calculation: Sum({<[_FlagUseForRevenue]={1}, [_FlagHasResource]={1}>}[Register Amount]) |
Resource Sales Amount Diff | Sales amount in a given period against the same period last year. | No further explanation needed. |
Resource Sales Amount Diff % | Sales amount in a given period against the same period last year shown in percentage. | No further explanation needed. |
Resource Sales Amount LY | Sales amount the same period last year. | No further explanation needed. |
Sales
Measures | Description | Explanation |
Revenue per Member | Membership income divided by the total number of members. | Calculation: [Revenue]/[Members OB]. Note that “members outgoing balance” is calculated on the max date selected whereas Revenue is summarized on the range of dates picked in the report. Therefore Revenue per member as measure will be higher when end user selects a larger range of dates and smallest when only for example last day is selected. |
Revenue | Revenue in the given period. The total amount of all accounts that has the “FlagUseForRevenue” parameter set to 1 (all revenue accounts 3000-3999). | Calculation: Sum({<_FlagUseForRevenue={1}>}[Register Amount]) |
Revenue per Member LY | Membership income last year divided by the total number of members last year. | No further explanation needed. |
Sales Amount | Total sales amount in the given period. The total amount of all accounts that has the “FlagUseForRevenue” parameter set to 1 (all revenue accounts 3000-3999) and that also are booked against a specific product. | Calculation: Sales Amount= Sum({<_FlagUseForRevenue={1}, _FlagHasProduct={1}>}[Register Amount]). Sales amount as measure does not include register amounts that are not associated with/booked against a specific product. For example accrual of revenue or other technical accounting procedures are not included in this amount. See below an example/visualization of how Revenue and Sales amount as measures differ between each other.  *N/A = not applicable |
Sales Amount Diff | Total sales amount in a given period against the same period last year. | No further explanation needed. |
Sales Amount Diff % | Total sales amount in a given period against the same period last year shown in percentage. | No further explanation needed. |
Sales Amount LY | Total sales amount, the same period last year. | No further explanation needed. |
...