RE:Date -issue

[Chanty4u]

Hi all,

I'm facing an issue in the chart(Combo). I need to display Open/Closed/Raised Issues from (01-Jan-16 to 29-Feb-16) between the period. Feb-16 showing correct Number(612)..But Jan-16 is not correct.Taken Dimension:(Issue Month consist ->  Jan-16 & Feb-16).

Created Date is field used in expression.

this exp am using right now

=Count(Aggr(Created Date<=Today()+60 and StatusName<>'Closed',IssueID))

[Anonymous]

Hi Chanty

I have a query regarding your formula

Why are you adding 60 days to your date.

Are you creating ids with future dates??

[sunny_talwar]

Do you still see the red line if you remove the negative sign in front of equal?

[Chanty4u]

yes sunny.

[sunny_talwar]

that is very strange, can you copy and paste the expression here. Just want to check if we have all the brackets (curly, square, parenthesis) in correct place.

[Chanty4u]

=count({<[created Date]={'<=$(=Today()+60)'},RiskIssueStatusName={'Closed'}>} RiskIssueID)

and tried this also but no use

=Count(aggr(if(Created Date<=Today()+60 and RiskIssueStatusName<>'Closed',RiskIssueID)))