Backlog Trending

[nmunari]

Hello,

I am looking for guidance on how to solve the following problem: I would like to create a chart showing for each months the number of tickets that were still in opened status when the month ended.

The data that I have in my table are as follow:

• Ticket number
• Date of Ticket creation
• Date of Ticket closure (empty if still open)

Any suggestions?

Thank you in advance,

Nicolas

[Anonymous · Accepted solution]

Hi @nmunari,

You can refer to below formula which used to calculate the still opened tickets until month end.

TotalPerMonth= COUNTX(FILTER(ALL(TicketTable1),[TicketNumber]=MAX([TicketNumber])&&[CloseDate]=BLANK()&&[OpenDate].[MonthNo]=MAX('Table'[Date].[MonthNo])),[TicketNumber]

Notice: Table is the date table.

Regards,

Xiaoxin Sheng

[wes-shen-poal]

Hi @Anonymous

I am experiencing the same problem and stumbled across this post.

I also have

• a "Date" Table with a variable called Date
• a "Call Details" Table with variables Call Number, Log Date , and Resolved Time

I would like to see the amount of all open tickets on any given day 

In my model, there's currently an active relationship between 'Date'[Date] and 'Call Details'[Log Date], and an inactive relationship between 'Date'[Date] and 'Call Details'[Resolved Time]

Also, my Call Number has a Data Type "whole number", is that ok?

How might the formula you provided change based on above? (I tried the formula myself substituting in my variables/tables but the result just gave me blanks)

Thanks for your help

Wes