This is Robert's Typepad Profile.
Join Typepad and start following Robert's activity
Join Now!
Already a member? Sign In
Robert
Munich, Germany
Interests: new media, optimization, strategy, forecasting, business intelligence, project management, financial planning, business plans, telecommunications, revenue management, business performance management, simulation, pricing, intelligent data analysis, business cases, revenue assurance, cable operator, operations research
Recent Activity
Phil, have a look at this workbook: Download 05/06 collapse checked topic stamped (33.9K)
1 reply
Nilrey Jim, I created the dashboard with Tableau Desktop and uploaded it to my Tableau Public account. Tableau Public provides a HTML code snippet which you can directly copy and paste it into your blog or website. Have a look at the dashboard above. At the bottom right of the dashboard you see a little share icon. If you click on this icon, you can copy the link and/or the HTML code. I hope this answers your question.
Toggle Commented 3 days ago on Word Clouds with Tableau at Clearly and Simply
1 reply
Adam, you can, but you do not necessarily have to change the code. The technique uses the named range "myData" to define the range of the table which shall be sorted. You can replace the fixed range of this name by a formula making it dynamic, e.g. using a combination of OFFSET and COUNTA.
1 reply
Evelyn, after you added new topics and items at the end of the checklist, you have to expand the named range myCheckList to make sure this name covers your entire list. Here is the step-by-step: 1. Make sure your new topics and items follow the required numbering convention in the first column, i.e. a topic has a unique number (e.g. 6), the items the number of the topic followed by a period followed by another number (e.g. 6.1, 6.2, 6.3, etc.). This is crucial, because the first number is used to detect which item belongs to which topic and the period is used to distinguish between topics and items. 2. Go to the Name Manager (on the FORMULA tab of the ribbon or by pressing CTRL-F3) 3. In the upcoming Window click on myCheckList 4. Click on the range selection icon at bottom right of the window, select the entire range of your checklist and press Enter 5. Click on the Close button of the Name Manager and confirm your changes in the next window by clicking on Yes This should do the job.
1 reply
abilashini, you can use the example workbook provided in the article right away. Just follow the steps described in the section "The Preparation of the Workbook". The template requires a dimension to be used as a filter. I suggest you define one of your dimensions as the filter and set the filter to "All". Another option would be to change the VBA code and take out all lines of code managing the filtering.
1 reply
Camille, the maps are a collection of freeform shapes and you cannot assign a text to freeform shapes. Hence, if you want to display additional information, you have to add textboxes, position them where you want them to have and finally write some additional VBA code to update the text in the textboxes. The latter is not necessary for the names of the regions, but it is necessary for the textbox displaying the value (to be updated after the data changed or another measure is selected). Having said that, I would not recommend this, because it will clutter the display and does not add much value. I would rather use tooltips on the map showing the region names and values when hovering over a region (see the follow-up article to this post) or add a sorted bar chart next to the map visualizing the regions and their values.
1 reply
Laurence, I am sorry, but I do not know a site where you can download all historical results of the FIFA World Cups and the UEFA Euro Championships in one go. As mentioned above, I compiled all the data from the FIFA website and if you need the European Championship data, I am sure you will find the data on the website of the UEFA. You have to either compile the data manually or try to use a web scraping tool like importio.
1 reply
Peeush, activating the chart means that you have to select the chart by clicking on it.
1 reply
Alexandra, the additional tab and icons on the ribbon are not created by the VBA code. You can change the ribbon in Excel with the freely available Custom UI Editor. Have a look here for more details: http://www.rondebruin.nl/win/s2/win001.htm
1 reply
Robert, if the sort order of the shapes isn't the problem, you may want to send me your workbook by email (email-address at the top of the blog) and I will have a look. As per your second question: unfortunately, no, I do not have a world map version with filters and tooltips, but it shouldn't be too difficult to replace the US map by a world map in the template I provided. Not much more than an hour or two, I think.
1 reply
Rachel, every time value in Excel has a date part, too. If you only enter the time in Excel, e.g. 01:00:00, and format the cell with the custom number format "mm/dd/yyyy hh:mm" (i.e. to show the date and the time, you will see this: 1/0/1900 1:10:00 AM i.e. day zero in Excel's calendar or the day before the first of January 1900. Same thing in Tableau, i.e. in Tableau a time field always has a date part, too. In your case, all times belong to day zero in Tableau’s calendar. If you want to combine the date and time field, you do not have to do this in Excel. You can also do this in Tableau by creating a Calculated Field which is simply adding the time to the date. Let's say [myDate] is the date dimension and [myTime] the time dimension in your Excel data. Create a Calculated Field in Tableau, name it e.g. DateAndTime and enter this calculation: [myDate]+[myTime] This should do the trick.
1 reply
Robert, you probably have other objects on your sheet than the map shapes, like the combo boxes in my original workbook. If so, you have to make sure those are the last shapes on the worksheet. Go to the Selection Pane (ALT-F10) and make sure all shapes not belonging to the map (i.e. not supposed to be colored by the algorithm) are at the top of the Selection Pane, which shows the shapes in reverse order. You can use the arrows or drag and drop them in the Selection Pane. After you did, simply rerun the Recreate Shape Index sub (button on the control worksheet) and it should be working.
1 reply
Image
How to use R, a Tableau connection to R and Calculated Fields to store and load the underlying data of a defined Tableau View in a Database or Text File (part 2 of 2) Continue reading
Posted Jun 9, 2016 at Clearly and Simply
Image
How to use R, a Tableau connection to R and Calculated Fields to store and load the underlying data of a defined Tableau View in a Database or Text File (part 1 of 2) Continue reading
Posted Jun 8, 2016 at Clearly and Simply
Nilesh, I think this Tableau Forum thread should point you into the right direction: https://community.tableau.com/thread/119148
1 reply
Luis, since version 2007, Microsoft Excel files are actually zipped folders including XML and other files. If your Internet browser opens Windows Explorer when clicking on the download link, right click on the link instead and select "Save Target As" to download. If you are using Microsoft's Internet Explorer, the IE will change the file extension from .xlsm to .zip during download. Simply change the file extension back to .xlsm and you can open the workbook with Excel by double clicking on the file.
1 reply
Alok, not with the basic implementation posted in the article above. However, it is possible of course. You would have to adjust / enhance the VBA code to make sure only unique texts are displayed. The VBA project in the workbook posted for download has no password protection, so please feel free to adjust the code as you like.
1 reply
Kristie, I am sorry, but I do not understand your question. Can you please describe your problem / requirement in more detail or post an example workbook somewhere?
1 reply
Ankamma, you can combine measures and dimensions in dynamic sorting by following the steps 3 and 4 in the section "the enhanced version" of the article above.
Toggle Commented May 17, 2016 on Dynamic Sorting with Tableau at Clearly and Simply
1 reply
jcaron, what is the problem with downloading the workbook?
Toggle Commented May 12, 2016 on Cartograms in Microsoft Excel at Clearly and Simply
1 reply
Philipp, unfortunately, I can't tell you why the appointments in Outlook do not show up after you dragged and dropped them into the other calendar. As you said, maybe an Outlook issue. Truth be told, I am everything else than an Outlook expert. Having said that, maybe you can avoid the workaround. The question to export the tasks to another calendar has already been raised and answered. Please search for my conversation with Aileen back in July 2010 in the avalanche of comments above. There is a little code snippet provided which allows to specify the calendar the tasks shall be exported to.
1 reply
Flo, the code uses Windows functions for the timer and this will definitely not work on a Mac. Go to the code and delete the module modTiming and in the module modMain the sub EHTimer and all calls of EHTimer. This should at least eliminate this restriction. No guarantee it will fix all problems, though. I do not have a Mac available, so I can't test this.
1 reply
Nikita, I do not know what Amrit's problem was, but I do not think there is any difference between using the camera tool and a shape linked to a cell range or named range.
1 reply
Nikita, shpClickBox isn't supposed to show anything. It is formatted to be invisible and used to handle the web actions. shpToolTip is the shape which shows the tooltips. Are you sure you have the name of the shape correct and the shape is linked to the cell range with the content? If you want to, you can send me your workbook by email and I will have a look.
1 reply
Catherine, it is a very simple code snippet and it works well on my PC, so I assume this might be a Mac problem. I can't reproduce the issue because I do not have a Mac available. My wild guess would be that the .GetOpenFileName statement is causing problems, because of different file type definitions or the different path separators (":" instead of "\") on a Mac. You could try to call .GetOpenFileName without parameters (i.e. simply delete everything in parentheses behind the statement) and see if it works then. Just a wild guess, though. I am poking around in the dark here. Sorry.
1 reply