Dashboard Week: Day 2

Task Dashboard Week Day 2: Battlefield Sites in the UK Data Preparation To get the data, we had to web scrape Historic UK website to get all the data for all battle fields in the UK. Webscraping the data was quite challenging because most of the battle fields were...

Dashboard Week Day 1

Task Dashboard Week Day 1: UFO Sightings Getting the data We had to web scrap the data from National UFO Reporting Center website for all years since 2008 until 2019. The process wasn’t too complicated and we were able to get the data prepared and clean by...

Tableau Quick Tip: Unfix your axes with one click

In this Tableau quick tip I am going show you how to dynamically spread your line chart. People often have a parameter that allows them to select different metric over time. Sometimes, someone hands a workbook to you where the axes are all fixed and when you start...

Step by step guide into creating a Macro

What is a Macro? A Macro is a group of tools that are grouped together into a single tool. In Alteryx there a 4 types of macros: Standard Macro: runs only once – used when the exact same process is repeatedBatch Macro: repeats the process for each incoming field into...

Calculating Minimum Dates Without Using LODs

Usually, to calculate the minimum date you would use an LOD calculation to get it – the equation would be {Fixed [Dimension] : Min([Date])} and in case you want to get the minimum date for the whole dataset (to the lowest level of detail) you would use {Min ([Date])}....