Group graph data to display quarterly

[Former Member]

Hi All,

I have a graph as below, but I would like combine the records into quarter of year. Can this be done and how?

Example:

2015 - Quarter 1: Jan 2015 - Mar 2015

2015 - Quarter 2: Apr 2015 - Jun 2015

2015 - Quarter 3: Jul 2015 - Sep 2015

2015 - Quarter 4: Oct 2015 - Dec 2015

2016 - Quarter 1: Jan 2016 - Mar 2016

My graph setting as below:

Category = string(duedate,"mmm")+' '+string(duedate,"yy")

Value = 100*(count(wono for graph)/count(wono))

Please advise.

Thank you.

[Former Member · Accepted solution]

To calculate the Quarter from a date in the datawindow you can use this:

1 + int ((month (duedate) - 1) / 3)

[Former Member]

Hi All,

Thanks for help and my question is answered well.

Thanks a lot.

Regards,

Yow

[Former Member]

Hi Yow;

FWIW: I do this in my SQL using the "Group By" clause ... for example (click here).

Regards ... Chris