3 Replies Latest reply on Nov 28, 2012 8:58 AM by Andy Piper

    Clock Visual - Color Coding

    buildstar

      The following shows the data in a database table.

       

      I want to design a clock image visual where it will show time of the day in a pie with all the divisions

       

      The total divisions would be 92 with 15 min time intervals. Also the Color coding will be Green for Yes Records, Red for NULL records and Orange for records yet to be processed in a day.

       

      So if we take for a day the records that are processed are NULL since the time has not passed by then it is to be orange, once the time completes and the status is still NULL instead of Yes then it needs to be turned red.

       

       

      Time of Day             Status

       

      0400                        Yes

      0415                        Yes

      0430                        NULL

      0445                        NULL   

      0500                        NULL

      .

      .

      .

      .

      .

      2400

       

      Thanks

        • 1. Re: Clock Visual - Color Coding
          Mark Holtz

          Hello,

          So it sounds like you could put your [Status] field in the Color section, and then add [Time of Day] to the Level of Detail.  You would then assign your 3 colors based on "Yes", "Null" and "".


          An additional piece of advice, in the database table, I'd use values for each result rather than relying on NULL and "blank" entries. That gets confusing later.  (If you can't add them in the database, you can always create a calculated field inside Tableau to do it.) 

           

          Time of Day             Status

           

          0400                        Yes

          0415                        Yes

          0430                        No

          0445                        No

          0500                        No

          .                              Not Yet Passed

          .                              Not Yet Passed

          .                              Not Yet Passed

           

          2400                         Not Yet Passed

          1 of 1 people found this helpful
          • 2. Re: Clock Visual - Color Coding
            buildstar

            Thanks but how do I show the visual of a clock..can you please help with a sample workbook.

             

            I have a pie chart...can I use a real clock image to replace the pie chart ?

            • 3. Re: Clock Visual - Color Coding
              Andy Piper

              Gallop,

               

              I worked with someone earlier this month to use a pie chart as a clock -- http://community.tableau.com/thread/121314. You may be able to glean some ideas from it to see if it'll work in your situation.

               

              Regards,


              Andy