tag:blogger.com,1999:blog-3998628784041768080.post3598136666079170190..comments2024-03-28T03:27:07.147+00:00Comments on VizWiz: Workout Wednesday: The State of U.S. JobsVizWizhttp://www.blogger.com/profile/11408220384219218043noreply@blogger.comBlogger26125tag:blogger.com,1999:blog-3998628784041768080.post-65535376343785079332018-02-14T02:46:08.934+00:002018-02-14T02:46:08.934+00:00Hi Andy,
This exercise is really time consuming bu...Hi Andy,<br />This exercise is really time consuming but i learned a lot from it. Thank you for that I wish I had known about these workout exercises from last year.<br /><br /> https://public.tableau.com/profile/jasleen2546#!/vizhome/WorkoutWednesday2TheStateOfU_S_Jobs/U_S_JobsAnonymoushttps://www.blogger.com/profile/02358031093781656153noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-21309546701905978252017-07-14T15:36:20.461+01:002017-07-14T15:36:20.461+01:00Hi Andy. I learned a lot from this workout. I trie...Hi Andy. I learned a lot from this workout. I tried to make my viz similar to yours but I am not able to make enough space between each chart. I used Column divider.<br /><br />https://public.tableau.com/profile/asmita.sonawale#!/vizhome/TheStateofUSjobs/TheStateofUSjobs<br /><br />Thank youAnonymoushttps://www.blogger.com/profile/07420546727208751503noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-7042322798078072322017-02-15T17:20:25.296+00:002017-02-15T17:20:25.296+00:00Hi,
Thank you Andy for this helpful workout.
I d...Hi,<br /><br />Thank you Andy for this helpful workout.<br /><br />I did a simple version using one sheet. Not exactly as yours viz....<br />https://public.tableau.com/views/TheStateofU_S_Jobs/Dashboard1?:embed=y&:display_count=yes<br /><br />RegardsAnonymoushttps://www.blogger.com/profile/15437527329681889101noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-76737655602905365452017-01-24T14:36:17.625+00:002017-01-24T14:36:17.625+00:00Good question! I'm not sure what the rationale...Good question! I'm not sure what the rationale is for when Tableau allows you to change the width. I was looking for it on something I was working on today and couldn't find it. In my example, they are tiled. Basically, I don't know when it allows or doesn't allow the edit width option. Maybe ask on Twitter??VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-87875941397460789902017-01-24T14:34:10.352+00:002017-01-24T14:34:10.352+00:00Andy - how did you set the blank boxes to 5px? I ...Andy - how did you set the blank boxes to 5px? I can see on your wb that I can right click & edit width. I only seem to be able to change width if I change blank to floating, but I can't seem to then find it when I set it back to tiled... DonnaDonna Coleshttps://www.blogger.com/profile/15669418706180350703noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-70013183415834550042017-01-24T14:06:13.666+00:002017-01-24T14:06:13.666+00:00Looks good so far Donna! This is an amazingly tedi...Looks good so far Donna! This is an amazingly tedious exercise.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-13563828579207290732017-01-24T14:04:19.605+00:002017-01-24T14:04:19.605+00:00Phew! Started this last Weds with the intention on...Phew! Started this last Weds with the intention on finishing but I'm not very good at marathons :-) So tidied up what I had that gave me the basic principals just as much for my reference<br />https://public.tableau.com/profile/donna.coles#!/vizhome/18012017-WW-StateofUSJobs/StateofUSJobs1976-2015<br />Will now have a peak at yours. Donna<br />Donna Coleshttps://www.blogger.com/profile/15669418706180350703noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-38294645930632437362017-01-24T09:41:36.925+00:002017-01-24T09:41:36.925+00:00That's because I chose to use the color to dis...That's because I chose to use the color to display the average percentage-point distance for the entire period.Anonymoushttps://www.blogger.com/profile/04825811885238143323noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-47552972033401009362017-01-24T09:34:09.885+00:002017-01-24T09:34:09.885+00:00Nice work Ulrik. The only issue is the shading doe...Nice work Ulrik. The only issue is the shading doesn't color code correctly on opposite sides of the scale.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-58757455721000781612017-01-24T09:25:51.123+00:002017-01-24T09:25:51.123+00:00Well, figured out a way of doing it - sort of:) ht...Well, figured out a way of doing it - sort of:) http://tinyurl.com/grsxt4f<br />Added a green pill for the state labels and adjusted the matrix to generate more columns than rows, thus allowing more space for the added pill on the rows. I believe the trade-off between 50 sheets and the white space is OK, but how I wish the width of continous columns/rows were adjustable. Anonymoushttps://www.blogger.com/profile/04825811885238143323noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-90001078963317754082017-01-21T14:58:13.589+00:002017-01-21T14:58:13.589+00:00Really good first effort Alex! I hope you enjoyed ...Really good first effort Alex! I hope you enjoyed this exercise. Regarding your questions...<br /><br />1. This is done with a constant reference band that goes from 0 to 10.<br />2. Download my workbook and see how I did it.<br />3. The % label is done by using the custom number formatting option. You simply enter +0.0%;-0.0% in the custom box. No calculations required.<br />4. Same as 3<br />5.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-88047249463053740822017-01-21T14:17:23.470+00:002017-01-21T14:17:23.470+00:00Here is my viz for my first workout Wednesday.
ht...Here is my viz for my first workout Wednesday. <br />https://public.tableau.com/profile/publish/StateofU_S_Jobs1976-2015/Dashboard1#!/publish-confirm<br /><br />I think for being relatively new to Tableau (4 months) I did well. I could do a few things though:<br /><br />1.- I was not able to figure out how to color the section above 0.<br />2.- I could not figure out how to color the ball at the Alexhttps://www.blogger.com/profile/04967745767282353500noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-8702394261917085402017-01-21T08:14:53.594+00:002017-01-21T08:14:53.594+00:00To make them "clickable" I have to copy/...To make them "clickable" I have to copy/paste from Word or something else that allows me to add a hyperlink to the text.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-62058371871198113102017-01-20T18:10:15.993+00:002017-01-20T18:10:15.993+00:00I was unable to set the size of the blank boxes fo...I was unable to set the size of the blank boxes for some reason. That option was not available.<br /><br />Also, for the text boxes, I am referring to the links in your footnotes. For example, you have VizWiz.com in colored text. If I click it, then it will take me to your blog. How did you do that?Mikhailhttps://www.blogger.com/profile/05642209669108259181noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-51286327444491551562017-01-20T16:12:58.200+00:002017-01-20T16:12:58.200+00:00Really like your take on this. You're running ...Really like your take on this. You're running into the same issue I did with the State labels, hence why I used a header instead.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-24239114380457770382017-01-20T15:46:55.262+00:002017-01-20T15:46:55.262+00:00Hi Andy,
Really enjoyed your viz! So downloaded it...Hi Andy,<br />Really enjoyed your viz! So downloaded it to explore and after some tinkering came up with this: <br />http://tinyurl.com/grsxt4f<br />Do you know of a way to control the state label positioning when the marks on the dual axes are already 'used'? I started moving labels manually, but that is really tedious work, and they reset way too easily... eventually, I just left them Anonymoushttps://www.blogger.com/profile/04825811885238143323noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-58704729491301408652017-01-20T14:56:12.524+00:002017-01-20T14:56:12.524+00:00Oh ok. Thank you both. Oh ok. Thank you both. Alexhttps://www.blogger.com/profile/04967745767282353500noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-13094505190790726862017-01-20T14:50:55.520+00:002017-01-20T14:50:55.520+00:00Mine are all in containers that I controlled the h...Mine are all in containers that I controlled the height of. They will space evenly automatically. I set the size of the blank boxes to 5px wide. <br /><br />I don't have any clickable text boxes. If you mean the state titles, those are simple State on the Columns shelf.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-15302234822988847652017-01-20T12:02:13.534+00:002017-01-20T12:02:13.534+00:00You were not kidding about the time involved, Andy...You were not kidding about the time involved, Andy. This definitely took some time. I got close, but cannot figure out two things. My layout containers between the rows of States would not let me adjust the height, even though the ones between the states on rows would let me adjust the width.<br /><br />Also, how did you make the text in your text boxes clickable? I searched the forums a bit, butMikhailhttps://www.blogger.com/profile/05642209669108259181noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-27419788657286937712017-01-20T09:18:00.324+00:002017-01-20T09:18:00.324+00:00There's no need to convert it to a date. Just ...There's no need to convert it to a date. Just drag it up to dimensions, change the format so there are no commas and make it continuous. Making it a date doesn't give you any more detail.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-8301625302694382102017-01-20T08:34:43.445+00:002017-01-20T08:34:43.445+00:00Hi Alex,
http://kb.tableau.com/articles/issue/all...Hi Alex,<br /><br />http://kb.tableau.com/articles/issue/all-dates-show-up-as-1905 <br /><br />This article will help you to convert the year into suitable date format.<br /><br />tarahttps://www.blogger.com/profile/01727944427546621696noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-24910304967563129162017-01-20T03:25:55.962+00:002017-01-20T03:25:55.962+00:00Hi Andy.
so, I downloaded the data and when I go...Hi Andy. <br /><br />so, I downloaded the data and when I go to Tableau to connect to the excel file, the year shows as a number. I try to convert it to date but then all fields in the date column become null when I do that. Is this part of the exercise to convert it to date or is there something I am doing wrong? or perhaps I am supposed to leave it as a number?<br />Love your website by the wayAlexhttps://www.blogger.com/profile/04967745767282353500noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-38749010026933220852017-01-19T13:30:58.562+00:002017-01-19T13:30:58.562+00:00Yes, I made it! Thank you, Andy. I happened to see...Yes, I made it! Thank you, Andy. I happened to see your blog this month and learned a lot from your blog articles and videos you shared at Youtube. I wish I could have found your blog earlier. :) Thank you.Shuhttps://www.blogger.com/profile/08203678126912919452noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-5712078846536561772017-01-19T12:30:13.096+00:002017-01-19T12:30:13.096+00:00Shu, you need to add a reference band that goes fr...Shu, you need to add a reference band that goes from 0 to 10.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-51033668446068361412017-01-19T01:31:04.985+00:002017-01-19T01:31:04.985+00:00I am sorry I couldn't make this after a long t...I am sorry I couldn't make this after a long time of struggling. :') How to only shade the area above zero in Tableau? Can anyone help? Thanks. -- "10. The area above zero should be shaded. The hex code to use is #F7E6E2 and it should be shaded from 0- to +10%."Shuhttps://www.blogger.com/profile/08203678126912919452noreply@blogger.com