Hello all,
When I built this report for users, all was well. It was exactly what they wanted. Now there are some things that they are requesting that I am trying to develop with what I have. The problem is that the original request may need to be revised and I am not wanting to do that.
The original request was to build a report to show the differences between 2 dates across a date range to see how long it takes to post a job position and then to fill it. There are about 13 milestones between the begin and end dates that are also calculated.
So I created a query that has expressions to calculate the differences between the about 13 different dates across the spectrum of different milestones of a hiring process.
Now they want to see a breakdown of the differences for each Fiscal Year of the difference for each date difference. So I created a query that shows this but, it is hard coded with the FY in the query. I really do not want to manage the fiscal years in the query every time a new fiscal year comes along.
How do I build this? Unfortunately my design is to create an expression in the query for each difference. Below is the name of the expressions in the query to get the differences.
Diff1
Diff2
Diff3 and so forth.
Thank You
Jim Wagner
Tidak ada komentar:
Posting Komentar