Ir al contenido
Menú
Se marcó esta pregunta
1 Responder
2820 Vistas

Hello 

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

Avatar
Descartar
Autor

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?

Mejor respuesta

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
Descartar

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

Publicaciones relacionadas Respuestas Vistas Actividad
1
mar 15
8704
1
mar 15
8427
2
ago 25
236
2
may 25
1357
1
abr 25
1276