On Day 3, we had to create an App in Alteryx, and we had to pull the data from the UK Street Crimes website.

The requirements for the assignments are noted below:

Build an Alteryx App that allows the user to pick a date range and category and enter a postcode. The app must then render a Tableau KPI dashboard automatically.

I put each step in a container:

To get the postcodes, I use a postcode list file to append with our URL. In the container "Select a date" I bring a text tool to read the URL. Then, I use the formula tool which is connected to the dropdown tool, to allow the user to type a month.

The container in the middle has the download and JSON Parse to bring the data. I also added some cleaning steps.

In the container "Select a Category" I use the drop-down tool so that the user can select a category.

Lastly, the "Publish to Tableau Server" tool publishes the data source to the Tableau server.