One Click Zoom IN / OUT on the Map

Long time no write : ) The other day, I uploaded the Video-clip of one-click zoom in / out. There were unexpectedly lots of replies over weekend that includes the requests to explain the steps. After lots of trials and errors, finally achi…

Example of Water Fall Charts - 2

I wrote Water Fall Chart example yesterday. It became very long post. But actually here is much simpler way to create a Water Fall Charts. Using this way, we can create a chart on one worksheet, no need to create dashboard to combine three…

Example of Water Fall Charts -1

Temprture is getting wamer and spring is aruond the corner! I got couple of questions regarding Water Fall Chart. So I post the one exapmle here. Of course there are multiple methods to create the charts and this is not always the simplest…

God is in the details - Change the Header Position to TOP-

God is in the details- I'm not sure this idiom is undertandable in English or not, anyways, what I'd like to say is if the detail is good entire sysytem should be good. Of course this kind of idiom is not alwasy true, but I think this matc…

Common misconception - Cannot Draw Stacked Line Chart? -

This is a kind of common misconception accordin to my experience. That is "We cannot draw stacked line chart." I heard this comment from multiple people, even I did think so until recently. The reason is, when I create simple charrt with d…

It's equipped with One Check/Uncheck - Show Blank Cells in the Table

Sometimes easy view takes 100 of steps to be created. exceltableau.hatenablog.com But somtimes it's done only by one Check/Uncheck. exceltableau.hatenablog.com I got a request that he wants to show the "Blank" Cells in the table. He wanted…

Such a simple view, it required 100 steps!! - Having Multiple KPIs -

Olympic is ongoing and this is the typical timing when people in U.S. think about their nationality. It's natural for two BIG countries to compete the number of Medals, but I'm afraid that they compete each other too much seriously in ever…

Just One Check/Uncheck Changes it - Dashboard Actions -

Yeah! Ichiro hit 3000th hit in MLB !!! Ichiro Suzuki - Wikipedia, the free encyclopedia But actually nobody around me mentioned that. In U.S. people does not pay attention to baseball unless they have stadium in thier city. That's differen…

Customized Gantt Chart "Individual + Summary"

Here in Mid West/North U.S., usually we can enjoy pretty fine weather in this season. Blue Sky and NO clouds. However, becasue of too dry air, wild fire often happens. Then depend on the wind direction, smoke comes around the area and it s…

Who purchased both Product A and Product B

I got smilar questions couple of times regarding the issue I stated as title. The below link is a case "Akiyah" tried to create VIZ with 4 calculated fields with using LOD calculations. akiyah.hatenablog.com But as he staetd in the content…

Different color for multiple categories on bar charts

Hello, I want to put two categories' color into one bar cahrt. I mean taht I want to create VIZ like below. Actually there is very eay way to make this happen. We can drag two dimensions at same time into color shelf. With that, Tableau au…

Show Stacked Bar and Standard Bar Chart side by side

Today's Topic is showing differnt type of Bar chart side by side. Actullay it's easy enough, but I got some questions from my collegues. I used Tableau's sample data from the site. Sample - Superstore Sales (Excel).xls |Tableau Support Com…

What?? Why Cannot Synchronize Dual Axis

Keep talking about Dual Axis Chart We want to create the cahrt to compare compnay to company. At first, create the calculated field for comp,any A only sales. [Sales (=Company A)] sum(if[Company]="A" then [Sales] end) To create Company B's…

This not what I want : Dual Axis Graph's synchronization

I have not updated several days, let's start. We want to draw dual axis chart with abar and Graph. It's not difficult at all, but couple of TIPS. Starting from this graph. We want to show the delta percentage from last month. We use table …

Excel Cannot Achieve (probably) -- Show the difference from Previous Month.

i was asked by my friend. "Teach me the difference from Excel". ........ It's way different, anyway, try to explain with using very simple example. We use same data which were posted the otehr day. Tableau View: Excle View: To add lavel, a…

Still keep Grand Total after Filtering

Modified yesterday's graph a little bit, now it shows by Product View. Today's goal is to show "By product View" with Company Filtered. But.... Need to keep G.Total of three company as reference. Here is the end goal. You can understand th…

Display Sum on Top of Stacked Bar

Let's create a chart like this. It's pretty nice view already, but typically I got additional request. Which is "Can you add total value on top of Stack bar?" Answer is Yes, then let's try. 1st, add calculated field. [Total Sales] total(su…

Easy! One click to set appropriate "Date" Format

Let's say I want to create this table The initial view resulted in below. Tableau's default is "year". Try open "+" mark Not good... Mont honly displayed on the middle and cannot be seen. Try "Exact Date" which brings original data's forma…

You don't need to connect to datasource.

OK, 1st Tip. This might be too easy and many people might say it's well-known. Anyways. Secret Tips will be posted in the future. : ) Tableau can access to variety of data sources, which is very good. H owever, when you are working on Exce…

How did I get started using Tableau?

My name is Shin. As many people in my generation are so, I was heavy MS excel user. The skill itself is actually beneficial in my company. In the past I tried to learn MS access, but not succeeded with technical difficulties I encountered.…