formatting Tag

We have all seen this problem in data transformation: names automatically becoming CAPITALISED NAMES or all lowercase names. If we have a list of cities consisting of only one word, it is quite straightforward to capitalise the first one using the following code: UPPER(left([Data],1)) + LOWER(right([data],LEN([data])-1)) However,...

A common irritation with tooltip formatting in Tableau is that there is no way of changing the background colour of the tooltip. So, if you have changed the background colour of your sheet to something other than white, the tooltip will be jarring against it: Using...

Recently, I needed to add a text box with an embedded URL to a client’s dashboard that read “Click to See Report.” The client, who still uses Tableau Desktop 10.5, wanted users to access an external report related to the dashboard content. However, there was...

If you have ever been in one of my Tableau training courses, you have probably heard me refer to Tableau’s format pane as “the Bermuda Triangle of Tableau” because it can be easy to get lost. What is great about the format pane is that...

Following the previous blog post, today we will be covering several ways to display negative values in tables. My go-to option is to add colour to the visualisation to highlight the values that need attention; however, there are different ways we can use colour. As in any other...

In the world of data visualisation, there is a love-hate relationship with tables, also known as crosstabs. The truth is, as with any other type of data visualisation, tables have a space in the analytical world and are customarily used or even required by some industries,...

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK


Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Geschäftsführer: Mel Stephenson

Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072