your cart

Keep interest on top show with set action

Keep interest on top show with set action

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

How to do a simple likert scale chart

How to do a simple likert scale chart

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

How to create instructive rank button

How to create instructive rank button

    In last post, I showed how to create rank button with parameter action.         But it has some weak points:    1. If it's published on a server and need refresh extract, it will fail because button com..

How to create rank button with parameter action

How to create rank button with parameter action

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

How to let axis and tooltip show different number format

How to let axis and tooltip show different number format

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

How to add up hierachy target by using nested LOD calculation

How to add up hierachy target by using nested LOD calculation

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

How to calculate hierarchy target by using LOD calculation

How to calculate hierarchy target by using LOD calculation

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

How to add reference line to a single continuous bar?

How to add reference line to a single continuous bar?

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

How to apply table calculation filter to other sheet

How to apply table calculation filter to other sheet

      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 value in tooltip

Reference line value in tooltip

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

Blog Category