4 previous dates data and hours wise data

[sonysree88]

Hi Group,

Could you please give me the solution to the below task

Actually i have one filter like day (in listbox) based on that chart can change and i should get previous 4 dates..for example if  i can select april 10th in day field i should get the data for these dates apr9th,apr8th,apr7th apr6th

and one more question is : for eg i have sales data but i need sales per hour on apr09th

help me on the both the questions please

[sonysree88]

Hi,

Can you please check this issue Here issues is if i  select any date like 9/31/2012 then i need to display previous 4dates data like 8/30/2012,8/29/2012,8/28/2012,8/27/2012

eg 2: If i select 8/8/2012 then  need to display previous 4 dates like 7/8/2012,6/8/2012,5/8/2012,4/8/2012 data in bar chart.

Note:I am attached Qvw  files.Please check let me know the solution.

Thanks

[swuehl]

If you are interested in filtering dates, try creating a real date field from [Posted At] timestamp field.

Also check that all your input records are interpreted correctly as date / time.

Why don’t my dates work?

Get the Dates Right

Dates in Set Analysis

I've worked around some issues using an advanced search, but I would suggest that you create a consistent formatted date field with correctly interpreted values in your script, then use this field with my first suggested expression.