Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
1 Odgovori
2866 Prikazi

Hello 

Is there a way to see how many OPP/Leads have at least 1 activity in a certain period? 

Avatar
Opusti
Avtor

when I'm doing this he gives me the count of all activities but can I add a filter so that he only counts the opp. I don't really care about how many activities more about on how many opp/leads they are working?

Best Answer

You can add opportunity as a custom group on the pivot report

While on reporting > activities menu, you can click on pivot report 'total' to add custom group Opportunity. 

This report is limited to completed activities only and the period you can specify in the filter

Avatar
Opusti

On the activities reporting pivot table the data is count of activities, you can however insert this pivot table to a spreadsheet and create count of opportunity (rows)

Please be mindful that this report only counts completed activities. You can get a count of opportunities which have activities scheduled from list view of "My Activities" menu and removing the filters (below the search field between favorites and view buttons

Video of V16 dashboard features if you wish to add the spreadsheet data to dashboard
https://www.odoo.com/event/odoo-experience-2022-2190/track/introduction-to-the-new-odoo-16-dashboards-4938

Related Posts Odgovori Prikazi Aktivnost
1
mar. 15
8754
1
mar. 15
8501
2
avg. 25
475
2
maj 25
1466
1
apr. 25
1363