Hi there,
I´d like to have a report/dashlet showing Opportunities that are stagnated - i.e. Opportunities for which there was no phone call in the last N days…
I am using SuiteCRM 7.8.2 and have played with the report builder but could not build this sort of query. I could definitely query the Opportunities for which there were calls in the last N days but this is not what I want.
What I need is the list of Opportunities that my sales force might not be putting enough effort (i.e. Opportunities with no activity in the last few days).
How can I retrieve this information? Btw, I don´t mind hand writing the SQL query if that is possible…
Thanks all.
Leo.