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))

[sunny_talwar]

May be this:

=Count({<Created Date = {'<=$(=Today()+60)}, StatusName -= {'Closed'}>} IssueID)

[Kushal_Chawda]

if is missing i think

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

[Chanty4u]

Not working bro.

[Chanty4u]

Not working bro.

[sunny_talwar]

Not working and yet you are so happy .

You know my next question to you, don't you? Sample?

[Chanty4u]

yes i know.dats y  i given smily...... it means no sample

[sunny_talwar]

Then how are we going to help you bro?

[Chanty4u]

hi kush,

this one is not showing correct value...it's calculating sum of id's.

[Chanty4u]

this expression giving error.