help with chart please - newbie

[#1]

hello everyone

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

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

[sujeetsingh]

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.

[#3]

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)

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

[#4]

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