To generate Employee Activity report to track the opportunities activity count based on the count of employees.
- Login to your Apptivo account and select Reports from the left panel of your home page.
- You will be redirected to the Report activity.
- In the Report activity, click on the Settings in the App Header.
- Click on the Create button from the Reports page in Settings.
- In the Create Report page, you can add a name and description of the report.
- Keep the Toggle enabled to make the report in use.
- Enable the Filter toggle to filter out the data when generating a report.
- You can use the filters based on the financial year, quarterly period, or custom period.
- You can also set the privileges on who can access the report.
- Bases on the Privileges of the employees they can have access to generate the report.
The reports page is divided into three sections to add values accordingly.
- Context Columns
- Activities Columns
- App Columns
Context Columns
- In this section, you can determine the employees to be added to the report. It works based on criteria. If an employee matches the criteria in the context column, then the employee is added automatically to the Report.
- In the Column name, add a name for this column, Here, the column name named as Employee Name.
- By clicking on the Set Criteria, the Criteria side panel will get open.
- Select the attributes of the Employee app by using the Insert Attribute dropdown.
- Here, the condition set to list of data of a particular employee so, the email address is added.
- Then, click on the create button.
Activities Columns
- In the Activities Columns, you can decide on the activities to be listed in the Activities Column.
- Click on the (+) icon to expand the list.
- In the Column Name, you can add a name for the Activities Column.
- In the Activities, select an activity for which the report is to be generated.
- Select the aggregation type to be sum or count.
- In the Attribute column, you can set the attribute based on which the sum or count is to be calculated.
- Click on the Set Criteria, to execute the report with activities matching the criteria.
- Here, the criteria are set to include in the activity count if the Name is not empty.
- Click on the Create button.
- In the Matching Context Value, you can decide the employee attribute based on which the count or sum is to be added to an employee.
- Here, the count will be added to an employee based on the Assigned To.
- To add more than one activity or attribute to included, click the (+) icon.
- Similarly, you can create a report for multiple activities.
App Columns
- In the App Columns, you can determine the app details to be listed in the Report for an employee.
- Click on the (+) icon to expand the list.
- Add a name for the App Column in the Column Name.
- In the App, select an app from which the report is to be generated.
- Here, the Opportunities app is selected.
- Select the aggregation type to be sum or count.
- In the Attribute column, you can set the attribute upon which the sum or count is to be calculated.
- Here, Opportunities App is added.
- Then, click on the Set Criteria.
- In the Set Criteria, to execute the report with records matching the criteria.
- Here, the criteria are set to include in the report based on the Assigned To employee name.
- Then, clcik on the Create button.
- In the Matching Context Value, you can decide the employee attribute based on which the count or sum is to be added to an employee.
- Here, the Created by is selected.
- To add more than one column in the report, click on the (+) icon.
- Once the setup is complete, click on the create button.
- A new report is created and added to the list.
- Go to the Report home page. You can view the created report will be present in the left panel.
- By selecting the All dropdown, you can filter the records based on your team, employees, or yourself.
- You can export the report by clicking on the Export button.
- The report will be downloaded in.CSV format.
