5 Replies Latest reply on Nov 20, 2017 9:34 AM by Tom W

    How to visualise time frames

    Claire Tang

      Hello, all. I am experiencing a problem trying to visualise my data into the desired result. The data I currently have does not have a timestamp attribute and only has a numerical value called Seconds which have values ranging from as little as 0.1 to 5.0+. I'm fairly new to Tableau so I am only able to get the overall sum which can then tell me the full time duration; however, what I require is the sum of Seconds during which another attribute, Count, changes between 1 to 0 and back. e.g. sum of Seconds where 27 consecutive records of Count=0, followed by sum of Seconds where 18 consecutive records of Count=1, and so on and so forth.


      Is what I'm trying to achieve possible without a timestamp? If so, could someone please point me in the right direction?


      edit: A sample is attached for reference