Topics in Vizable World 1970-01-01T00:00:00Z 149 40 57 14 0 35 7019355 Dataset limit of 65535 rows 2016-06-07T16:27:20Z 2016-06-02T10:39:49Z Paul Bystrov paul_bystrov Dear team, I have imported xls file with 68523 rows, however it seems like Visable handles only 65535 (visible in the low left corner).. Please, advise if that is the case and, if yes, are there any plans to have the limit expanded. question 4 4 1 comment 6760175 Show multiple series in time world 2016-06-02T08:28:32Z 2015-08-28T18:47:54Z Robert Kosara eagereyes_229108 I'd like to compare multiple series that live in different columns. As it is, I can only see one at a time in time world. idea 5 8 4 comment 7013852 Count Unique approximation 2016-06-01T20:37:09Z 2016-05-26T02:11:12Z Robert Rouse robert_rouse_7524411 I'm working on a data set meant specifically for Vizable. I tried a few different levels of granularity and wanted to share something I found in the process.<br /><br />The table has a unique ID for every verse in the Bible (one row for each verse). There are just over 30,000 unique values and there can be hundreds of them for each dimension value (book, writer, etc.) With this many unique values, Vizable's count unique approximation gives results that are really far off the actual number.&nbsp;<br /><br />I have decided to roll up the data to a different level for my situation but would like to know more about what's happening. problem 5 3 1 comment 6817979 Add Count Distinct aggrgation 2016-05-26T17:56:55Z 2015-10-26T17:15:37Z Robert Rouse robert_rouse_7524411 I use count distinct all the time in Tableau, and this would be a very useful thing in Vizable. It would make it so every field can be represented as a measure. For example, in the sample movies dataset it would tell me how many actors were in a film, how many genres an actor has been involved with, or other things that could only be determined by counting unique text values. idea 8 3 1 comment 7014424 Vizable 1.4 is in the App Store! 2016-05-26T16:55:25Z 2016-05-26T16:55:25Z Piper piper_7429171 The newest version of Vizable has been released! <a href="" rel="nofollow" target="_blank">Download it from the App Store.</a> With 1.4, you can save views, discover new gestures to explore your data even better, and more! <br /><br />Check out User Experience Designer Paul Lazarus's <a href="" rel="nofollow" target="_blank" title="Link http//vizabletableaucom/blogsave-your-views-come-back-to-them-anytime-in-vizable-14-48">blog post</a> about how these features came to be. You'll be impressed by his fantasy soccer acumen.<br /><br />For full update details, read&nbsp;<a href="" rel="nofollow" target="_blank">Updates by Release</a>.<br /><br /><img src="" title="Image:" /> update 0 1 1 create 7009070 Twitter Analytics Data Recipe 2016-05-19T22:03:27Z 2016-05-19T22:03:27Z Piper piper_7429171 You can explore your Twitter Analytics data in Vizable! Find out how with these easy steps. (And see this recipe in action on the <a href="" rel="nofollow">Vizable blog</a>!)<br /><br /><br /><img src="" title="Image http//onlinehelptableaucom/current/mobile/vizable/en-us/images/Recipe_TwitterAnalyticspng" /> article 0 1 1 create 7000254 PayPal Data 2016-05-11T19:01:20Z 2016-05-09T06:40:04Z Mike mike_311 Can I import PayPal data<br /><br /> Note: This conversation was created from a <a class="notranslate" href="" rel="nofollow" target="_blank">reply</a> on: <a class="notranslate" href="" rel="nofollow" target="_blank">Wells Fargo Vizable Recipe</a>. question 3 3 1 comment 7002324 PayPal Data Recipe 2016-05-11T18:22:50Z 2016-05-11T18:22:50Z Tracy Rodgers tracy_rodgers If you use PayPal to send and receive money, you should use Vizable to investigate your PayPal habits! It's easy to do in just a few steps.<br /><br /><img src="" /> article 0 1 1 create 6760002 Is mapping a future possibility? 2016-05-09T21:11:17Z 2015-08-28T16:08:13Z Jarret Sticklin jarret_sticklin Maps would be great. &nbsp;Love seeing data plotted idea 4 5 6 comment 6960751 Wells Fargo Vizable Recipe 2016-05-09T16:56:16Z 2016-03-23T16:34:34Z Piper piper_7429171 Are you spending your money wisely? Explore your Wells Fargo banking data in Vizable with these easy steps. (And see this recipe in action on the <a href="" rel="nofollow" target="_blank">Vizable blog</a>!)<br /> <br /><img src="" /> article 3 2 3 comment 6998677 Apple Health Data Recipe 2016-05-06T20:37:22Z 2016-05-06T20:37:22Z Piper piper_7429171 Did you know that you can get health data on your iPhone? Find out how to take a good look at this fitness data in Vizable with a few easy steps. (And see this recipe in action on the <a href="" rel="nofollow" target="_blank">Vizable blog</a>!)<br /><br /><img src="" /> article 0 1 1 create 6984683 Data Recipe: Square 2016-04-20T19:43:37Z 2016-04-20T19:43:37Z Marissa Michelotti marissa_michelotti Do you use Square for your business and want to take a critical look at your sales and profit? Explore your Square data in Vizable in a few quick steps. See this recipe in action on the <a href="" rel="nofollow" target="_blank" title="Link http//vizabletableaucom/bloghow-do-my-sales-and-profit-measure-up-analyzing-square-data-40">Vizable blog</a>!&nbsp;<br /><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1402466/RackMultipart20160420-85929-wiyfm3-Data_Recipe_Square_inlinejpg1461181406" /> article 0 1 1 create 6916108 Updates by release 2016-04-14T16:35:48Z 2016-02-03T17:03:31Z Vizable Docs Team vizable_team We work hard to update Vizable regularly so that you can answer questions with your data beautifully. <a href="" rel="nofollow" target="_blank" title="Link https//itunesapplecom/us/app/vizable/id1039023889mt8">Visit the App Store</a> to make sure you're working with the latest and greatest in Vizable. <br /><br /> We listen! Do you have a feature in mind that isn't in the app?&nbsp;Suggest it&nbsp;<a href="[settings][type]=idea" rel="nofollow" target="_blank" title="Link https//vizableworldtableaucom/">here</a>&nbsp;in Vizable World.<br /><br /> <b>Vizable 1.4</b><br /><i>Released May 26, 2016</i><br /><br /> In Vizable 1.4, dive deeper with features that empower your data exploration. When you create the perfect viz, save it by tapping the star icon. Then you can keep exploring without losing your gem of a view. Plus, we’ve added a sweet help menu that interactively teaches the app’s core gestures—so get ready to become a pro. And as an added bonus (we couldn’t help ourselves), check out the brand new calc, Percent of Count Unique. You asked, we delivered. Now get out there!<br /><br /> Get moving with these new features:<br /><br /> <ul><li>Saved Views: Tap the star icon in the upper right to save views.</li><li>Help menu: Tap the question mark icon in the upper right to view a list of one-step, interactive tutorials. BONUS: The “Get Started” option enables a brand new onboarding experience.</li><li>Percent of Count Unique: Tap a number column header to open the Change Field pane, and choose “% of Unique Values” under Count.</li></ul> <b>Vizable 1.3<br /></b><i>Released February 29, 2016</i><br /><br /> In Vizable 1.3, flexibility is key.&nbsp;Vizable is now smarter about treating your fields as categories or numbers. Want to change a number field to a category, or a category to a number?&nbsp;Just tap and hold that column header, then drag it where it belongs! Plus, find out how many unique values are in your data with count unique, a brand new calculation type. Don’t settle for ordinary when your data can be (count) unique. :-)<br /><br /> Get moving with these new features:<ul><li>Switch category and number fields: Tap and hold a column header, and drag it from one side of the screen to the other. (Refresher:&nbsp;categories&nbsp;live on the left;&nbsp;numbers&nbsp;live on the right.)</li><li>Count Unique: Flick up or down on a number column header to find Count Unique, or tap a number column header and choose “Count" in the Change Field pane.</li><li>Bug fixes and performance improvements: They’ll find you.</li></ul><b>Vizable 1.2<br /></b><i>Released February 3, 2016<br /></i><br />In Vizable 1.2, data analysis and sharing take center stage. Answer even more questions than before with % of total, and zero in on your discovery with easier filtering. Can’t find the filter you’re looking for? Search filters (and fields) with a swipe. Once you’re done, send your Viz file to other Vizable users to let them to explore for themselves.<br /><br />Get moving with these new features:<ul><li>Share Viz files: Tap the share icon to send a Viz file with underlying data to anyone.</li><li>Search: Pull down on a filter or field menu to reveal a search bar.</li><li>% of Total: Tap a number column header to choose between value (#) and % of total.</li><li>Control filters: Tap Add Filter, and swipe right to include only that filter (just like you would with a bar in your viz!).</li></ul><b>Vizable 1.1<br /></b>Released <i>November 2, 2015<br /></i><br />In Vizable 1.1, use Vizable the way you want to! Try Slide Over and Split View to multitask, or rotate your iPad to check out portrait view.<ul><li>Multitasking: Vizable now supports Slide Over and Split View</li><li>Portrait view: Use Vizable in the orientation that feels right</li><li>Bug fixes and performance improvements</li></ul><b>Vizable 1.0<br /></b><i>Released October 19, 2015<br /><br /></i>With Vizable, answer questions with your data as soon as you can ask them.<ul><li>Transform data into interactive graphs and charts</li><li>Pan and zoom through data stored in CSV and Excel files</li><li>See patterns and understand relationships</li><li>Analyze trends and explore data over time</li><li>Beautiful animations help you see relationships</li><li>Share your data stories</li></ul> article 2 6 2 comment 6977892 Mint Vizable Recipe 2016-04-12T23:01:00Z 2016-04-12T23:01:00Z Piper piper_7429171 Do you use Mint to track your expenses? Find out how to take a good look at your Mint data in Vizable with these easy steps. (And see this recipe in action on the <a href="" rel="nofollow">Vizable blog</a>!)<br /><br /><br /><img src="" title="Image:" /> question 0 1 1 create 6974657 Using the Tableau Reshaper Tool To Format Your Data for Vizable 2016-04-11T17:04:36Z 2016-04-08T23:53:13Z Lari McEdward lari_mcedward In the #NationalSiblingsDay <a href="" rel="nofollow" target="_blank">blog</a> post, I used an amazing tool to get my data into shape (literally!). It’s called the <a href="" rel="nofollow" target="_blank" title="Link http//kbtableaucom/articles/knowledgebase/addin-reshaping-data-excel">Tableau Add-in for reshaping data in Excel</a>, and it can help format data for Vizable, too.<br /><br />We could simply build our data template the way we want our data to wind up. That’s an option. But the data entry is much less friendly that way. It would look like this:<br /><br /><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1396072/11350-1mftjgh_inlinePNG1460159158" /> <br />Wait, what? Where do I put my rating? Who am I supposed to be rating?<br /><br />The “correct” format isn’t nearly as readable to a real person as this:<br /><br /> <img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1396073/13698-elqwv_inlinepng1460159174" /><br /><br />Here, I know that I either fill out column D or E, and I simply give a rating for each person for each trait. Much simpler.<br /><br />But some of the questions asked in the blog post work best when the data has a single row for a single piece of information. That’s where the reshaper comes in. With the reshaper, we can enter our data in a way that makes sense, then give it to Vizable the way Vizable prefers. I call that a win-win!<br /><br />1. Download and install the plugin. Everything you need is available <a href="" rel="nofollow" target="_blank">here</a>, on Tableau’s website.<br /><br />2. Enter your data in the template.<br /><br /><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1396077/11352-297gvn_inlinePNG1460159281" /><br /><br /> 3. Use your mouse to click and drag to highlight the two columns of numbers—not the columns themselves, just the numbers. All the way to the bottom.<br /><br /><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1396079/13698-k3k74_inlinepng1460159344" /><br /><br />4. Without clicking anywhere else and losing that selection, click the Tableau tab in Excel (my screenshots are for Excel 2013, but the process is pretty similar for other versions).<br /><br /><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1396083/13698-miv0gd_inlinepng1460159375" /><br /><br />5. Click “Reshape data”.<br /><br /><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1396085/13698-aye0co_inlinepng1460159393" /><br /><br />6. A dialog box will pop up. Click OK.<br /><br /><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1396087/11348-1wszyxe_inlinepng1460159409" /><br /><br />That’s it! Your data is reformatted! Excel made a separate tab for the newly restructured data—you can simply copy and paste it into a new workbook, or move the new tab to be the first one (leftmost) and Vizable will automatically read that data.<br /><br />There is just one more step: rename the new columns. The reshaper took those two columns “Person A’s Rating” and “Person B’s Rating” and instead made a column for who did the rating and a new column for the ratings themselves.<br /><br />7. Rename “Col4” to “Person Rating” and “Col5” to “Rating”.<br /><br /><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1396090/13698-16v430a_inlinepng1460159549" /><br /><i><br />Now</i> you’re done!<br /><br /><b>So what happened there?</b> Now you have <i>tall</i> data—you’ve doubled the number of rows. Instead of having a single row for person A for a given trait, and a column for each person’s rating, you have <i>two</i> rows for person A for that same trait—one row for their self-rating, and one row for the other person’s rating. Each row is a fully unique piece of data.<br /><br />Now you have both the four-row-one-column-for-ratings-classically-formatted data and the two-column-easier-to-enter-data-into data mentioned in the blog post. Open both in Vizable and play with which style is easier for different questions. article 2 2 2 comment