Forum Discussion
Backlog Trending
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
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
2 Replies
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
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
