2 Replies Latest reply on May 7, 2013 5:26 PM by adni

    calculation script for attendance chart

    adni

      Title

      calculation script for attendance chart

      Post

           hello,

           i want to create an attendance system and display chart. How do i write the coding to summarize the count attend and not attend in the chart?

           i write this coding, but it error. I don't know how to write so that in y-axis it shows the count of attend and count of not attend

           my coding that error :

                       Count ( student_id )
                       If ( student_status ; "attend" ; "not attend" )

           can anyone help me?

           rohana.

        • 1. Re: calculation script for attendance chart
          philmodjunk

               Much depends on how you data is structured. The type of chart you want also is important to know.

               If you have a table where each record records whether a student did or did not attend on a given day, you can use a layout based on that table to count the number of students that did or did not attend on each day by sorting your records to group them by date and charting summary fields to get your y axis series of values.

          • 2. Re: calculation script for attendance chart
            adni

                 I understand now, i've solved it.

                 it really simple, i just have to study more about chart and summary.

                 thank you so much for your answer, it help me a lot.