Examice

Exam QSBA2018 All QuestionsBrowse all questions from this exam

Question 29

A marketing team needs to analyze current sales by age groups in a bar chart. The following age groups are created in the data manager, and the field is named

AgeGroup:

✑ Children: 16 years old and younger

✑ YoungAdult: 17 to 30 years old

✑ Adult: 31 years old and older

The business analyst will use an expression to set the colors for the bars:

If ([AgeGroup] = 'Children', Red(), If ([AgeGroup] = 'YoungAdult', Blue(), Green()))

Which steps must be completed to apply the correct colors in the visualization?

Select Data in the properties panel and create a calculated dimension using the expression editor.

Create a master item dimension using the expression, in the visualization, select Color by dimension and use the newly created master item.

Under Appearance in the properties panel, select Color, then select Color by expression, and make sure that The expression is a color code is checked.

Create a master item measure using the expression. In the visualization, select Color by measure and use the newly created master item.

Correct Answer: C

To correctly apply colors based on the AgeGroup in the visualization, you need to use an expression that specifies the color for each age group. This can be done by going to the Appearance section in the properties panel, selecting Color, then Color by expression, and ensuring that the option 'The expression is a color code' is checked. This allows you to use the conditional expression to set colors for different age groups in the bar chart.

Discussion

turchinadOption: C

C. Under Appearance in the properties panel, select Color, then select Color by expression, and make sure that The expression is a color code is checked.