your cart

Blog

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

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

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

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

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

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

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

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

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

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

Read more
How to drill down on map

How to drill down on map

      Following last post, in this post we will see how to drill down from customer to customer order. If you have 3 level to drill down, just need add another level filter, the logic is same.      We still use same data as be....

Read more
Jet on map

Jet on map

    Suppose you work for a delivery compay and you need analyse order in a week. Let's take one address for example. Below are my data:   OrderIDOrder DateCustomerIDCustomer NamePriceAddressLatitudeLongitudeD0016/23/2019C001Mike221050 R....

Read more