When you use a column of type text as a measure in a pivot query, which of the following pivot functions are available?
Note: There are 2 correct answers to this question.

Which fields can you format using Column Formatting on the Edit menu?
Note: There are 2 correct answers to this question.

You are creating a calculated column to calculate an employee's organizational tenure.

Why does the formula in the screenshot result in an error?

You are creating a query for a historical compensation story report in Query Designer. You have added the Job Information table to the query, configured a scope filter, and previewed the result to verify you are returning the appropriate employees.
You add the related table Compensation to the query.

When you preview the query, you only get the current compensation information for the employees.
Why do you only receive the current records?
Note: There are 2 correct answers to this question.

You are creating a Story report on Job Classifications. You have configured the chart, table, and input control on the canvas as displayed in the screenshot.

How do you set the input control?