Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
1 Rispondi
2928 Visualizzazioni

Hello 

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

Avatar
Abbandona
Autore

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?

Risposta migliore

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
Abbandona

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

Post correlati Risposte Visualizzazioni Attività
1
mar 15
8840
1
mar 15
8593
2
ago 25
662
2
mag 25
1550
1
apr 25
1483