show particular 5 weeks data trends in line chart

[deepakkrish]

Hi Everyone ,

I have an one date field called Timestamp which contains only data refreshed date (monday date only). 

My requirement is, I have to show the trends of data using last 5 monday dates .

This is my expression

if([Key Field]= 'BG, (1-(COUNT({<TimeStamp={">=$(=Date(max(TimeStamp)-35))<=$(=Date(max(TimeStamp)))"}>}if(IsNull([BG]), [Opportunity ID]))

/
COUNT({<TimeStamp={">=$(=Date(max(TimeStamp)-35))<=$(=Date(max(TimeStamp)))"}>}[Opportunity ID])))*100)

Denominator part is working , i dont know why numerator is not working , suggest any idea to resolve this issue.

Thanks in Advance 

Deepak.

[sunny_talwar · Accepted solution]

Are you missing a single quote after BG?

if([Key Field]= 'BG', (1-(COUNT({<TimeStamp={">=$(=Date(max(TimeStamp)-35))<=$(=Date(max(TimeStamp)))"}>}if(IsNull([BG]), [Opportunity ID]))

[Brett_Bleess]

Deepakraj, did Sunny's reply fix the issue?  If so, please be sure to use the Accept as Solution button on his post to give him credit for the help and to let others know this did fix the issue.

Regards,
Brett

[deepakkrish]

Yes this one is working..

Thanks,

Sunny.