Aggregating sales by date

[#1]

I am trying create a bar graph to aggregate sales data based on the date of the transactions (i.e. my date format is dd/mm/yyyy). I would like to view this data by different frequencies, i.e. aggregated on a month basis for the range of the data. What I have now sales showing for each individual date. I have tried using the AGGR , Group By functions but to no avail. Please help

[tresesco]

Create a Month field in the script like:

Load

          DateField,

          Month(DateField) as Month

nad then use this Month field as dimension in the chart, and expression as you want.

[#3]

Can you provide some sample data ??

[#4]

Thank you!

What if I need it by month and year as I have data from different years?

[#5]

In that case u can use this Script

Load

          DateField,

          Month(DateField) & '/' & Year(DateField) as Month/Year

and u can use "Month/Year" as Dimesion in chart

[#6]

or you use

Load

     DataField,

     Month(DateField) as Month,

     year(DateField) as Year

you can use Month and Year now in a list box and it will calculate the data always for the selected year and month.

regards,

MT

[#7]

Thanks! Seems like this should be something intuitive in the charting itself instead of having to code. For example you can do this easily in excel by using the group by function. Thank you for your help

[tresesco]

For that, you should generate field like:

Load

          MonthName(DateName) as Month