7 Replies Latest reply on Aug 25, 2013 9:49 AM by Shawn Wallwork

    Analyzing latest period & hiding previous periods

    Nathan Schofield

      Hi all,


      I have a series of data for which I will be constantly adding the latest month to. I have calculated variables within the viz which compare to previous periods.


      I want to be able to only view one periods data at a time (and the associated calculations which refer to previous periods).


      The only way I have found to do this is to not filter, but to hide the unnecessary  periods each time I append a months data. This way the previous months are still there to reference. This is cumbersome and manual and I want to automate it.


      Is there a way that I can select one period of data and still have my calculations referring to other periods work? Ideally for me this would work just like a filter.


      I have attached a dummy example csv and tableau to illustrate this. If you can set it up so that I can select one period and all the others will be hidden (and still have the calculation work) that'd be great.