The Data School Blog

Fuzzy Match

The Fuzzy Match tool is a handy tool for matching of non-identical values. There are two different modes that the tool can perform in; Purge, which is used for a single file and compares all records and, Merge, which compares records of different sources. Steps to...

read more

How To Use Level Of Detail in Tableau: INCLUDE Function

This blog is part of the How To Use Level of Detail blog series. Today’s blog will cover the INCLUDE Level of Detail expression and function. The INCLUDE level of detail expression calculates the specified Dimension/s in your syntax in addition to the dimensions...

read more

5 Tips when Adding Colours in Tableau

Here’s a list of the top 5 tips involving adding colour to charts in Tableau. It's not about choosing the actual colours, but the process to get nice meaningful colouring in to your viz. Using these quick techniques will allow for a lot more flexibility with colouring...

read more

How To Use Level Of Detail in Tableau: LODs In General

What is a Level of Detail and how do I use them? Released in Tableau 9.0, LODs Expressions can be a daunting topic to wrap your head around - especially if you don't come from a maths or SQL background. Over the next blogs I will explain what are LODs, the difference...

read more

How to create a Custom dates in Tableau?

In this blog, I will take through how to create custom dates for yearly, monthly, quarterly, Weekly, Daily, Last month, Last week Yesterday.     Step 1 – Create Parameters for Date Range: Create a parameter with a data type of string and create list for the above...

read more

How to understand the process of creating a macro?

How to understand the process of building a macro? When I first learn macro, my biggest challenge is understanding the principle of macro. I knew that the aim of macro is to generalise a workflow so that it can work on any input as long as the input matches the input...

read more

Alteryx Macro Input Tool

Alteryx Macro is a tool which isolates a alteryx workflow and packs in one tool. By definition, a Macro Workflow is a workflow that has the flexibility to be run as a single tool within another workflow. Macros save with an *.yxmc extension. Macro Input In a normal...

read more