7 Replies Latest reply on Dec 3, 2012 10:27 PM by buildstar

    Visualization - Null Records in a Table

    buildstar

      Hi,

       

      I am have a database table that has date and time field.

       

      Sample :

       

      Date                                           Time         Status

      1/11/2012 12:00:00 AM           0100         Yes

      1/11/2012 12:00:00 AM           0115         P

      1/11/2012 12:00:00 AM           0130         Yes

      1/11/2012 12:00:00 AM           0145         NULL

      1/11/2012 12:00:00 AM           0200         Yes

       

      Some of the data in a day is missing and is shown in status column as 'NULL'.

       

      Now for data like this, I want to develop a good visualization how do I do this.

       

      Kindly Advise

       

      Thanks

        • 1. Re: Vizualization
          Tracy Rodgers

          Hi Gallop,

           

          Would you be able to go into a little more detail about the type of visualization you would like to see? What would you like to see happen to the NULL values--should they be in the view or should they be excluded?

           

          -Tracy

          • 2. Re: Vizualization
            buildstar

            The visual I was thinking was one where I see all the times in a day listed and highlights the NULL records with a red color and rest with green confirming  based on a status field that has "Yes" and "NULL" values.

             

            Thanks

            • 3. Re: Vizualization
              Tracy Rodgers

              Hi Gallop,

               

              I have attached a packaged workbook using the data provided. Hopefully, this is similar to what you had in mind? A calculation Date Time was created so that the date and times were combined.

               

              Hope this helps!

               

              -Tracy

              1 of 1 people found this helpful
              • 4. Re: Vizualization
                buildstar

                How do I also ensure for any new null records the color red is retained...since I find all other colors in the palette to be used for coloring new data in the bar chart. I want only red for NULL and green for processed records.

                 

                Aditionally I was thinking of orange for records that are to be processed in a day. This will happen since the time for the process is yet to be crossed. Ex: The process is to be intiated at 5:00 PM the current time is 4:45 PM. The chart will show these in Orange color and once processed as green.

                 

                So the Column for status will have another flag "P" apart from Yes and NULL that will be used to color orange to the P records(records to be processed)

                 

                Have updated the question to reflect the same

                 

                Thanks in Advance for helping me out

                • 5. Re: Vizualization
                  buildstar

                  When I use the calculated field with my data it says

                   

                  Can't add Datetime and string values. I have also tried to type convert,but nothing works.

                   

                  The field for Time in my case in the database is a varchar(10) field in SQL database.

                   

                  Please help...I am only not able to create the calculated field

                   

                  Thanks in Advance

                  • 6. Re: Vizualization
                    Alex Kerin

                    You need to change your date string into a real date, similar to this: http://community.tableau.com/thread/121847 but probably using Datetime, instead of just date

                    • 7. Re: Vizualization
                      buildstar

                      Hi Alex,

                       

                      Can you please help date is of this format :

                       

                      11/7/2012 12:00:00 AM

                       

                      It shows null values on using the formulae