Line graph of avg aggr count of primary key where date fields difference <= user inputted variable
Hello,
So my question is a bit complicated so I will do my best to explain.
I have a table that has a primary key called 'ACC_ID' along with the fields of this table include a field called 'Received_date' and a field of 'Printed_date' which are event dates that trigger when a new ACC_ID is created for received_date and when work is completed a trigger for the Printed_date. On my sheet I am attempting to show ACC_ID that are with in a turn around time of what ever the user inputs between the two dates.
The Line graph will show the average count of accessions per day (for Printed_date) that have a difference in time between the received_date and Printed_date less then what ever a user inputs for a variable like '2' days.
For Example, A user will access the sheet and look at the graph and input a variable somewhere that says 'enter the resolution time filter' where they will input that number of days between the received_date and Printed_date that will count that ACC_ID. The graph line will represent that average number of ACC_ID per day that have a difference >=x between the Received_date and Printed_date.
I think the easiest way should be to create the number of days between Received_date and Printed_date as additional field in the load script using something like LOAD ... Printed_date-Received_date as DaysReceivedToPrinted FROM ...
and let the users select in a listbox whatever value or range they are interested in .
