7 Replies Latest reply on Nov 22, 2017 5:18 AM by Brent Mathison

    Calculated Field that sums from Week 1

    Steven Wright

      My viz displays a sum of tests performed for a financial year but in week blocks e.g. Week 5, Week 6 etc. What I would like to do is create and insert a calculated field below "Week Number" that displays the total number of tests performed from Week 1 up to the week numbers i am displaying on my viz. I have tried running total but if i display only week 19, week 20 and week 21 the running total starts from week 19 which displays 56, 90 and 158 whereas I need the calculation to always start from week 1. The number of tests in the below image are correct for each week but the correct total from week 1 to week 21 is 1,056. I am using Tableau desktop v10.3

       

      Capture.JPG