Forum Discussion

AsherB's avatar
AsherB
New Member
8 years ago

Ticket Backlog

Hi,   I'm pretty new to Power Bi and learning a lot from answers given here. I'm trying to create a ticket backlog.   Following are the relevant columns: Table: 'case-export' Case # Created(c...
AsherB's avatar
AsherB
New Member
8 years ago

Hi,

 

I'm pretty new to Power Bi and learning a lot from answers given here.

I'm trying to create a ticket backlog.

 

Following are the relevant columns:

Table: 'case-export'

Case #

Created(creation date)

Resolved

'Case Custom Field 11 (Severity )'(I can also add it later as a filter, I believe it will be more simple)

 

Table: 'Calander'

Date

Month

 

The result I'm interested in is a backlog showing for each week, how many tickets were open("created" but not "resolved") and if possible by severity.

 

For example:

For week 34, we had 12 open tickets with "General" severity, 10 "minor", 5 "Major", 2 "Critical"

Just to show the trend we can use every Sunday as a week marker.

 

Thanks in advance,

Asher

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi AsherB,

     

    If you can please share some sample data to test, it will be help for analysis.

     

    Regards,

    Xiaoxin Sheng

    • AsherB's avatar
      AsherB
      New Member
      8 years ago

      Hi Anonymous,

       

      Thank you for your comment, not sure what you were expecting.

      I'll attach a screenshot of the tables.

       

      If it helps, attached a single line from the raw data('case-export').

       

      https://ufile.io/1fmgu

       

      Asher