Important: This article describes the default version of the report that every customer gets at the start. If the report was later customized for your company, its appearance and functionality may differ, including how some metrics are calculated.
The Constructor dashboard is a Power BI report page where you build your own table of GPS call data. You choose which fields the table shows and which measure it counts: all calls, calls within or outside the allowed distance, calls shorter or longer than the required duration, or calls with or without distance data. This way, you can investigate field force activity in the detail you need and export the result.
Where to find it
Power BI Reports → GPS Tracking → Constructor
- On the Dashboard, click Power BI Reports.
2. Open the GPS Tracking report. Go to the Constructor tab at the bottom of the report.
Note: You see the dashboard only if your role has access to Power BI reports.
At a glance
| Section | Description |
|---|---|
| Dashboard / Tab Name | Constructor (Constructor tab of the GPS Tracking report) |
| Business Goal | Provide flexible analytical tools for detailed investigation of GPS-based field force activity using configurable dimensions, filters and compliance scenarios. |
| Business Value | Enables flexible analysis of GPS activity, identification of operational deviations, and export of customized reports for operational control and audit purposes. |
| Main Users | Medical Representatives, Regional Managers |
| Key Decisions Supported | Detailed check of specific calls, finding calls registered outside the allowed distance or with unusual duration, preparing data for audits and operational control |
What's on the dashboard
Thresholds
At the top of the dashboard, set the thresholds that the measure buttons use to evaluate calls:
- Target Distance, m: the target distance in meters used to judge calls with GPS data. It sets the allowed range for the Within allowed range and Outside allowed range measures. Nothing is counted until a value is selected. In the default report, 500 m is selected.
- Distance, m: shows only the calls whose recorded GPS distance, in meters, is inside the chosen range. Drag the handles or type the From and To values.
- Target Duration, min: the target call duration in minutes. It sets the required duration for the Call duration less than required and Call duration is longer than required measures. Nothing is counted until a value is selected. In the default report, 30 minutes is selected.
- Duration, min: shows only the calls whose duration is inside the chosen range. Call duration is the time in minutes from the call start to its actual closing. Drag the handles or type the From and To values.
Constructor
In the Constructor list, choose which fields the table is built from and in what order. Select a field's checkbox to add it to the table as a column, and clear it to remove the column. By default, Year, Supervisor, Employee, Country, City, Organization, Visit ID and Visit share are selected.
| Group | Fields |
|---|---|
| Date | Year, Quarter, Month, Week, Day |
| Employee | Employee Direction, Supervisor, Employee, Watcher Name |
| Location | Country, Region, Area, City, Address |
| Organization | Organization, Organization id (CRM), Organization id (Axioma), Organization type |
| Call | Visit ID, Visit share, Duration, min, Distance, m, Calls fact start, Calls fact closed, Calls date from, Calls date till, Visit Status, Visit Type |
| HCP | HCP Name, HCP Id, HCP Axioma ID, HCP Specialization, HCP Target Group, HCP Category |
Note: To see each call in a separate row, keep Visit ID selected. Without it, the table groups calls by the other selected fields, for example, by employee and month.
Measure buttons
The buttons above the table choose which measure the table shows in its last column. The allowed range and the required duration come from the Target Distance m and Target Duration min filters.
| Button | What the table counts |
|---|---|
| Visits | All calls. This measure is selected by default. |
| Within allowed range | Calls registered within the allowed distance from the call point, set in Target Distance m. |
| Outside allowed range | Calls registered farther from the call point than the allowed distance, set in Target Distance m. |
| Call duration less than required | Calls shorter than the required duration, set in Target Duration min. |
| Call duration is longer than required | Calls longer than the required duration, set in Target Duration min. |
| With distance | Calls with a recorded GPS distance. |
| Without distance | Calls without a recorded GPS distance. |
Table
The table is built from the fields selected in the Constructor list, one column per field. The last column shows the measure selected with the buttons above. Rows are sorted by the measure, highest first. The Total row at the bottom shows the total of the measure. The report filters and the targets you select apply to the table.
Note: To export the table, hover over it, click More options (…) in its upper-right corner and select Export data.
Report filters and buttons
The filters on the left narrow all visuals on the page. Most of them support multiple selections.
| Filter | Description |
|---|---|
| Period Filter | Quick period filter: All Periods, Current Year or Current Month. Shows only the calls dated in the chosen period. By default, the dashboard shows the current month. |
| Year | The calendar year of the call date. |
| Month | The month of the call date. |
| Day | The day of the month of the call date. |
| Direction | The direction the employee belongs to. Shows only the calls of employees from the selected directions. |
| Supervisor | Shows only the calls made by the employees of the selected supervisors. |
| Employee | Shows only the calls made by the selected employees. |
| Position | The employee's position. Shows only the calls made by employees in the selected positions. |
| Area | The area of the company where the call was made. Shows only the calls to companies in the selected areas. |
| Archive | The archive flag of the company where the call was made. Use it to show or hide calls to archived companies. |
| Country | The country of the company where the call was made. Shows only the calls to companies in the selected countries. |
| Visit Status | The call status as named in the CRM task state dictionary. Shows only the calls in the selected statuses. |
| Visit Type | The call type as named in the CRM task type dictionary. Shows only the calls of the selected types. |
| HCP Specialization | The specialization of the HCP the call was made to. Calls to institutions have no specialization. |
| HCP Target Group | The target group of the call, taken from the CRM target dictionary. |
| City | The settlement of the HCP or institution the call was made to. |
| HCP Category | The category of the institution or HCP the call was made to. |
- Info: opens the Proxima knowledge base in a new browser tab, where the user guides for the dashboards are published: descriptions of pages, filters and metrics.
- Notify Employee: opens the CRM messenger with the employees shown under the current filters as recipients, so you can send them a message about these results.
- Last update: the date and time of the latest data refresh.
Tooltips
To see what a visual shows, hover the mouse over it, and then hover over the question mark icon (?) that appears above it. A tooltip with the description opens. The descriptions in this article are based on these tooltips.
Typical scenarios
- Find calls registered far from the customer. Select Employee, Organization and Visit ID in the Constructor list and click Outside allowed range. The table lists the calls registered farther from the call point than the target distance.
- Check the call time. Add Calls fact start, Calls fact closed and Duration, min to the table and click Call duration is longer than required or Call duration less than required to find calls with unusual duration.
- Find calls without GPS data. Click Without distance and select Employee and Month to see which employees have calls that can't be checked by GPS.
- Prepare data for an audit. Select the fields you need, set the filters, and export the table with More options (…) → Export data.
- Follow up with employees. Filter the dashboard to the employees in question and click Notify Employee to message them about the results.
Important: The dashboard shows only synchronized CRM data. If employees haven't synchronized their apps, their latest calls may not appear yet.