5 Replies Latest reply on Nov 4, 2013 5:54 AM by Andrew Brooker

    Concatenated date time field (dd/mm/yyyy hh:mm) - I can't seem to split the times and dates - is this possible?

    Andrew Brooker

      Hi All,

       

      I have a concatenated date time field (dd/mm/yyyy hh:mm) for start and end of a presentation and require to create a report in Tableau capable of utilising filters on multiple perams.  The major problem I have is that I can't seem to split the times and dates in order to be able to filter on a specific day / week / hour - is this possible?  If so, how?  I also need to create an average time for these presentations based upon the time period selected.

       

      (I haven't managed to find a solution to this question on any other threads.)

       

      Currently I have not been able to get this to work in Tableau; although I am new to Tableau.

      Thank you.

       

      Andrew