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…
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…
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- 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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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 …
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…
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…
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…
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…
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…
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.…
