8 Replies Latest reply on Oct 1, 2018 3:34 AM by meenu choudhary

    Get Recent week's count of candidates and previous weeks aggregate count of candidate in one view

    Drish D

      Hi team,

       

      I'm trying to achieve "count of candidates for past 5 weeks" (sum of total number of joinees in last 5 weeks),  "count of candidates for current week" (count of joinees joined current week)

       

      in Tableau, i can see Year, Quarter, month, week for Date formats. but how do i combine count of candidates for past 5 weeks and show current week count separately.

       

      Please help me.

       

      attaching the superstore data example. i would like to show the values of  Week 48, 49, 50, 51 into one and show Week 52 separately.

       

      Hope this helps.

       

      Regards