I have an App which allows the users to select Startdate and EndDate based on which data is grouped by Day,Week,Month and Quarter
The following additional customization is required ,
I need 4 sets of data with below criteria :
current_date - 7 -- Day ( which display data for last 7 days, grouped by days)
current_date - 56 - Week ( which displays data for last 8 weeks, grouped by weeks)
current_date -180 - Month ( which displays data for last 6 months, grouped by Months)
current_date - 362 - Quarter( which display data for last quarter year , grouped by quarters)
I can achive the above by changing my sql using sysdate or current_date function , but i am not sure how the dates in start date and end date input get automatically get filled when the time frame filter is selected. It must also be saved within the application, so that when the app is refreshed, it provides the current rolling time period the user has applied. i.e. if Day it defaults to the last 7 days.
basically user should be able to select from predefned time frame filter and/or start date and end date , for eg user select Day from the timeframe filter , the start and end dates have to reflect
05/18/2011 and 05/24/2011 and if user changes StartDate from 05/18/2011 to 05/17/2011, then total 8 days have to appear on the graph (Xaxis).
Attached is the current Code i have in the App , and emml of the mashup in wires.
Hi
I have an App which allows the users to select Startdate and EndDate based on which data is grouped by Day,Week,Month and Quarter
The following additional customization is required ,
I need 4 sets of data with below criteria :
current_date - 7 -- Day ( which display data for last 7 days, grouped by days)
current_date - 56 - Week ( which displays data for last 8 weeks, grouped by weeks)
current_date -180 - Month ( which displays data for last 6 months, grouped by Months)
current_date - 362 - Quarter( which display data for last quarter year , grouped by quarters)
I can achive the above by changing my sql using sysdate or current_date function , but i am not sure how the dates in start date and end date input get automatically get filled when the time frame filter is selected. It must also be saved within the application, so that when the app is refreshed, it provides the current rolling time period the user has applied. i.e. if Day it defaults to the last 7 days.
basically user should be able to select from predefned time frame filter and/or start date and end date , for eg user select Day from the timeframe filter , the start and end dates have to reflect
05/18/2011 and 05/24/2011 and if user changes StartDate from 05/18/2011 to 05/17/2011, then total 8 days have to appear on the graph (Xaxis).
Attached is the current Code i have in the App , and emml of the mashup in wires.
I am using Presto 3.1 version
Thank you