-
1. Re: Vizualization
Tracy RodgersNov 15, 2012 10:45 AM (in response to buildstar)
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 Nov 17, 2012 3:03 AM (in response to Tracy Rodgers)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 RodgersNov 16, 2012 8:32 AM (in response to buildstar)
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
-
viz--with red null.twbx.zip 10.6 KB
-
-
4. Re: Vizualization
buildstar Nov 21, 2012 12:18 AM (in response to Tracy Rodgers)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 Dec 3, 2012 5:33 AM (in response to Tracy Rodgers)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 Dec 3, 2012 6:10 AM (in response to buildstar)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 Dec 3, 2012 10:27 PM (in response to Alex Kerin)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