The Contains function might help in verifying if a given data or label is in the Table, if the value is available then the function returns "True". If this value is missing then it returns "False". The following example presents the basic usage of this function.
Here you can see that there we checked if there is Alpina in a given table.
The result is "True", which means that Alpina is included in the table. Let's see what happens if we enter "Other Make" instead of Alpina.
See how it can be used to check within a dynamic row if a given make also has data for a different period. Similar example was given with the PositionOf function.
In this example we can see that there are several function used including Contains in order to verify if there are data available for given makes for previous year.
Hence we need to firstly use TabReference and
1. Type in tabReference and open a bracket;
2. Type in @ and select the tab where you have your overall product satisfaction.
3. Then add:
Make of new car as the second question;
*All responses as the answer to the third question;
Dataset year as the fourth question;
2 - which means the first item that will be available in the query results for this question;
Overall product satisfaction as the following entry;
Mean as your statistic;
4. Close the bracket and preview the results of the newly created table.
Here, we have created an expression that generates a table showing the mean values for overall product satisfaction across all makes. But what we want is to check if there are data available for given makes the previous year therefore we need to add the following:
1. Add comma and the Contains function after the Value)
2. Add Filter with additional NOT IsMissing function, in this filter we need to include Tabreference similar to the first one, but as we are referring to the previous year we need to type in 2 instead of 1.
3. At the end of the expression we need to add comma after "NOT isMIssing(@Value)," and type in @Response label. Close all the open brackets.
