Task: Take crime data from https://data.police.uk/data/ and build an Alteryx app that allows a user to select a location on a map, a crime type, and a range of dates to filter the data by. Publish the data source to tableau server and connect a ‘KPI’ dashboard to this data source.
Plan: Use wildcard union to input all of the files from the link. Create Points from the longitude and latitude columns in the crime data. Input a map, add a map interface tool to allow a user to select a point on the map. Then I appended the selected point value onto the original data source. Next, I used the distance tool to calculate the distance between the selected point and the location of the crime, then filter to within 1 mile. Using more interface tools, allow the user to select a time frame (I used 2 date interface tools, one for start date and one for end date) and a crime category (a dropdown interface tool). Download the 'output to tableau tool' and configure it to allow me to publish as a data source to tableau server. (Make sure you download the correct version of the output tool for the version of Alteryx that you have).
My app:
My Dashboard:
