You want to return the quarter to date event records to count terminations.
Which options would you set in the time filter?
Note: There are 3 correct answers to this question.
You want to join two tables, A and B, and you want to include all rows from Table A, and only matching rows from Table B. Which join type must you use?
You need to create a chart of type Indicator: Numeric Point that displays the following output:
count of employees with the gender male divided by the count of employee with the gender female.
The chart can then be filtered for different departments. What calculation is required to create the metric?
When constructing an expression for a calculated column in Query Designer, which syntax should you use to enter a date?
The data source used by the two tables only displays current (active) employees.
How would you configure a filter on the table End of Previous Year Headcount by Location to display data accurately?
Note: There are 2 correct answers to this question.