...
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. Calculation: time(sum(scheduled/60/24),'hh:mm') |
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”. Calculation: time(sum(worked/60/24),'hh:mm') |
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. |
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. |
...