Forum Discussion

Mauri_Castro_70's avatar
Mauri_Castro_70
Helper I
2 years ago
Solved

Beginner needs help creating Matrix or Table Showing Previous Week Tickets vs Current Week

Hi;

 

I need help creating either a table or a matrix that looks something like the example below. Where i am able to show how many tickets I had in the previous week (weekdays only / Networkdays). The total tickets during the current week, another calculation that will tell me how many tickets (using ticket id for lookupvalue) on the current week have been carried over from the previous week and finally the delta between the recurring tickes vs the current week tickets.

 

 

Weekdays onlyTotal Tickets Last WeekTotal Tickets Current WeekRecurring Tickets (tickets in current week that were also present is last week)New Tickets (Tickets that came in during current week)
Mon22027587188
Tue317291155136
Wed285313117196
Thu413367201166
Fri397425135290

 

By the way, I already have meassures that get me data for the first 3 columns (left to right); but i can't figure out how to get the meassure for the recurring tickets column data. The Delta column I am sure i can figure out (I think).

 

Thanks so much in advance for the help!

 

Mauricio

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    In the filter section, i have chosen the current week offset as 0.  I then wriote this measure

    =Measure = CALCULATE([Total Tickets],FILTER(VALUES(Data[Ticket ID]),[Previous_Week_Tickets]>0&&[Current_Week_Tickets]>0))

    I get a blank for all days.  For Friday of the current week, there are no id's that existed on the Friday of the previous week so blank is the correct answer.  I have not checked for the other days.

     

8 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

    So would it be correct to say that 220 ticket were sold on Monday of the previous week?  Do you have

    1. A Date column in the Data Table; and
    2. A calendar Table; and
    3. A week number column in the Calendar Table
    • Mauri_Castro_70's avatar
      Mauri_Castro_70
      Helper I
      2 years ago

      Hi Ashish_Mathur 

       

      The tickets columns actually refer to "open/active" service tickets in previous and current weeks respectively. I need a calculated column or measure that gives me the total of active tickets from last week that are still open in current week (as part of the 275 tickets in current week).

       

      To answer your questions 1, 2 and 3; the answer is yes! I have all of them.

       

      Thanks so much for the support!

       

      Mauricio