Rank Order - Dynamic Images & Expressions
The previous example used an expression and dynamic images to display a country's flag that was linked to the selected country parameter of the page.
This next example uses an expression and dynamic images to display a brand's logo that ranked first in a "likely to recommend" query.
This crosstab example shows a Top 1 Box score for “Recommendation of New Vehicle Make.”
The vehicle makes are sorted in descending order.
The following steps will use the crosstab example to display the dynamic image (brand logo) of the highest rated vehicle make (which happens to be Ascari).
Return to the page in Compose and click the EXPR option in the menu bar.
Click the Data References option in the expression editor.
Follow the prompts to make the appropriate selections.
The Make of New Car option uses By Position instead, since the make with the highest value is needed from the sorted crosstab results.
Confirm that the expression syntax has a green checkmark and the result matches the data in the crosstab (95.0%).
The expression syntax needs some additional editing to use with dynamic images.
Type ‘itemat(’ at the beginning of the expression.
At the end of the expression, type ‘,1)’
Lastly, click on Formatted value and change it to Response labels
The modified expression syntax should now have a green check mark again and the returned value will be “Ascari.”
Click the Apply button.
The dynamic image will update to reflect the brand with the highest value (1st position) from the crosstab results, which happens to be Ascari.
This example shows the dynamic image was copied twice and the expression was edited to also show the 2nd and 3rd vehicle makes in the sorted crosstab results.
