Displaying Outstanding Monthly Trend

[Keitaru]

Hi,

Need help for this have been trying to get my numbers in synced with my Excel charts.

I want to be able to Display on a line chart Outstanding Open issue on a monthly basis.

As long as the ticket is still open it will be counted in to the following month until closure.

I've attached the sample data.

Here the expression that I've used:

Aggr(Rangesum(Above(Count(distinct {<Status={'Open'}>} [TICKET ID]), 0, rowno(Total))),Month_Year) + Aggr(Rangesum(Below(Count(distinct Status={'Closed'} [TICKET ID]), 0, rowno(Total))),Month_Year)

Got something like this however the numbers don't look correct when I aligned them up with my data on excel.

Could someone help me out here?

[Keitaru]

Can anyone help?

So need to find out how I can count Monthly open outstanding tickets against, newly created and closed tickets.

Here is my sample data set.