1 Reply Latest reply on Dec 5, 2016 5:24 PM by Shinichiro Murakami

    Pivot from Detail data with different start end dates to create a viz with result filtered data set

    Brett Schlapfer

      So I am working with trade data and I have 1 Viz that will filter down a set of trades based on trade type over time.  I have this working in a dashboard.

       

      The idea is that one I get that list of trades, with varying start and end date time frames, I want to pivot to that data and perform many types of running averages and day over day profit.

       

      For instance:

       

      Data in a filtered sheet within a dashboard

       

      TradeStart DateEnd Date
      12/1/20164/1/2016
      24/2/201510/2/2015
      36/10/20028/10/2002

       

      Would filter data for analysis as such:

       

      TradeDatePrice
      12/1/20162
      12/2/20164
      12/3/20166
      12/4/20168
      24/2/201520
      24/3/201540
      24/5/201560
      24/6/201580
      36/10/20021000
      36/11/20162000
      38/9/20023000
      38/10/20024000

       

      I have aspects for what I want in Step 2 working, and I am filtering to the first table in the dashboard.

       

      I just don't know how to make the jump - any guidance would be GREATLY appreciated!  These linkages will be totally random based on filtered criteria.

      Thanks in advance