Set Analysis - Compare dates

[Anonymous]

Hi

I have a line graph showing a count of data per hour of the day. I want to compare this to the value 7 days previous

I've used the following:

=count({<CorrectedDate={$(=(Max(CorrectedDate)-7))}>} Hour)

However, it isn't showing the 7 days previous figure on the line graph. Have I missed something?

[MK_QSL]

Count({<CorrectedDate = {'$(=Date(Max(CorrectedDate)-7))'}>}Hour)

[sasiparupudi1]

may be you have other selections that needs to be ignored?

count({<month=,year=,day=,CorrectedDate={$(=(Max(CorrectedDate)-7))}>} Hour)

hth

Sasi

[sunny_talwar]

May be this:

=Count({<CorrectedDate={"$(=Date(Max(CorrectedDate)-7), 'YourDateFormat')"}>} Hour)

[sasiparupudi1]

Hi Sunny,

You meant this?

Count({<CorrectedDate={"$(=Date(Max(CorrectedDate)-7, 'YourDateFormat'))"}>} Hour)

[Anonymous]

Tried all answers. Still not showing the 2nd line

[MK_QSL]

Post sample application pls

[sunny_talwar]

Yup, that is what I meant