1 Reply Latest reply on Mar 26, 2013 11:13 AM by philmodjunk

    stacked column chart?



      stacked column chart?


           my database tracks students, my main table lists all the students, i want a stacked column chart that shows the number of students in each dept, but the stacked part comes from i want the column to show the number of students who are active verses non active.  my active field is a drop down with yes/no as an option from a value list. 

           the chart should show the 6 different departments as the X axis on the bottom and then show # of non-active (ie "no") students on the bottom and then active (ie: "yes") students on the top of the column.  so each column will have a total number of students in that dept.  so my data needs to count the records "Active" field with the selection  of "yes" for one Y axis and the selectin of "no" for the other Y axis.

        • 1. Re: stacked column chart?

               You'd need either 6 records in your table (one for each department) or 6 groups of records.

               The two parts of your stacked column represent two different data series for the y-axis. Unfortunately, this requires two different fields to report the total students in each category.

               Let's assume that you are basing this on your table of students. and will sort the records by department to get the 6 groups of records for your 6 bars on the chart.

               You can then define two calculation fields, cInactiveFlag and cActiveFlag as:

               If ( Active = "yes" ; 1 )

               If ( Active = "no" ; 1 )

               Then define two summary fields as the total fo cInactiveFlag and cActiveFlag.

               Your two Y-axis series would then refer to these two summary fields to get the two parts of the stacked Bar.

               Make sure that your data source series refers to the "found set", "grouped when sorted" options and then sort your recors by department to get your chart.