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
Tim, I just double checked. The link is still working and the file is not corrupt. It is a huge workbook (45 MB, more than 400,000 data rows), so it takes a while to open it, but it is not corrupt.
1 reply
Aaron, you would call the status bar before or after each call of one of your subs. You would need to enhance the sub a little bit and not only pass the total number of iterations, but also the current iteration as a parameter and delete the For Next loop inside the code of the progress bar sub. As you mentioned, some subs will probably take longer than others, so displaying a percentage value wouldn't make much sense. Instead, you could display something like "step 1", "step 2", etc. Another idea would be to have two progress indicators: the first showing the step (i.e. which subroutine is running at the moment) and the second one displaying the percentage of completion inside this subroutine (starting by 0 again when calling the next routine).
1 reply
Alyssa, please have a look at my reply to John’s question on January 13, 2016 at 5:41 PM.
1 reply
Way, here are the main steps: 1. Adjust the data to have only data from 2011 to 2017 2. Make sure the combinations in column ID (Country/Year) on the data sheet are adjusted, too 3. Adjust the values of myMin (=2011) and myMax (=2017) on the control work-sheet 4. Set the value of myCurrentValue to 2011 (as a starting point) 5. Rename the rectangles on the dashboard: Rectangle_2013 becomes Rectangle_2017, Rectangle_2012 becomes Rectangle_2016 and so forth 6. Delete all not necessary rectangles on the dashboard (Rectangle_2006 and earlier) 7. Adjust the axis labels of the rectangles 8. Resize / reposition the rectangles as you like This should do the job.
1 reply
Prolay, in the data tab right click on the dimension, select Default Properties and Sort, activate Manual and use the Up and Down buttons to define your prefered sort order.
Toggle Commented May 17, 2018 on Dynamic Sorting with Tableau at Clearly and Simply
1 reply
Praveen, I think your problem is less the task of building a dynamic hierarchy as described above, but rather the question how to detect the level of hierarchy for each employee in your data source. I found this thread on the Tableau forums where Tableau Zen Master Jonathan Drummey apparently provides an SQL based solution for the problem: https://community.tableau.com/thread/146224
1 reply
SAhuja, simply drag the measure which represents the weight between the connections to the Color Shelf or (maybe even better) to the Size Shelf of the Line Chart.
1 reply
Helen, I can't reproduce your issue. I just tried (Tableau 10.5 and 2 Excel files) and it works like a charm. What version of Tableau are you using and what are your data sources?
1 reply
Ryan, have a look at this workbook and its code: Download Customizable Tooltips on Excel Charts 2 Sheets (81.9K)
1 reply
Chris, if you only need a world map in Excel, have a look at this post: Choropleth Maps with Excel If you need the map created from polygons, have a look at this link: Download create_shapes_from_polygons_world (45 MB) This is the map I created from polygons using the tool described above.
1 reply
Ashish, I am sorry, but I do not know of a way to set up action filters with an OR condition. This doesn't mean it impossible, but it is above my head. Maybe you want to post your question in the Tableau forums? If you don't get an answer there, it probably isn't possible...
Toggle Commented Mar 26, 2018 on The Power of Tableau Actions at Clearly and Simply
1 reply
Jennifer, I know. there are some countries missing on the map. I do not have the time to update the map, but you could do this on your own with the help of one of the following posts: Build your own Choropleth Maps with Ex-cel or Create Excel Choropleth Maps from Shape Files Regarding the ISO codes: the abbreviation column on the data worksheet does not play a role in the technique of coloring the countries on the map. If you need to change the values in this column, you can do this right away and the code will still work. Having said that, do not change the values on the control worksheet, because this is the mapping of the named ranges on the data worksheet to the shapes of the map.
Toggle Commented Mar 23, 2018 on Choropleth Maps with Excel at Clearly and Simply
1 reply
Jeff, line charts have minimum and maximum scales on the category axis, too, but only if the data on the X-axis is numerical or a date/time and this seems to be not the case in your set-up. It won't work if you have a categorical dimension on the X-axis. If you are trying to visualize the development of blood pressure, date/time should be on the x-axis and blood pressure on the y-axis. The chart would then show the development of blood pressure over time and the information about the arm should be shown in the tooltip. This would work with the technique I have shown above.
1 reply
tomek, I do not have an Excel 2007 installation available anymore and therefore cannot reproduce your issues. I am sorry, but I can’t help you here.
1 reply
Mike, I would assume you have a sub, a function, variable or a constant defined somewhere in your own code with the name "Format". This declaration is in conflict with the name of the VBA function "Format" I am using in the Message Box. Simply rename the sub or variable you named "Format" and it should work.
1 reply
Juan, have a look at this post: Create Excel Choropleth Maps from Shape Files The article describes how to create Excel Choropleth Maps from ESRI Shape Files and comes with download links for Choropleth Maps of Germany by zipcode.
1 reply
ana, looks as if there are some references to libraries missing. Go to the VBE (ALT-F11), click on Tools and References and make sure Microsoft Excel 16.0 Object Library and Microsoft Office 16.0 Library are checked. If you are running Office 2013, activate the corresponding 2013 libraries.
1 reply
Yanna, try this: Sub RunTest() Dim datStartTime As Date Dim lngCount As Long datStartTime = Now() For lngCount = 1 To 10000 Application.StatusBar = _ "Iteration: " & lngCount & _ " Elapsed time: " & _ Format(Now() - datStartTime, "hh:mm:ss") DoEvents Next lngCount Application.StatusBar = Empty End Sub
1 reply
Bjoern, I am not sure what you mean by "sub agenda", but if you want to export to a different calendar than the default one, please refer to my reply to Aileen's comment on July, 5 2010.
1 reply
Leo, no worries, you have been as clear as possible. I do not know of a built-in Tableau feature which would accomplish what you are trying to do. Doesn’t mean there is no such feature, I just do not know it. All I can think of is the following work-around: Define a URL action for all other views of your dashboard (except the one that should show the image in the Web Page object), select "Run action on Hover" and about:blank as the URL. This way, the Web Page object on your dashboard will at least be cleared, if the user hovers over a data point of one of the other views on your dashboard. This will not be the case, if she/he hovers over a filter, a legend, an image, the title, etc., but at least if the mouse is moved to another view. Agreed, not really elegant, but it does the job. I hope this helps.
1 reply
Brenda, I just sent it again. Please check your inbox and maybe also your spam folder.
1 reply
Xavier, have a look at this workbook: Download Tooltips on Excel Charts – Hidden Rows (64K)
1 reply
Kevin, try this piece of code: Sub Export_Selection_To_OL_Appointments() Dim myTask As Task Dim myDelegate As Object Dim myItem As Object Dim intResources As Integer On Error Resume Next Set myOlApp = CreateObject("Outlook.Application") For Each myTask In ActiveSelection.Tasks Set myItem = myOlApp.CreateItem(1) myItem.Assign With myItem For intResources = 1 To myTask.Resources.Count Set myDelegate = myItem.Recipients.Add(myTask.Resources(intResources).EMailAddress) myDelegate.Resolve Next intResources .Start = myTask.Start .End = myTask.Finish .Subject = myTask.Name & " (Project Task)" .Location = "tbd" .Categories = myTask.Project .Body = myTask.Notes .Display .Send End With Next myTask End Sub
1 reply
Brenda, I already sent you the solution by email yesterday.
1 reply
Kevin, here is the code which sends an outlook invitation to all resources assigned to the task (provided the email-addresses of the resources are defined in Microsoft Project). Make sure to set the reference to the Microsoft Project library in the VBE. Sub Export_Selection_To_OL_Appointments() Dim myTask As Task Dim myDelegate As Object Dim myItem As Outlook.AppointmentItem On Error Resume Next Set myOlApp = CreateObject("Outlook.Application") For Each myTask In ActiveSelection.Tasks Set myItem = myOlApp.CreateItem(olAppointmentItem) myItem.Assign With myItem Set myDelegate = myItem.Recipients.Add(myTask.Resources(1).EMailAddress) myDelegate.Resolve .Start = myTask.Start .End = myTask.Finish .Subject = myTask.Name & " (Project Task)" .Location = "tbd" .Categories = myTask.Project .Body = myTask.Notes .Display .Send End With Next myTask End Sub
1 reply