2 Replies Latest reply on May 1, 2013 1:26 PM by Tsai Yin Yen

    Hour Display Format on the Axis

    Tsai Yin Yen

      I have a Heat Map that shows sales trend for a particular week day at a particular time of the day (see first image). Now the Hours on the x-axis is displayed in Military Time, 0 through 23. I would like to have it in standard AM/PM format. I tried following this for Custom Date Formats: http://kb.tableausoftware.com/articles/knowledgebase/formatting-numbers-and-dates, but couldn't find the Scale shelf when I click on Format for Hour (see second image). Help!

       

      timevsweekday.PNG

      hourformat.PNG