Suite CRM Reports - Problem to build a specific query...

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.