[SalesForce] How to i query for the type in opportunity stage

Stagename does not have an value = "open" The standard values are

Prospecting
Qualification
Needs Analysis
Value Proposition
Decision Makers Perception Analysis
Proposal/Price Quote Negotiation/Review Closed Won
Closed Lost

If you are referring to the status you need to do

SELECT Id, Name FROM Opportunity WHERE IsClosed = FALSE 

The above query gives you all open opptys.

Refer here : How can i query for the type in opportunity stage?

This doc provides more info on OpportunityStage

https://www.salesforce.com/us/developer/docs/api/Content/sforce_api_objects_opportunitystage.htm

This report will be an Opportunity History Report. I have a similar report that was built solely for a graph. For mine, I made it a matrix report.

I added the From Stage on the left, and the To Stage on the top. Add a filter that says Stage Change = True. After that, I added my chart. The Y axis was the record Count, the X Axis is From Stage.

Since our Opportunities never skip a stage (at least in our system, as a validation rule has been added to prevent that), each move is from the previous stage to the next stage. So, my chart shows that we have a lot of Opportunities in Stage 1, fewer in 2, even fewer in 3, and so on.