Group on both start date and end date
I need to graph based on multiple dates. For Example:
We have vendors that get paid at the beginning and end of a project. I need a graph by month of the number of projects they started (Start_time) and completed (End_time). The x-axis should have the months at the bottom (either start time or end time) and one bar for the count of projects started and a 2nd bar for the count of projects completed.
This is what I have so far that isn't working:
I have a main report grouped on end time and a count. Then created a formula to pull the first day of the month for the close time:
Formula (FirstCloseDay): DateSerial(Year(), Month() + 1, 0)+1
I also have a subreport grouped on the open time with a formula to pull the first day of the month for the open time:
Formula (FirstOpenDay): DateSerial(Year(), Month() + 1, 0)+1
I linked on the above formulas and in the subreport I created a shared number variable and pulled it to the mail report. That works great and can see it in data form but cannot graph the count from the subreport even though it is a shared variable.
Please help me. Thank you.