1 of 1 people found this helpful
I was playing with your workbook and I didn't figure out a solution to the problem.
The principle here is that when a filter is applied, those counties/municipios that meet the criteria are displayed the rest are filtered. There are some municipalities with Null value in measure Value, such is the case for Period P01, and others.
An alternative is assign value zero to those data points with nulls in the data source.
I thought in other possible solution: replace the WMS Server that Tableau Software provides by a WMS from Brazil that provides municipality borders and their names, among other geographic layers. Maybe IBGE - Instituto Brasileiro de Geografia e Estatistica provides a web map service.
If you find a WMS Server from Brazil, you can add it by
1.- going to menu Map>Background Maps>WMS Server... A dialogue will allows you to add the URL of the WMS
2.- click on menu Map>Brackground Maps><Name of the WMS you added in point 1>
3.- Add now layers of the WMS by going to Map>Map Options...
There is other issue that I didn't mention: Tableau is not able to geocode using a secondary data source, that's why the measures Latitude and Longitude in your secondary data source Area are grayed when we select it in the view Area with actual sales
Allan Walker do you have any input to help in this case?
Thank you very much for take your time to read my post, appreciate it.
You are right when you say that "The principle here is that when a filter is applied, those counties/municipios that meet the criteria are displayed the rest are filtered. There are some municipalities with Null value in measure Value, such is the case for Period P01, and others" That is a problem.
I will try to assign value zero to my database , but I not really sure if it could work because here I have a small data set, just for matter to be easy to get help from the community.My data base is pretty big.I'll give a try and let you know.
Lets wait and see if Allan Walker have any input .
But, anyway thank you very much Ramom.
Thank you for reading my post.
I saw your images , but I'm not really sure how you did that.Can you do me a favor , please post the workbook and I can have a look how you accomplished that.
What do you mean by saying that "but they are not perfect"?
And what you see as a better alternatives?What thoughts you have in mind?
Thank you again.
I have twbx only for version 8.1 so I will post it later. As you can see left maps shows only those counties which belong to area of sales man. And that right map shows all counties where there are some numbers for sales. Those colour legends are also intresting, because those counties that have sales but don't belong to sales area are colored as no value.
Hi Ville , now I realize it, this could be very interesting to track invasion of territory and start a new discussion like, why sales man 1 is doing sales in some county that don't belong to his area and at the same time is having your own territory without sales....maybe color it in different color.
Thank you,waiting for your post with the workbook.
Hi Ville, thank you so much for the workbook and for your time to putt something like each together.
Very nice solution, that give me other perspective.
Just a look at the dashboard , you enable anyone to see where is the countys with sales, without sales and territory invasion, Fantastic.
I'm looking into it to understand it better, Thank you again
**I like more the second workbook.
Yeah the second one is better even though there are still two maps. But I think it would be better just to highlight selected counties than filter them.
Just to clarify those values in that table:
Sales per period per ....= Only values for selected sales man during selected period( selected counties)
Sales per period = Values for all sales men during selected period (selected counties)
Total = All values (selected counties)
It might be wise to put that period parameter also into Title :-)
Here is my thoughts on this:
- The mapping data seems to be insufficient. This is primarily because of the use of filled maps rather than a dual-axis polygon/point mark type map. I advise that the you use a comprehensive Brazilian municipalities polygon SHP file and corresponding cities/towns/villages point SHP file and merge these into Tableau ready format.
- Then the work of joining your sales data to the mapping data begins.
- The next issue is the underlying map. If you use a WMS server like Ramon suggests, you could use OpenStreetMap and the underlying municipalities as an additional alternative background layer and focus your analysis on the foreground layer.
- If the "area for each salesman" doesn't change - i.e. it is static, then this would form the background layer (and thus, the need for two maps is no longer required) - you could then concentrate on making a choropleth of "area of actual sales"; and with a parameter swapper, you could dynamically analyse other measures.
Obrigado pela dica.
Uso o Tableau a mais de 3 anos e é bom saber que a comunidade no Brasil está crescendo.