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.

       

      Regards,

       

      Nathan