Dashboard week Day 3: UK Crime Rate API

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.

Author:
Islande Derazin
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab