The feature described in this article applies in Tableau version 2020.1 and later. 

In Tableau, when designing charts, the value of a measure is subject to the context such as filters and dimensions. Sometimes we need to have values that are constant across the board. This value is constant for a given data set. When data set changes, the value changes accordingly. For example, the max date in data record timestamps. Global variables come to the rescue.

Global variables are defined out of context or regardless of context. The concept originates from general programming. We can use them anywhere we wish without concern about filters and dimensions in view (that's specifically the context of creating charts in Tableau). 

One of my favorite use of Global Variables is using them as reference, such as in reference lines.

Here is how to do it:

- Create a calculated field like [Total Sales] = {SUM(Sales)} which is the total sales in the entire data set.

- Create a parameter [Total Sales Param] that opens with the value of [Total Sales]. Make sure you select the corresponding data type such Integer, Date, String etc.

Then you can use [Total Sales Param] anywhere you wish, regardless of filters and dimensions.

More examples are as follows:

- {MAX(Date)} which is the latest timestamp in data records.

- {AVG({ FIXED [State]: SUM([Sales])})} which is average state sales

- {SUM(If State='California' THEN Sales END)} which is the total sales in California

You see that we need to create a LOD expression that generates a "single value" first. Then create a parameter that encapsulates it.

You can create any sophisticated LOD expressions if you need to. And you can create as many global variables as you wish.

In addition to being constant regardless of context, there could be advantage in performance enhancement in using global variables, because their values are pre-calculated instead of at the query time.

Enjoy Tableau. Leave comments if you have questions.

0

Add a comment

(Refresh the page if you want to view the gif image multiple times. Or go to Tableau Public and click the button at the top-right corner.)

Jake and I collaborated on a dashboard. He told me that he learnt a way to create an in-place help page in Tableau. He first saw it at a conference somewhere and couldn't recall who the speaker was. So I am blogging here about it but the credit goes to somebody else. If anyone knows who the original creator is, leave a comment below.

The key idea is to float a semi transparent worksheet on top of the dashboard, where a help text box is strategically placed on top of each chart. This way, we can explain how to view each chart and what data points are important, etc. This worksheet is collapsible by a show/hide button. 

Below I would like to show how this worksheet can be constructed.

1. Sheet with a single data mark.

  • Double click the empty space in Marks panel and add two single quotes. Make the null pill a text label. This creates a single null mark.
  • Set the view as "Entire View"

2. Create an show/hide button

  • Go to the target dashboard
  • Drag a floating vertical container to the dashboard, making it cover all the area of interest.
  • Drag the Single Null Mark sheet and drop it into the above container. Hide the sheet title.
  • Create an open/close button for the container and place the button at the top-right corner.

3. Add annotations

  • Format the sheet background opacity as 70% in the layout manager             
  • Select area annotations and place them anywhere of interest. 
  • Write help text and format it to highlight important messages.  
  • The text can serve as functional guide and/or insight guide.

Here is an example. Feel free to download the workbook and explore. Click the "i" button at the top-right corner to view the in-place help. 

0

Add a comment

Loading