Forum Discussion
Using Multiple Measures in a Switch
For this example:
Creating 3 Groups of Measures, of which each group will have 3 or 4 Measures..
I would like to have a switch to choose between the 3 groups, so that when I choose one... all measures in that Group
will appear in my , lets say matrix visual..
so 1 Group would be called DOT, holds Dot Total, Dot Failure, DOT Success.
2 Group would be called b4_10, holds b4_10 Total, b4_10New, b4_10Old
group 3, 4 and 5 various other measures..
WHat I'd then like to have is a filter visual that will list Group 1 through to x
when i choose Group 1... the matrix will have DOT Total, DOT Failure, DOT Success as eother a ROw or Column dependant on where I have put the 'Parameter" of the switch...
Is this do-able?
mgtaylor33 I hope this video will help:
3 Replies
- parry2kSuper User
mgtaylor33 I hope this video will help:
- mgtaylor33Frequent Visitor
Absolutely... that will totally work with what I am after.... the key to this was the ADD Column and the if statement , as I had the field Parameter set, just needed the method to have a group name rather than all measures showing.
Brilliant thank you.
- parry2kSuper User
mgtaylor33 glad it was helpful. Cheers!!