Thanks Luciano for your reply.
In the example you have provided , two rows of the data have NULL values for points so they dont appear when you click on the number 11 (as you filter them out in the filters shelf)
What if they have points too? they will show too in using the action filter. I want only to show the issues related to the 11 points (from the first 3 issues).
Am i getting your point right? if not, please explain to me the steps you have taken so i can do the same.
Ammar, issues D and E are not showed because they have null value.
Since they have value, they will appear.
Take a look on points filter.
Yup, they are filtered out. i can see it.
What is required is that D and E should not show even if they have points. i hope you could be able to open my workbook to see the exact case, as i have two data sources and two sheets depending on them.
One data source called data source 1 (see attached file) on which the first sheet (summary) depends on. (it has issues A, B, C with total points = 11).
Second data source called data source 2 (see attached file) on which the second sheet(details) depends on. (it has issues A, B, C, D, E). No points column in this data source.
on the dashboard, sheet 1 (summary sheet) will show 11 points (from data source 1 , summing up issues A, B, C). When the user clicks on this number 11 , the details sheet (from data source 2) will be filtered to show issues A, B, C and ignore issues D and E.
I hope this make it clearer.
Thank you for your help.
Do you need issues D, E for something?
If not you can join info and exclude them.
If you need for other things, here goes a question:
Issues D, E will always not appear on this presentation? If yes, is just filter them to not appear.
Am i missing something?
issues A, B, C, D, E will show by default when the user opens the dashboard.
Then the user has the ability to click on the number 11 (points for A,B and C) and filter them only. We he clear the action filter, he will be able to see all issue again. so yes, we need D and E
What you want is no possible since 11 point sheet has no issue num.
Or you show or not, according your criteria.
Thanks Luciano, i have spent some time on it with no luck. Maybe it is not possible or no work around for it.
2 of 2 people found this helpful
So as several others have said, due to the blended nature of your data model, this is going to be tricky. The problem being that any 'dimensions' you create, are brought in as "Aggregated Calculated Dimensions" when brought across data sources (due to the way blending works).
If this were all in one data source (so still having A-E), but only A-C have points, we *should* be able to make it work using a Row-Level dimension to only show the values where "points" aren't NULL.
However I love a good challenge!...and this may not be suitable for your "real world" situation, but I've got it working by looking at the problem is a different way. What I've actually done here is use an "Action Triggered Sheet Swap", so when the user first opens the dash it shows A-E, but when they click on the "11" it swaps out the sheets, so the new one has a regular filter on (which is just where the blended Issue isn't NULL).
Here's a Wiki post on the general principle of how this works.
Let me know if this either doesn't work for you (let me know why), or doesn't make sense.
Yes, i came across your show/hide solution which is awesome. I believe it is the only thing i can do here. In my real word case it is more complicated as i have four summary sheets and four details sheets, along with other sheets on dashboard.
I hoped that there will be a simpler thing to do. I will invest time with your solution and try to make it work in my dashboard.
Thanks for your reply.
Glad it helped (also realised I forgot to attach the link to the Wiki article...now in the post!). Yes it get's a little complicated to keep track of the actions...etc. but yes you can set up these actions so they affect multiple sheets, and can get some pretty "fine grain" control as to what shows when.