Number of Participants and Cancellations

Technical name: 0LSO_C01_Q0001

Use

This query displays the numbers of participation bookings and cancellations, the sum total of these, the total number of bookings per course group for the current year.

Free Characteristics

Info Object

Description

0TRAINTYPE

Course type

0TRAINTYPOTYP

Object type of course type

0TRAINING

Course

0TRAINOTYPE

Object type of course

0TRAINFORM

Delivery method

0LEARNERTYP

Object type of learner

0LEARNER

Learner

Rows

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0TRAINGROUP

Course group

Columns

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0BOOKING_NO

Number of attendees or participants

0CANCEL_NO

Number of cancellations

&0CYEAR&

Current calendar year

0LSO_C01_QT0004

Total bookings