Dashboard Question

[djdeth]

Is there a way to create a dashboard having 3 criteria instead of just 2? If so, how can I do this? Thanks for the help.

[djdeth]

Also, if there is a place where I can just enter custom MySQL to make the charts, that would work just as well.

[kpit]

The Pro and Ent versions have the capability to create reports that can be used in dashboards. The Enterprise version has the capacity to create custom SQL for the reports.

In version 5.0 that is coming up will have better graphing engine for the dashboard and for the Pro and Enterprise reporting.

[djdeth]

Right now I am using SugarPro 4.2.0. How do I create the reports to use in the dashboard? Thanks.

[djdeth]

I am trying to make it so it shows a dashboard from the following:

projected sales amount by month by agent.

It does not seem that I am able to do that with the reports.

[djdeth]

Are there any modules or any other way for me to type in a query and display a dashboard instead of getting the enterprise edtion? The reports don't let me specify the way I want.