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
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
PM, I am not sure I understand what you mean by "label version". In the enhanced template you are referring to, the textboxes are labeled with the absolute value, the percentages or both, depending on what the user selected with the radio buttons. Maybe you want to add the category names to the labels? If so, I would recommend against this idea, because the category names are already shown in the row and column headers (so the label would just be redundant information) and – even more important – this would clutter the display. See also my reply to Erna above.
1 reply
PM, this is not exactly how a Marimekko is defined, but it is possible, of course. You will need another cell range with the values defining the widths of the columns and a few changes in the code to use those values in the calculations of the widths of the textboxes: another named range, one or two more variables, a few additional lines and a few changes in the calculations of the columns widths should do the job. The VBA project is not password protected, so feel free to change it as you like.
1 reply
PM, the width of the column is relative to the sum of this column divided by the grand total. Have a look at the original file I posted for download: the sum of the first column is 553. Grand total is 4,552. The width of the first column makes 12.1% of the total width of all columns. The sum of the second column (477) divided by the grand total makes 10.5%. Thus, the width of the second column makes 10.5% of the total width of the marimekko, and so forth. If all your columns have a width of 8.3%, I'd assume you have 12 columns and each column has the same column sum. Maybe the data points by column in your data are percentages and each column adds up to 100%?
1 reply
PM, maybe I am misunderstanding your question, but the column widths are already adjusted according to the total value of each column.
1 reply
Sandip, I created the texts with the triangles in a text editor (e.g. Word), copied the text and inserted it into the parameter list in Tableau. It is important to use a symbol from one of the standard font types (like Arial), not from a special font like Symbol or Wingdings 3.
Toggle Commented Apr 6, 2016 on Dynamic Sorting with Tableau at Clearly and Simply
1 reply
Mauricio, you have to take care of the numbering convention in the first column: the number of the topic followed by a period and the number of the checklist item. The code uses this first column to identify what is a topic and what is an item and which item belongs to which topic.
1 reply