Forum Discussion

nmunari's avatar
nmunari
New Member
9 years ago
Solved

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 mont...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
wes-shen-poal
Helper III
9 years ago

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