If we have many records to be shown on a screen, we always want to see our interested record can be on top. We can use set action to achieve this. We use "Sample - Superstore" data to build a dashboard with map and deta..
There are many articles about to build a beautiful likert scale chart, such as: How to Visualize Sentiment and Inclination. In this article, the author use table calculation and gantt chart to get it. Some person may not be famila..
Rank is a very common index in business world. You may need see salesrep rank in different department, or product sales rank in different state. But some department or state has more salesrep or product than others. If you le..
Tooltip is a very important function to let end user know more detail of a chart and keep chart clean. So we need simpler number format in chart and detailed number format in tooltip. For example, in axis we wish nu..
In previous blog, I talked about "How to calculate hierarchy target by using LOD calculation". Today I will talk a little deeper and it can be expand to other place. Suppose your boss setted a target for category for each mo..
In business, some company will set target to low level, then the upper level target is summed up by lower level. Such as dealer -- store -- rep. When we calculate for rep target, no issue. But when we need calculate for dealer or store..
In a real business world, sometimes you don't have a perfect data, but your boss may ask for a perfect format. I recently encounter this situation. Some categories only have data in recent years. But people want them show all years as ..
A dimension or measure filter can use in different sheet which give convenience to tableu end user by applying option. But sometimes user want filter based on a table calculation such as only show % of total more th..
Reference line is very useful when you need to compare, but sometimes more reference line will make chart too crowded. In this situation, you may need the value of reference line show in tooltip. Let's see how to show the right value.&..