Post

2 followers Follow
0
Avatar

How can I create a bar chart showing projects completed per CY quarter?

I'd like to add a report to my management dashboard showing projects completed per quarter on the Y-axis, e.g. 4 vertical columns with the labels FY15Q1, FY15Q2, FY15Q3, FY15Q4 etc. What's the best way to do this?

Christopher Edgar Answered

Please sign in to leave a comment.

1 comment

1
Avatar

Hi Christopher,

Try to use a formula column in the report using a formula similar to this:
If(Month($ActualEndDate)>=1 && Month($ActualEndDate)<=3 && Year($ActualEndDate)=2015,"FY15Q1",If(Month($ActualEndDate)>=4 && Month($ActualEndDate)<=6 && Year($ActualEndDate)=2015,"FY15Q2",
If(Month($ActualEndDate)>=7 && Month($ActualEndDate)<=9 && Year($ActualEndDate)=2015,"FY15Q3",
If(Month($ActualEndDate)>=10 && Month($ActualEndDate)<=12 && Year($ActualEndDate)=2015,"FY15Q4","2016"))))

Good luck!
Tamir

Tamir Avital 1 vote
Comment actions Permalink