4 Replies Latest reply on Jun 25, 2013 4:08 PM by Noel Avison

Show filtered and unfiltered data side by side

Noel Avison Jun 25, 2013 12:45 PM

I am trying to show a week by week view of data using a sliding week filter this is working well:

The data is made up of various machine lines and their yields for that week ranked from worst to best.

Now I want to show another column that shows an unfiltered view so you can see how that machine has been doing over the past year or so. How do I include a column that has unfiltered data? I don't want to use parameters to filter the weekly view because I don't want to have to re-update the parameter values every new week.

Thanks!

-Noel

1. Re: Show filtered and unfiltered data side by side

Shawn Wallwork Jun 25, 2013 1:09 PM (in response to Noel Avison)

Noel, I'm pretty sure that's going to be a second sheet displayed side-by-side in a dashboard (with all the unintended consequences).

--Shawn
Like Show 0 Likes(0)

Actions
2. Re: Show filtered and unfiltered data side by side

Noel Avison Jun 25, 2013 2:54 PM (in response to Shawn Wallwork)

Well, the main problem with that is that the sort order won't be the same, and the machines that didn't run during that week will be in the year to date view... I guess the solution might be to add a total year to date yield number directly in the data.
Like Show 0 Likes(0)

Actions
3. Re: Show filtered and unfiltered data side by side

Shawn Wallwork Jun 25, 2013 5:32 PM (in response to Noel Avison)

Yeah I know. Actually a friend mention to me off-forum that you could do what you want by duplicating your data source, then joining blending it back on itself using selective fields, that wouldn't filter your original data. Use filters from your original data source to build the view you've got. Then use fields and filters from the secondary source to get the totals you're looking for.

Hope this makes sense.

--Shawn
Like Show 0 Likes(0)

Actions
4. Re: Show filtered and unfiltered data side by side

Noel Avison Jun 25, 2013 4:08 PM (in response to Shawn Wallwork)

Ya that method worked well thanks!
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Show filtered and unfiltered data side by side

1. Re: Show filtered and unfiltered data side by side

2. Re: Show filtered and unfiltered data side by side

3. Re: Show filtered and unfiltered data side by side

4. Re: Show filtered and unfiltered data side by side

Actions

More Like This

Incoming Links