I have created tried to create chart in QV to show budget and schedule variance over time. Also, I've tried to add a control to this time to show the information by day, week and month. I also have to show the variance by time with a specific project manager - I haven't done this yet, but I'm assuming I'll have to put it on another sheet?
But with regards to the below chart - have I done the task I set out to do or show? I think I have, but it's my first day on QV and I have no idea! Any help would be so much appreciated.Thank you!
Also, to show the variance for each project as of today can I do it on this or create another chart/sheet for that? I have attached the details of the task. Thanks.
"Add a control to the time axis allowing the user to show this information by day, week or month."
This sounds like a request for something that I typically add to charts like this - a cyclic group as the dimension. Do this:
settings -> document properties -> groups -> new -> Group Name = Period -> checkmark Cyclic Group -> add Month, Week and Day -> OK -> OK
Now in your chart, remove the Month dimension and add the Period dimension. The default view will be by month, but by clicking on the little circular arrow, you can cycle between the Month, Week and Day.
Well, the sum(CostBudgetVariance) line seems to vary plenty. So it's the sum(MoveInStatusDays) that is the problem? If so it's because it has a drastically different scale than the other. The way to display them both in a single chart is to give the second expression its own scale:
chart properties -> axes -> select sum(MoveInStatusDays) -> Position = right(Top) -> OK
Then they'll both have displayable values.
The next problem I see is that you can't see one line because the other is on top of it. I recommend using transparent colors for that.
chart properties -> colors -> click on the first color -> select "calculated" -> type argb(130,0,0,130) in the box -> OK -> click on the second color -> select calculated -> type argb(130,130,0,0) in the box -> OK -> OK
I think that makes it easier to see crossing and overlapping lines.
Ah, I see another problem. I really wouldn't define Month and Week and Day the way you have. I'd define them like this:
,date(monthstart(SnapshotDate),'MMM YYYY') as Month ,date(weekstart(SnapshotDate)) as Week ,date(SnapshotDate) as Date
The problem with what you have now is that multiple years, months and weeks will all sort of intermingle in your chart. Day 15 of every month will just show up as 15. That's probably not what you want. The code above will make sure that everything is in the right sequence and not combined on your axis.