-
1. Re: Filter dashboard using multiple Dimensions
Vamsi Challa Feb 13, 2018 7:27 AM (in response to Ben Castleberry)Hi Ben,
Below one is similar topic. I think it will be help you.
Dynamic display of filter on selection of sheets.
You can create two workbooks on Sales Person & Sales Manager and create two vizs in dashboard where you can filter as per sheet names like mentioned in above scenario.
-
2. Re: Filter dashboard using multiple Dimensions
Ben Castleberry Feb 13, 2018 11:08 AM (in response to Vamsi Challa)So I would have to recreate all 14 worksheets in the dashboard twice?
-
3. Re: Filter dashboard using multiple Dimensions
Joe OppeltFeb 13, 2018 12:39 PM (in response to Ben Castleberry)
I can't wrap my head around what you are really looking to do. But let me toss out a few concepts that you might want to leverage.
There is a function you can use in a calc. Look at ISMEMBEROF(). I use this in multiple places and multiple ways. We assign users to groups, and ISMEMBEROF tells me if they are a member of the group specified in the parentheses. If the user is a member of a particular group, I can display more things or hide things or filter things...
If you want some people to see a sheet categorized by one dimension, and other people see the sheet categorized by another dimension (for example, swap in [Cities] for one group and [Neighborhoods] for another) you can have a calc that detects what group is in play and use that dimension:
IF ISMEMBEROF('Cities Group') then [Cities] else [Neighborhoods] END
Now use that calc on the ROWS (or COLUMNS) shelf and depending on what group the user is in, he will see the sheet by Cites or by Neighborhoods.
-
4. Re: Filter dashboard using multiple Dimensions
Joe OppeltFeb 13, 2018 12:42 PM (in response to Joe Oppelt)
Further, if you employ the second idea I described, you could also show the [Cities] filter to the Cities users, and the [Neighborhoods] filter to the Neighborhood users. (And the Cities users won't see the Neighborhood filter.) And it'll all still be on one sheet.