Navigating through Qlik reporting sheets

The Video Call service has six Qlik reporting sheets available, plus an introduction sheet which has a brief explanation about the data and functionality of each sheet. The introduction sheet is the landing page for account holders.

The available sheets are accessible in a drop down Sheets menu at the top right of the Qlik application, as shown in the below screenshot. From there, click on the desired sheet to access it: 

For an explanation of the data you can access and filter in each sheet, refer to the information in the drop down menus further down this page.

Filtering

Qlik filters can be applied to the reporting sheets, enabling users to drill down to the information they require. The sheets all contain different data, however the filtering process is the same. To apply filters:

You can filter on the headings in left hand side (LHS) column of each sheet or by selecting a data value from the interactive graphs and tables. In this example you see the consultations sheet for the Acme Health demonstration organisation. Please note: We applied a filter to view only the Acme Health demonstration organisation (by clicking on Organisational Unit in the left column, searching for and selecting Acme Health demo, then clicking the green tick to apply the filter). See the bottom screenshot to the right.
In this example, we have clicked on the Clinic option in the left column and selected the Acme Cardiology clinic, then clicked the green tick option to apply the filter. That filter has been applied at the top of the page so now we are seeing data for that clinic only in the Acme Health Demo organisation. Now you can see the filters applied are Date Range - Last week, Organisational Unit - Acme health Demo and Clinic - Acme Cardiology. Please note: You can filter on more than one option and apply - you could, for example, select more than one clinic to view the data for the selected clinics.
To change the date range you can click on the Date Range filter (highlighted in red) and choose your selection, then click on the green arrow to apply the filter change, as shown in this example.
You can clear a filter by clicking on the X to the right of the filter. Please note: The date range cannot be cleared as a range needs to be selected, but you can select a new range and apply. Selecting All Dates will show the entire data set.
You can click on values in the graphs and tables available in the sheets to add filters and dig down into the data at a more granular level. In this example, we have clicked on a particular date (22.8.2022) in the graph and a filter (showing the data for this date only) will be applied. After selecting all desired values, click the green tick to add the filter with your selection.
You can select multiple values to filter on. For example in this screenshot we have selected multiple clinics to view their data. Clicking the Green Tick at top right will add this selection as a filter.

Navigating the Scorecard sheet

This sheet provides an overview of the activity for your Organisations and Clinics on the Video Call platform. In the centre of the page, you will see totals for consultations and room calls, as well as activity by Organisational Units, Clinics and Members. You can filter the trend graph by Financial Year, Calendar Year or Day.

This example shows the Scorecard information for the Acme Health Demo organisation (a filter has been applied to show only this organisation).  Filters can be applied to this sheet as outlined in the Filtering information on this page.  Remember that any filters applied will show at the top of the sheet in the green rectangles and can be removed by clicking the X to the right of the filter.
In this example we have clicked on Clinician in the left column and selected a single clinician. The filter has been applied and the data now shows the information for this clinician only.

Navigating the Call Analysis sheet

This sheet provides a detailed analysis of call activity across any dimension you would like to apply filters to. You can change the dimension by selecting from the “By” dropdown box. You can also switch between Counts and Durations by clicking on the desired option under the show menu.

This sheet gives you a breakdown of information across multiple graphs.

This example shows the Call Analysis information for the Acme health Demo organisation, with a Date Range set for the last 3 months. Filters can be applied to this sheet as outlined in the Filtering information on this page.  Remember that any filters applied will show at the top of the sheet in the green rectangles and can be removed by clicking the X to the right of the filter. .
You can change the dimension by clicking on the By dropdown. For example, in this screenshot we have clicked on the By dropdown and selected Clinic (the default selection is Org Unit). This shows Call Analysis data by clinic.
You can also drill down further by selecting values in the graphs. In this example I have clicked on the clinic called Acme Clinical service (demo), in the Clinics graph. The filter is applied and the data is now showing for that clinic only.

Navigating the Calls sheet

This sheet provides a detailed view of the call data in table format. You can display by multiple data dimensions at the same time using this table format and filter as desired. You can easily extract this information by clicking on the table and choosing ‘download’. 

In this example we are filtering by 4 organisational units and viewing the call information for those organisations. Filters can be applied to this sheet as outlined in the Filtering information on this page.  Remember that any filters applied will show at the top of the sheet in the green rectangles and can be removed by clicking the X to the right of the filter.
You can filter by selecting orgs from the table to show the data for those orgs only. You can also do this by selecting the desired orgs in the Organisational Unit dropdown menu.
At the top left of the sheet you will see View By ...And ...And where you can add more parameters to your data in the table. In this example we have selected View By Org Unit...and Clinic...And Clinician.  Now we can use the + signs in the table to access more information.
In this example we have accessed the selection made in the previous image to drill into the data by clinic and then clinician, for the Acme Health Demo org. Click on the + buttons in the left of the table to access the required data.
You can also filter by Month/Year and Date to drill down into the data. In this screenshot we are about to select a date to view that data for that date specifically.
You can access more options by going to the 3 dots above the table. In this screenshot you can see the available options. This includes a Download option to download the data (you can also do this by right-clicking on the table and selecting download).

Navigating the Clinics sheet

This sheet gives you graphical views and totals of Clinic activity. It contains totals for active Clinics, Members, Room calls and Waiting Area consultations.

The Clinics sheet shows consultations data in clinics. It includes graphical views and totals of clinic activity. This example show the Clinics data filtered to show the last 3 months in 4 organisations.   Filters can be applied to this sheet as outlined in the Filtering information on this page.  Remember that any filters applied will show at the top of the sheet in the green rectangles and can be removed by clicking the X to the right of the filter.

You can, for example, filter on one or more clinics to dig deeper into the data. To do this click on Clinic in the left column and select the clinic(s) you would like to filter on, then click the green tick to apply the filter.

Navigating the Transfers sheet

This sheet gives you an overview of all consultation transfer information in clinics and organisational units on the Video Call platform. It contains totals, clinics transferred from and clinics transferred to. The bottom table allows you to drill down to call level data.

The Transfers sheet shows data for all transferred calls between clinics. In the table at the bottom of the sheet, you can filter by date, organisation or clinic and can view the Session ID for calls. Filters can be applied to this sheet as outlined in the Filtering information on this page.  Remember that any filters applied will show at the top of the sheet in the green rectangles and can be removed by clicking the X to the right of the filter.

Navigating the Details sheet

This sheet gives access to a detailed view of PHN and GP activity as well as Clinic and Call details. It is capable of drilling down to an individual call level, for deeper analysis.

The first PHN Details tab in the Details sheet shows PHN Details. This is only relevant for Primary Health Network jurisdictional leads. The PHN details in this example have been obscured for privacy. Filters can be applied to this sheet as outlined in the Filtering information on this page.  Remember that any filters applied will show at the top of the sheet in the green rectangles and can be removed by clicking the X to the right of the filter.
The second tab in this sheet is Clinic Details. Here you can see clinic consultation information.     You can filter and sort in the table to drill down into the data.
The third tab in this sheet is Call Details. Here you can see details of all calls in the clinics for the filters you have set. You can filter and sort the data in the table to drill down into the data even further.

Navigating the GA (Google Analytics) Details sheet

This sheet gives access to a detailed view of Google Analytics information tracked from each call that is conducted on the Video Call platform. It can help in showing usage of applications and general information about Device types and browsers. 

The Details sheet contains a table with the raw data and a record for each call that has occurred in your jurisdiction. You can apply filters by selecting any of the desired categories. The details tab has the following list of attributes: Country - Origin of caller Region - Region caller originated Organisation Name - Name of Organisational Unit Clinic - Name of Clinic Clinician - Name of Clinician Participant ID - Participant ID from consultations report Device Model - Model of the mobile device (Note: iOS models not shown) Screen Resolution - Resolution of the screen in pixels  Operating System - Operating system used for the Video Call Browser - Browser used for the Video Call Event Name - Name of the event tracked in GA Event Label - Name of the event label tracked in GA Event Category - Type of event category tracked in GA
To select data for patients, click on any blank row in the Clinicians column and apply the filter. Please note, all patient data is purged at the end of the call as no PII is stored on the platform.
Once the patient filter is applied, you can change to Clinician data by clicking the green "clinician" filter at the top, selecting the three dots menu and then choose "Select alternative".  This will apply the filter to show all Clinicians who have completed a consultation during the time period selected.

Navigating the GA Analysis sheet

This sheet gives access to a detailed view of Google Analytics information tracked from each call that is conducted on the Video Call platform. It can help in showing usage of applications and general information about Device types and browsers. 

This sheet contains data in graphical form with detailed graphs showing Browser, Operating System, Device Model, Top Events and Top Screen Resolutions.  Filters can be applied to this sheet as outlined in the Filtering information on this page.  If you would like to apply any specific filters such as Patient/Clinician, please see the "Navigating the GA (Google Analytics) Details sheet" accordion above for instructions.

Navigating the Call Quality sheet

This sheet contains data from the star rating survey that is presented to patients and healthservice providers at the conclusion of a Video Call consultation - this star rating displays if no other post-call link (such as a link or thank you page) is configured in the clinic. Jurisdiction leads with Qlik accounts can filter the information as outlined in the Filtering section above.

There is a Rating summary at top left of the information on the sheet, as well as the average quality rating and the number of responses.
At the far right of this sheet there is a graph showing the response categories and the then number of responses for each. There are also tabs for responses by clinic and org unit.
At the bottom of the sheet there is a table that can display ratings and comments for your organisations and clinics.

Navigating the Calls Trends sheet

This sheet provides an overview of the activity for your Organisations and Clinics on the Video Call platform. In the centre of the page, you can see totals for consultations and room calls as well as activity by Organisational Units, Clinics and Members. You can filter the trend graph by financial year, calendar year or by day. 

There is a selection drop down box in the top right corner of the sheet. Select your filter to display the information.
Upon selection of the filter, it will show you your trends based on those selections. This will include a 6month rolling average line to help you follow the trends.
Below the graph you will also see a table containing the data for the periods and filters you have selected. You can download this data as required.

Navigating the Dimension Weekly & Monthly Trends sheet

This sheet provides an overview of the activity for all available dimensions and the call behaviour on the Video Call platform. There are two graphs on this page which depict Weekly and Monthly trends for your selected dimensions. 

There is a selection drop down box in the top right corner of the sheet. Select your Stacked Dimension to filter by and display the information.
The weekly calls graph will display based on your selection. This example shows Organisational Unit having been selected.
The Monthly calls graph will display based on your selection. This example shows Organisational Unit having been selected.

Navigating the Jurisdiction & Clinic Specialty sheet

This sheet provides an overview of the clinic specialty activity for each Jurisdiction (or Organisational unit within your jurisdiction) on the Video Call platform. There are two graphs on this page which depict the overall usage by Jurisdiction or Organisational unit (if a jurisdiction filter is being applied).

This example shows a filter being applied for the jurisdiction and thus, showing usage for each specialty across the organisations that belong to that jurisdiction.
The second graph shows an overall view of the top specialties used across the jurisdictions. You can click on any of the specialties to zoom in and find out further information for that specific specialty.