4 Replies Latest reply on Oct 31, 2012 11:31 AM by Sean Mullane

    How to show 24 hrs in a chart when some hours have no data?

    Dave Greig

      Hello all,

       

      I am very new with Tableau, and I am sure this is blindingly simple, but I have searched, and read and I just can't figure it out.  I have transactional event type data (event X occurred at date/time Y).  I want to show a count of events over the 24 hours of a day, including the hours that have no corresponding data.

       

      So assume i have

       

      Event          PendDT(Date/Time)

      Foo               31/10/12 05:13

      Foo               31/10/12 06:20

      Foo               31/10/12 10:20

      Foo               31/10/12 16:40

       

      How can I force the axis of the graph to display all 24 hours of the day?  Currently I am putting HOUR(PendDT) in the Columns shelf, and SUM(Number of Records) in the Rows shelf.  I have "Show Missing Values" set for the HOUR(PendDT) which shows the hours in between the first and last event for the day, but not the missing hours at the start and end of the day.

       

      Any help is greatly appreciated.

       

      Dave