What do you mean with 'pass rates of the modules that contain a certain value', i.e. where, in which field can we look for these values?
You should be able to do something like this as calculated dimension (and enable 'Suppress When Values Is NULL')
=If( Module like 'Core *', Module)
=If(Match(Module, 'Core 1', 'Core 2'), Module)
If you want to filter modules looking into another related field with a 1:1 relation:
=If( WildMatch(OtherField, 'Core *','Other?Matc?ing*'), Module)
If you want to group all other modules into 'Other':
=If( Module like 'Core *', Module, 'Other')
You might also be able to filter your dimension using e.g. set analysis, but before talking about this, please elaborate further on your setting (see above)
Thanks for your help. To try and bet more clear:
The Dimension [Module] is an excel column which contains a list of 80 or so different modules that were ran. 8 of them are Core 1 modules, so their name is 'Core 1 - Year' I need to do analysis of the specific module Core 1, not the entire list. Therefore I want to create a bar graph that shows me only the 8 Core 1 modules.
Hope this helps!
I can't really read the dimension values of the charts in your screenshots on my screen, but I assume that you need to adapt the search as Sunny suggested.
In my above suggested calculated dimensions (and also in the set analysis), I've used LIKE operator and Wildmatch() function to be able to use wild cards in the value comparison. But the search value needs to be created correctly to result in your requested dimension value matches.
The star symbol * is a wildcard for any number of unspecified characters, while the question mark ? is a wildcard for a single unknown character.
You probably just need to adapt the comparison value using appropriate wildcards, like
=If( Module like '*Core 1*', Module, 'Other')
like Sunny also suggested.
'*Core 1*' is telling QV to look for modules that contain 'Core 1' anywhere in the module name, doesn't matter if there are any other characters before or after 'Core 1'.