3 Replies Latest reply: Dec 13, 2012 7:51 AM by Colleen Cross RSS

    help with chart please - newbie

      hello everyone

       

      have the following fields: these are months from an excel spreadsheet

       

      month query.jpg

      I am trying to compile a bar chart to show the fluctuation of attendances per month. i think i should be containing these fields into something else like month but i am unsure on how to do this

       

      any guidance would be greatly appreciated

       

      thanks

       

      D

        • Re: help with chart please - newbie
          sujeet singh

          Hi,

           

          Let Date be your datefield..and Attendence is field with 0 for Absence or 1 for presence

          Now while loading..........

           

          Load

          Date,

          Attendence,

          --------new aliase field-----------------

          Month(Date) as Month

           

          from...exl....

           

           

          Now you can use month as Dimension...and Expression=sum(Attendence)

           

           

          Any other issue let me know.

            • Re: help with chart please - newbie

              Hello

               

              Many Thanks

               

              I would have done as you have mentioned but the data i am using has the following layout (i have removed the figures)

               

              layout.jpg

               

              I am thinking the script needs to be changed to categorise all the dates into one field but i am unsure about the correct way to do this?

               

              Thanks

               

              D

                • Re: help with chart please - newbie

                  Load the script using the wizard (when you click on the table files button at the bottom of the edit script box it prompts you to open a file and then opens a wizard) go through the process and choose the enable transformation process option. When you get to the File Wizard option view it gives you the option to put your data into a Crosstable - this will help you to put all the dates into one data field.

                   

                  Hope this helps