Forum Discussion

MayurGaikwad's avatar
MayurGaikwad
New Member
3 years ago

Week wise analysis of requests

Hi,

 

how can I build week wise analysis of requests

for eg I have a table (from Jira) which has records of requests to be developed. During catering such requests it flows through various teams like business, Dev team, testing team etc. There is. Separate column we maintain to call out such dependency like if request is with business user, value in table is Business, if with Dev team, value is Dev etc. I want to build a week on week analysis as how many requests are in which buckets every week.

Need Help

1 Reply

  • kpost's avatar
    kpost
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Without more info (You'd be surprised how many ways people on this forum choose to define what a "week" is).   I can just throw generic advice at you.  Add a "Week" column to your Date table.

     

    1) You can do it via Week Ending (Saturday) date :

    Week Ending = FLOOR(Date_Table[Date].[Date]-1, 7) + 7
     
    Or:
    2) Week number where January 1 - 7 are Week 1:

    Week Number = 
    var Julian_Date = DATEDIFF(DATE(YEAR('Date_Table'[Date]),1,1), 'Date_Table'[Date],DAY)+1
    var week_number = CEILING(DIVIDE(Julian_Date, 7, 0), 1)
    return
    IF(week_number = 53, 52, week_number)

    .....


    This will give you a couple of different ways to view data on a weekly view.  Unless you can provide more info and then I can provide more info.