How to create Step Area Charts in Tableau?

A step area chart tells you the increase and decrease of sales compared to the previous months. For each month, the step line connects the previous sales with the current. Step 1: You need a calculated field for the sum of sales of the current month Step 2: You need a...

Alteryx Tool – Make Columns

We did predictive tools in training today with Gwilym and Bene. Instead of pivoting and joining the table we attached a Make Columns tool after the K Nearest Neighbours analysis to tidy up the data. The tool takes rows of data and arranges them into multiple columns....

Exploring the ‘show only relevant values’ option

The problem: We were working on National Student Survey data last week, most of us had filters for ‘University Group’, ‘University Name’, and ‘Subject’. The Subject filter has a very long list, the users could get confused if they were to click on one of those courses...