Simple question - group daily data by month or quarter

[#1]

I have daily sales data. I want to graph the data by month or quarter in a graph. What is the equation to do this. Seems very obvious, but I can seem to figure it out.

[mike_garcia]

Hello,

The simplest way to achieve this very common task is to create a Month, Quarter, and maybe year field in the load script. You would do something like:

Load Sales, Month(Date) as Month, Year(Date) as Year, 'Q' & Ceil(Month(Date)/3) as Quarter From SalesData.qvd;

Then, in your chart, use those dimensions. You may want to create a DrillDown group for Year - Quarter - Month.

Regards,

Mike.

[#3]

Great hint for creating quarters or quadrimesters. Thank You !!!

[maxgro]

add a master calendar with month, quarter, year, etc....

and use month, quarter, year, etc... as dimension(s) in your chart

you can find a lot of help in the community on master calendar

The Master Calendar

Creating A Master Calendar

Miguel answer will also works