0 Replies Latest reply on Jul 25, 2012 6:10 AM by Babar Iftikhar

    Finding Association percentage of one item (record) with all other items in the table (data)

    Babar Iftikhar

      Hello All,

       

      I have a timeseries data. Please see Excel for the sample data. The requirement is to  (select) a parent item say "A" in the items column. And then set a time offset say 5 minutes.

      The x-axis will represent - the items  (with item A as the parent item). We need to analyze whenever item A appeared in the table what were the other items that appeared 5 minutes before and 5 minutes after item 'A'.

       

      Item 'A' has 3 records in the data. We need to see which item apprears in 5 minutes interval before and after item 'A'. Please see the Excel file. It explains the requirement. We want the excel processing and chart to be done in tableau.

       

      Regards/

      Babar