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

    Gaytri k

      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.