Calculated dimension with min and max dates

[renjithpl]

HI All,

I have a date field as DateReceived, My user will select one date, so from that selected date to 30 days back, i need to show a bar chart showing emailcount on it, something like below.

I am struggling to write a calculated dimension for this. i want to display all the possible dates in dimension which has email counts.

I have the below code to calculate 30 days.

=Count( {<DateReceived={">=$(=Date(Max(Floor(Num(DateReceived)))-30))<=$(=Date(Max(DateReceived)))"}>} distinct [Email ID of Notice Recipient])

THanks

Ranjith

[rohit214]

HI ranjiby

may i kn what your expression gives result.

is it showing only selected date and last month date data.??

thanx

rohit