Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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:

image-20241021-125259.png

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.

...