Forum Discussion

andrew_hardwick's avatar
andrew_hardwick
Helper III
10 years ago
Solved

Cumulative backlog to date

I am trying to create a line graph in Power BI to show the difference between a number of opened tickets vs resolved tickets on a daily basis. I then want to show a line graph of the cumulative data....
Need Help
  • Sean's avatar
    Sean
    10 years ago

    andrew_hardwick Couple small changes since there are blank dates...  But you should be set now! Let me know.

     

Sean's avatar
Sean
Community Champion
10 years ago

andrew_hardwick Couple small changes since there are blank dates...  But you should be set now! Let me know.

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello all,

 

The calculation for the backlog worked perfectly. However, I would like to display the sum of "points" assigned to each ticket instead of the count of the opened tickets, closed tickets, and RT balance.

 

Ticket Number     Opened Date     Closed Date     Points

1234                     01-01-2019        02-01-2019       7

1254                     01-02-2019        01-09-2019       3

5432                     01-31-2019        02-01-2019       1

1456                     01-22-2019        02-08-2019       4

 

So I would like to display the sum of points for the opened, sum of points for the closed, and sum of points for the backlog.

 

Thank you in advance!