1 of 1 people found this helpful
that sounds like a set. is it?
what kind of things are in a folder?
region/department/workgroup? or 2007/2008/2009?
The latter is misshaped data, the former is likely manageable with a set.
If I've missed what you're after, perhaps a small example? mini data set or workbook?
Well, it's data pulled from an Oracle database. The data I'm working with consists of dimensions that have data appropriate to their own column in our database.
It's just the measures. The measures are all sales data for different time periods. In our database, those columns are a bunch of 0's and 1's, meaning something was sold for that time period. So right now each of those measures, when described in Tableau, consist of only 0's and 1's. Though, the sums of each measure come through fine (kind of, my sales data is a little off from what tableau is telling me in some places but that's for a different time), I'd still like to build a "filter" on those in a dashboard.
When I used the 'measure values' measure, I can actually build a quick filter off of that but I can't actually get that quick filter to apply to all worksheets in my dashboard for some reason.
Sets sounds exactly like what I want for my dimensions, and I'll be testing that as soon as I'm finished with that post. It's just the measures is what I'm mostly having trouble with...
if you need an existing filter to apply to more than one sheet, there's a few ways to do it.
If all using the same connection: global filters
if all on the same dashboard, but not sharing the same connection, then actions:
Ok, checking out sets now and I'm not sure this is what I want.
I'll give you an example
- Open up a new Tableau workbook, and connect to the Sample Superstore data extract
- Change dimensions to 'Group by Folder'
From here you see multiple folders - Customer, Order, Product. What I would like to do, for example, is move the 'Product' folder to the rows shelf, and build a filter on that that would let me make the rows change between Category, Container, Department, and Item (not Supplier since I'm trying to replicate my information as much as possible). Is there a way to do that?
And on the topic of Global Filters, see the attached picture. All of my measures in my workbook are on the right in the quick filter, and I used 'Measure Values' to get them there. But, Measure Names gets put into the filters shelf (even if I'm on a map or not!) I can't add Measure Values to the filters shelf either. So when I go through the steps for the global filters, it doesn't give me the option to apply the filter globally.
All of those measures have the counts I need, it's just that I need to switch between them for whatever sheets I put them in.
Capture.PNG 235.0 KB