QSBA2018 Exam QuestionsBrowse all questions from this exam

QSBA2018 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?

Show Answer
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

1 comment
Sign in to comment
turchinadOption: C
Oct 6, 2023

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.