tag:blogger.com,1999:blog-3998628784041768080.post7627826924730927060..comments2024-03-28T03:27:07.147+00:00Comments on VizWiz: Workout Wednesday: World Series Game 7 - Pitch-By-PitchVizWizhttp://www.blogger.com/profile/11408220384219218043noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-3998628784041768080.post-77385265384724561562017-03-13T15:43:58.221+00:002017-03-13T15:43:58.221+00:00Robert, I think the root of your problem was that ...Robert, I think the root of your problem was that you had to create this complex table calc just to make your ID field unique. If you download my workbook, you'll see that I created a calculation that makes it unique through a bit of simple multiplication. I then made this field continuous on the columns.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-75892244048811228362017-03-08T22:23:39.977+00:002017-03-08T22:23:39.977+00:00Correction. I did just get it to work, though I&#...Correction. I did just get it to work, though I'm not entirely sure why it worked. Here's what I did:<br />1) Put the "Id" variable as a discrete attribute for the columns<br />2) Add a rank table calculation for "Id"<br />3) Edit the table calculation to:<br /> - rank ascending<br /> - use competition method<br /> - compute using specific dimensions (selected all Anonymoushttps://www.blogger.com/profile/17670354710969847181noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-7837847508072055802017-03-08T22:02:10.854+00:002017-03-08T22:02:10.854+00:00Thanks, I'm just not getting it. What I'v...Thanks, I'm just not getting it. What I've got thus far is a calculation that essentially resets the "Id" column to 0 for the start of each inning, ultimately providing unique values for each pitch in each inning. However, I'm having a tough time when I try to rank anything. I've also tried just ranking on the raw "Id" column by inning, as those are all Anonymoushttps://www.blogger.com/profile/17670354710969847181noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-91868060100001496882017-03-08T20:42:51.182+00:002017-03-08T20:42:51.182+00:00Try putting AVG([Number of Records]) on the Size s...Try putting AVG([Number of Records]) on the Size shelf. I also created a calculation to give me the unique pitch per inning. Think about how you can rank them to get them in order.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-27177744769263430862017-03-08T19:55:18.904+00:002017-03-08T19:55:18.904+00:00I'm having a hard time getting the bars to be ...I'm having a hard time getting the bars to be evenly spaced. I'm trying to use the "Id" column, but the values in that column are not consistently spaced by 1. Is there another column that actually tracks the number of pitches accurately that I've missed, or how can we go about making such a column?Anonymoushttps://www.blogger.com/profile/17670354710969847181noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-84858055303573572962017-03-03T21:46:46.333+00:002017-03-03T21:46:46.333+00:00One slight variation I would suggest would be on t...One slight variation I would suggest would be on the 'Count' tooltip. The way the data reads it is technically the count before the pitch actually occurred. Most people would typically want to see the count after the pitch. The formula below would take care of that. Thanks for all your work on these. I am using them as a training tool for my team.<br /><br />if [Outcome Type] = 'Ball&Anonymoushttps://www.blogger.com/profile/09712373515923902353noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-44332517519539188032017-03-03T21:42:00.355+00:002017-03-03T21:42:00.355+00:00It looks like you have a shape set called 'Ico...It looks like you have a shape set called 'Icons' that I don't see by default. Is there somewhere we can download that from?Anonymoushttps://www.blogger.com/profile/09712373515923902353noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-18561510288974625572017-03-02T10:37:03.455+00:002017-03-02T10:37:03.455+00:00Thanks Andy. I was referring on how to start my lo...Thanks Andy. I was referring on how to start my lollipops from the beginning of each inning (row), I already figured it out. The shapes are driving me crazy I can't find how to hide them. It's 2:35am in this part of the world so I'm calling it off, tomorrow I'll give it another try. See ya!Finiohttps://www.blogger.com/profile/11830571011297535286noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-69481980462925323182017-03-02T06:19:38.332+00:002017-03-02T06:19:38.332+00:00Finio, you're kind of answering your own quest...Finio, you're kind of answering your own question. To make them go opposite directions, the values have to go in opposite directions. There are a few different ways to do that. <br /><br />As for the shapes, try to right click on the ones you don't want on the shapes shelf. There's an option there you might not know about. VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-2096773313789508862017-03-02T04:00:46.655+00:002017-03-02T04:00:46.655+00:00I'm stuck on how to get them to start from &qu...I'm stuck on how to get them to start from "zero" on the vertical axis in each inning and how to "hide" Balls and Strikes in the shapes field.Finiohttps://www.blogger.com/profile/11830571011297535286noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-91594517630015192312017-03-01T23:56:09.941+00:002017-03-01T23:56:09.941+00:00Well that was a fun ten minutes. I thought I was g...Well that was a fun ten minutes. I thought I was going crazy. Damn aliases!<br />Right, now I can move forward... Andyhttps://www.blogger.com/profile/01825797862320912474noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-43671015048308161932017-03-01T17:46:18.025+00:002017-03-01T17:46:18.025+00:00Thank you for your prompt reply. Sir, I can downlo...Thank you for your prompt reply. Sir, I can download the workbook. But as you know we can not open a packaged workbook from public version. So, I'll download the excel file and union all the sheets in tableau. Thank again.Anonymoushttps://www.blogger.com/profile/07882632958457744866noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-62355961628597743712017-03-01T17:15:30.325+00:002017-03-01T17:15:30.325+00:00You can get it here (https://1drv.ms/x/s!AhZVJtXF2...You can get it here (https://1drv.ms/x/s!AhZVJtXF2-tD1it_AjTT8cHy9ZBQ) but you will need to union all of the files and remove a bunch of fields. I'd recommend you download my workbook, delete the sheet I created, delete any calc fields I created, then start. It'd be like a blank workbook then.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-7437801449879465692017-03-01T16:43:04.907+00:002017-03-01T16:43:04.907+00:00Sir, I'm using public version. Is there any pr...Sir, I'm using public version. Is there any provision to get the data in excel version? Thanks in advanced. <br /><br />MahfoojAnonymoushttps://www.blogger.com/profile/07882632958457744866noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-75432693180128795082017-03-01T15:36:05.109+00:002017-03-01T15:36:05.109+00:00The data provided doesn't include which bases ...The data provided doesn't include which bases are occupied per pitch. As for the strikeouts, yes, I could have included that, but it would make the visual too cluttered in my opinion. Also, there's no empirical evidence that a strikeout has any more significance on the outcome of a game than any other out. In fact, I would argue a 1-pitch out is way more important because it saves the VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-56233527355398057692017-03-01T14:20:54.499+00:002017-03-01T14:20:54.499+00:00This is a nice, compact summary graphic. I have on...This is a nice, compact summary graphic. I have one suggestion that would aid interpretability: Add 'out' marks for strikeouts. It's hard to pick out where strikeouts occur, and they can be very significant! Another idea, that may be too much information in one graphic: show which bases are occupied for each pitch.Brian Crounsehttps://www.blogger.com/profile/00433471861832551929noreply@blogger.com