A drill down into a visual is meant to reveal additional information. Hovering over a visualization will show you if you have a drill or not

1. To enable a drilldown, select the down pointing arrow in the top right corner of your visual. When it turns dark, it is enabled. If you don’t turn on a drill, selecting a visual element will cross-filter the other charts on the report page. Another way to drill down is to right click on the element in the visual that you want to drill into and select ‘drill down’.

2. With the drilldown still enabled, you can drill down one field at a time, by clicking on one of the elements in your visualisation (if it’s a bar chart, then you would be clicking on a bar). You’d be shown another level of information, depending on the drilldown criteria chosen. To drill back up, select the Drill Up icon in the top left corner of the visualization (or right click on the visual and select drill up).

3. To drill down all fields at once, select the double arrow in the top left corner of the visualization or right click on the visual and select ‘show next level’.

4. Another interaction you can have with a visual is Expand All Down One Level in the Hierarchy (unified arrows icon). This will result in a visual containing a combination of data both from the first and the second level of drilldown. You can obtain the same behaviour by right clicking on the visual and select Expand to next level.

Another important feature is the focus mode (the icon is a rectangle and an arrow pointing the upper right corner), which allows you to expand a report visual to see more detail.

A click on the horizontal ellipsis will pop-up a GUI that allows you to sort and export your data.

You would find both on the upper right corner of your visual.

Weekly admissions, forecast and budget and Weekly Admissions and forecast visuals have a drill down option.

The reporting period is one financial year. Both the reporting period and the current week are displayed as information on top right corner of the report.

The information in the report can be filtered by Week Number, Cinema and Title. The week is the Cinema Week.

Actual: Total admissions for the respective week

Forecast: Total forecast, for the respective week, for the theatres where the movies are/were booked. For the movies not booked, total forecast is displayed.

Budget: Total budget for the respective week

Right click on a week-> drill down will show info at a cinema level for that week. See data will display the data in table format.

It allows the selection of the cinema names in the chain. If nothing is selected, then the information pertaining to all cinemas is displayed.

It allows the selection of the movie titles. If nothing is selected, then the information pertaining to all movies is displayed.

Actual: Cumulative admissions for current year to date

Forecast: Cumulative forecast for current year to date

Budget: Cumulative budget for current year to date

Actual vs. Budget: Percentage of performance over or below the budget = (Actual-Budget)/budget

Actual vs. Forecast: Percentage of performance over or below the forecast = (Actual-Forecast)/Forecast

Release Date: the date when a movie is set to be released

Title: The movie title

Forecasted: Yes or No if a movie has a forecast set in the Forecasting module of CI

Booked: Yes or No if a movie is under ‘Yes’, it means either the movie has a booking made or is in schedule

Actual: Actual admissions for that specific movie

Forecast: Forecasted admissions for that specific movie

It shows the same information as the weekly admissions and budget visual, except for the budget and the drill down option, which will show the lifetime of a movie when a Title is selected in the Title visual.

Actual: Total admissions by week for the lifetime of the movie

Forecast: Forecast by week for the lifetime of the movie

Right click on a week -> drill down will display all cinemas where the movie was booked for that specific week, with their respective forecasted admissions.

Displays only the movies that have both forecasted and actual admissions and their respective difference. The information is cumulative.

It displays the weather for the selected period, depending on cinema name and week, if filtered. We only display weather for 10 future days.

Changes from the forecasting module are visible only the next day in the rolling forecast report.

Changes made in the Bookings module influence the forecast information that you see in the report and the changes are visible the following day.

The forecasting module will still show the forecast for all the locations, however, the report will show the forecast only for the locations where the movie was booked or the forecast for all locations if the movie was not booked.