2 Replies Latest reply on Mar 23, 2016 3:37 PM by Johnson Chao

    Conducting Experiment: How to Display Hours:Seconds elapsed from start?

    Johnson Chao

      Hello,

       

      I am conducting experiments and plotting sensor readings vs time using Tableau. I've done so, however I notice that the x-axis, time, is in a date format, while what I want is a format where I can track how much time has elapsed from the first reading (start on experiment).

       

      Please see the Tableau Public Visualization below for context to my question:

      https://public.tableau.com/views/SingleBitSensorExperimentMarch182016Start-CONSOLIDATED/GREENLED-Reflected?:embed=y&:dis…

       

      As you can see a date format is displayed, however what I want is a hh:mm:ss that does not repeat/go back to zero after 24 hours as I have tried to do with that worksheet so far.

       

      With Excel this is really easy by simply doing a difference calculation along with formatting to custom [h]:mm:ss, however in Tableau I can't seem to do the same thing. This may just be due to my inexperience and could very well be an easily addressed question.

       

      Any help is appreciated. Thanks for reading.

       

      Johnson