Calculate Opportunity win and loss percentage in a Report

[olof]

Using the advanced pack how would you create an opportunity win / loss percentage report by user?

[tanya]

Hello,
Without developing I can see the only way - use count and show the chart.




It's not the same, I understand
Percentage is available in Pie chart, but you can use this chart only if you have only one group by field

[olof]

Understood, thanks Tanya.
Support is fantastic as usual!
Olof

[tobias]

Hi Tanja,

We have a similar request.

What we need is a report with the following KPIs for a certain period of time (e.g., last month):

1. Number of Leads/Number of Contacts
2. Number of Calls/Number of Leads
3. Sum of Opportunities (in EUR)/Number of Leads
4. Number of Accounts/Number of Quotes
5. Number of Accounts/Number of Leads

Is this somehow possible in the meantime without having to export the report and calculate the values in a spreadsheet?

Your help is much appreciated.

- Tobias

[yuri]

Hi Tobias,

Reports with data from different not related entity types are not supported at this moment. Will be considered in the future.

[tobias]

Thanks for the quick reply Yuri, although this is somehow bad news. For sales controlling, having the right KPIs in place is key.

Have you got any hints or starting points for a workaround?

[yuri]

You can have multiple dashlets showing these numbers.

[tobias]

Thanks again, Yuri. However, I'd really need a kind of report that I can export and send via e-mail, rather than having the figures on the dashboard.

[yuri]

Joint grid report type is planned.

[tobias]

This would be a major improvement, thanks for the teaser Yuri.

[olof]

Absolutely - this would be a real enabler.

[yuri]

WIll be available very soon.

[olof]

Kudos!

[tobias]

Awesome, thanks.

[olof]

I was hoping that the joint grid report would allow us to have a grid report showing the following columns:

Account name
Account Target Revenue
Account Actual Revenue from Opportunities
Account Owner (assigned used)

The first 3 work great but I haven't found a way of adding the assigned used column.