Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Ticket backlog

Dear Community,   I have a very similar issue than this one that i've tried to resolve without the desired outcome.    My scenario is very similar to the one described in this post: https://comm...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    What's the data type of your [Created] and [Resolved] column? Are they Date/time? Based on my test, if your link date/time column in fact table with date column in calendar table,it will show blank column:

     

     

    But after I create a new date column by [Create] and link it to the calendar table, it works well.

     

     

    _CreateDate = data[Created].[Date]

     

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

     

Tim_H's avatar
Tim_H
Helper I
5 years ago

v-deddai1-msft 

 

is it normal that when tickets are resolved they also are removed from the backlog ?   In other words as long tickets are not resolved thay are vissible but when resolved also the history is removed.

 

for example :

 

ticket opened 12/02/2019

ticket resolved 14/09/2019

 

when you measure in october this ticket should be visible as backlog from march until September.