Removing one field from a circle graph

  • Thread starter Thread starter Eric G
  • Start date Start date
E

Eric G

I have a report that displays a circle graph of Reasons as follows:

SELECT Reasons.Reason, Count(*) AS [Count] FROM Reasons INNER JOIN
Detentions ON Reasons.ReasonID = Detentions.ReasonID GROUP BY
Reasons.Reason, Detentions.ReasonID;


There are 9 possible reasons that can be drawn from a Reason table.
As records are added to a Detention table, a Reason code is inserted.

I'd like the Reason Report (above code) to display a circle graph of
the Reason data BUT exclude one of the reasons (number 9).

In addition I'd like the segments of the circle graph to show their
respective percentage of the total circle.

Help in how to achieve this would be greatly appreciated.

Eric
 
Eric:

Simply add into your SQL WHERE Detentions.ReasonID said:
SELECT Reasons.Reason, Count(*) AS [Count] FROM Reasons INNER JOIN
Detentions ON Reasons.ReasonID = Detentions.ReasonID WHERE
Detentions.ReasonID <> 9 GROUP BY
Reasons.Reason, Detentions.ReasonID;
Click to expand...


--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

Eric G said:
I have a report that displays a circle graph of Reasons as follows:

SELECT Reasons.Reason, Count(*) AS [Count] FROM Reasons INNER JOIN
Detentions ON Reasons.ReasonID = Detentions.ReasonID GROUP BY
Reasons.Reason, Detentions.ReasonID;


There are 9 possible reasons that can be drawn from a Reason table.
As records are added to a Detention table, a Reason code is inserted.

I'd like the Reason Report (above code) to display a circle graph of
the Reason data BUT exclude one of the reasons (number 9).

In addition I'd like the segments of the circle graph to show their
respective percentage of the total circle.

Help in how to achieve this would be greatly appreciated.

Eric
Click to expand...
 
Hi Steve,

Thanks very much for your help.
The code worked out perfectly. I now have eliminated reason 9 from the
pie chart.

Would you know how I can display the percentages of each pie segment
and perhaps the segment names, next to the percentages?

Thanks! Eric




Eric:

Simply add into your SQL WHERE Detentions.ReasonID said:
SELECT Reasons.Reason, Count(*) AS [Count] FROM Reasons INNER JOIN
Detentions ON Reasons.ReasonID = Detentions.ReasonID WHERE
Detentions.ReasonID <> 9 GROUP BY
Reasons.Reason, Detentions.ReasonID;
Click to expand...


--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

Eric G said:
I have a report that displays a circle graph of Reasons as follows:

SELECT Reasons.Reason, Count(*) AS [Count] FROM Reasons INNER JOIN
Detentions ON Reasons.ReasonID = Detentions.ReasonID GROUP BY
Reasons.Reason, Detentions.ReasonID;


There are 9 possible reasons that can be drawn from a Reason table.
As records are added to a Detention table, a Reason code is inserted.

I'd like the Reason Report (above code) to display a circle graph of
the Reason data BUT exclude one of the reasons (number 9).

In addition I'd like the segments of the circle graph to show their
respective percentage of the total circle.

Help in how to achieve this would be greatly appreciated.

Eric
Click to expand...
Click to expand...
 
Back
Top