Direkt zum Hauptbereich

How to use polygon diagram as a filter?

One a day I got to know a gay who created a polygon diagram and use that as a filter. I was very impressed of that and wanted really to rebuild that one.
See my workbook here


So how to do that?

- First of all I cheesed a picture. I decided to take a shop square plan. Click right to the picture you cheesed and go to "Features" - "Details"

- Remember wider and higher
- In order to open this picture with tableau, I created a Google sheet with this two coordinates:

In order to open this file with tableau you should go to:
- Maps
- Background Image
- Import
- And fill details as on the example below




- Press "OK"
- Drop the X axis to column and the Y axis to the rows - and you will get this picture


 - Now I want to show some departments on this picture, like where customers can find some kitchen equipments, books, games etc. In order to highlight the area, you have to mark some points on it

- Choose any point on the picture and click right
- Add a note
- Point
- X, Y coordinates will appear on the picture. Put this coordinate in to the Google sheet. 

I highlighted some areas and created follow data set: 

In the first column you see different department. In order tableau diversify 4 points per section I added the second column where I separated this points using a trick. I classified one department in to a,b,c and d. With this data set you will be able to create a polygon diagram.

How to create a polygon diagram? 

- Drop the "Store department" to the color
- Drop the "Interlingua" (second column) to the details and you will get this graph: 



 - Put "Store department" to the filter or just use the whole sheet as a filter. It is all up to you now. 

Statement

With this graph I had some difficult. First of all it was hard-going to create separate departments because as soon as I marked some points I get a square sign of eternity. I could understand why?. 
Another challenge was to place the points exact to the area I want to highlight. You can see e.g by books or music department. I was unable to create the biggest department on the bottom part of the graph. Even if I mark more than 4 points per department. But I work on this problem. And will share the solution as soon as I get some answers. 

If you have some questions left, don't hesitate to ask me. 



Labels:

Kommentare

  1. Anonym10. April 2017 um 05:55

    Wow great google sheet add on, this tool will help me alot to generate reports. My Clients will be happy with my this effort. Thank you so much

    AntwortenLöschen
  2. Unknown4. Juli 2017 um 21:39

    Great Article. your writing style is too good, its is very very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.
    Tableau online training

    AntwortenLöschen
  3. venkat7. Juli 2017 um 01:14

    Thank you so much for sharing this worth able content with us. The concept taken here will be useful for my future programs and i will surely implement them in my study. Keep blogging article like this.
    Tableau Online Training|
    SAS Online Training |
    R Programming Online Training|

    AntwortenLöschen

Kommentar veröffentlichen

Beliebte Posts aus diesem Blog

Tableau Table Calculation Function: WINDOW - Functions

The functions which begin with „WINDOW_...“ are also common used in Tableau. Remember! The “WINDOW_” function stays for the offset in data set, so-called WINDOW. It can look like this: 1) You can see the “WINDOW” clearly because of separation line between rows: 2) You limit the “Window” by giving the information about the first and the last row number. In this case, you give Tableau the information about the data offset. Let's have a look at the example with WINDOW_SUM I created a sample with data from Superstore. I would like to have a total sum of Sales in every row. In order to do this I created a calculation field: WINDOW_SUM(SUM([Sales]), FIRST(), LAST()) With this formula I said to Tableau: “Hey Tableau, calculate the total sum of sales from the first till the last row in the data set” And this is the result: Tableau wrote the result (total sum of Sales) in every row. As another option you can cumulate the result in each row and...
Kommentar veröffentlichen
Mehr anzeigen

I want to understand RegEx! (Part2)

It is already two weeks ago since my last blog post. This two weeks I spent in Scotland. It is a very beautiful country with unforgettable landscaps. However, it is not the topic I want to talk about. In this blog I will continue the topic about the RegEx and its using in Tableau. Tableau offers you four different uses cases of RegEx: REGEXP_EXTRACT If you have data like this: aspirin_20_mg_oral_tablet and you would like to extract onliy 20_mg. What I do is I check my RegEx on this web site: http://regexr.com/ If it is ok, put this RegEx in Tableau function: REGEXP_EXTRACT([0-9][0-9]+[_]+[a-z]+) and extract all "20_mg" REGEXP_EXTRACT_NTH The same like the function before but here you can limit your extract to Nth index. Image you have data like this: aspirin_20565435 and you want to extract only "aspirin_20". So your formula should be: REGEXP_EXTRACT_NTH([a-z]+[0-9], 2) REGEXP_MATCH It is very easy one: Using REGEXP_MATCH we can find if ...
Kommentar veröffentlichen
Mehr anzeigen

Tableau's Attribute Function ATTR()

There are a lot of blog posts about this function. However, for me the best one was written by Tim Costello. You can find the post here. ATTR comes from Attribute. An attribute is a specification that defines a property of an object, element, or file. It may also refer to or set the specific value for a given instance of such. If you take a look for Tableau Online Help , then you can find this definition: Tableau computes Attribute using the following formula: IF MIN([dimension]) = MAX([dimension]) THEN MIN([dimension]) ELSE “*” END I would say this is the main logic of ATTR function. With this formula you can understand how the ATTR function works. In simple words ATTR returns a value if it is unique, else it returns * Check out this links for mor examples: Drawing with numbers Powerful &Misunderstood: Tableau's ATTR Function Using ATTR Function It would be gerate if you share your examples of using of ATTR's function. Thank you!
1 Kommentar
Mehr anzeigen