Filtering with multiple datasources - Part 1

by Simona Loffredo

I find quite tricky using filters with blended data sources, so I have decided to write two blog posts on this subject.

The first one will be on how to use a map as filter for charts coming from a different datasource, while the second one will be on how to let a filter work on different charts creating a parameter.

HOW TO USE A MAP AS A FILTER IF YOU HAVE MULTIPLE DATA SOURCES?

Consider Sample Superstore and Superstore Sales.

STEP 1

  • Connect to Sample Superstore
  • Put Latitude and Longitude in Rows and Columns and Country and States in Detailmap

STEP 2

  • Connect to a second data source, Superstore Sales
  • Blend them by State (Sample Superstore as primary datasource and Superstore Sales as secondary)

STEP 3

  • Build a view using the second data source, for example dragging sum(sales) and customer name in the view building a bar chart

chart

STEP 4

  • Build a dashboard with the two worksheets in it

dashboard

  • Create an action filter in order to use the map as a filter for the bar chart (dashboard > actions > add action > filter) and set up the following settings:

action filter

And now, you will be able to filter using your map!

map filter

I hope you found it useful.

A presto!

Avatar

Simona Loffredo

When use what? - PART 6 - Rank_Unique can solve your problems!

2 mins read

Thu 17 Mar 2016

A smart way to investigate your data in Alteryx

4 mins read

Fri 04 Mar 2016

Filtering with multiple datasources - Part 2

2 mins read

Sat 27 Feb 2016

Trasforming a passion into an Infographica with Tableau

2 mins read

Thu 25 Feb 2016