Find your content:

Search form

You are here

Can I create a bar chart that compares to target or quota?

 
Share

Is it possible to create a Bar chart on closed opptys, that will also have a value axis (or line or other format) that can be compared to either the user/division quota/target?


Attribution to: Saariko

Possible Suggestion/Solution #1

Create a separate Opportunity recordtype called "Quota", then you can set quotas by populating the Amount field on these Opportunities.

Your report will summarize Amount, grouped by Record Type, and you will see performance against quota/target.

Good luck,

Jeremy


Attribution to: Jeremy Nottingham

Possible Suggestion/Solution #2

You can do this a few ways.

  1. Standard SFDC Dashboards and Reporting per Jeremy's statement above. This is simplest approach and always use declaritive before you go into VF / code. You could create a report like Jeremey states above. That report could then feed a SFDC Dashboard of type Bar Chart.

  2. Visualforce Charting (Pilot Feature) - In VF Page you could use VF Charting to accomplish this. This is feature in Beta and would require you to use SOQL, VF, and Apex to slice and dice the data, then present it in a BarChart VF Component.

  3. Visualforce with Google Charts / 3rd Party Javascript - You can use 3rd party javascript charting tools in compination with VF and SOQL to generate this type of data.


Attribution to: CoryCowgill
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/442

My Block Status

My Block Content