Hello folks,
I have got a worksheet that contains Job_Ticket details and has data for the metrics like Incidents reopened, incidents closed, incidents resolved and so on.
The data that i have is report date, request type, plan value(avg per week for the past 6 months) , actual value(avg,. per week for the past 30 days), tech group , Technician and etc.
I am having a problem in understanding as to how to put a date filter across the dashboards as the data with me is already calculated for plan value(avg per week for the past 6 months) and actual value(avg,. per week for the past 30 days). How do i have a moving Plan and actual filtered by Date/duration across my dashboard. I have attached my workbook here which conatins past 6 months data.
Every metric has a Plan and actual value in their data source and the other details like Job_ticket_id, request type, tech group, technician that are just joined using inner join so the plan and actual would have the same values thoughout their column for every metric.
I want a user to be able to filter the data accorinding to days,weeks,months,quater,year. Report date can be used to consider the starting date of the ticket.
I need some help in understanding the Plan Vs actual values and how can we filter it by date in dashboards as the data that i have is already caluclated and shown in the dashboard.
thank you for your patience!
Packaged workbook has been attached. Thanks in advance!
Hey Sanket,
What backend database are you using? How difficult would it be to have your DB admin give you dis-aggregated data with standard dates on a separate table?
-Diego
