Last Attempt Analytics-DA-201 Questions

The required logic must first evaluate the activity history independently for each Call ID, which is why a FIXED LOD expression is appropriate. {FIXED [Call ID] : ...} establishes Call ID as the calculation grain regardless of the visualization’s dimensions. Within each call, [Activity Name] = " Assign Technician " produces a Boolean condition. Applying MAX to that condition determines whether an assignment activity exists for that call. If one exists, the calculation returns 0; otherwise it returns 1. The outer SUM then totals the calls that never received an assignment. INCLUDE does not provide the required fixed call-level evaluation, while the other expressions either count activity records rather than calls or do not form valid LOD logic for the requirement. Therefore, A is correct.

In Tableau, the RANK function assigns a rank to each row within a partition of the data, based on the value of the field being ranked. It is important to understand that the rank is recalculated whenever the underlying data or the partitioning changes.

In the given scenario, the Overall Rank is based on the Sales figures, while the Rank (presumably) is based on the Sales within the Category. When filtering on the condition where [Overall Rank] - 1, it means we are excluding the sub-category that has an Overall Rank of 2.

Looking at the data:

Furnishings has an Overall Rank of 8, which does not meet the filter condition ([Overall Rank] - 1). Therefore, its rank remains the same.

Tables have an Overall Rank of 3. When the sub-category with an Overall Rank of 2 is removed (Chairs in this case), Tables move up in the overall ranking. However, since Tables are the top-ranked within the Furniture category, their Rank within the category would remain unchanged at 1.

Chairs have an Overall Rank of 2, which meets the filter condition and thus will be removed from the view. We cannot determine the change in Rank for Chairs because they are filtered out.

Accessories have an Overall Rank of 5. If any sub-category with a higher Overall Rank (1 to 4) is removed, the rank of Accessories within the Technology category could change because it is currently ranked 3 in its category. With the removal of Phones (Overall Rank 1), the Rank of Accessories could potentially increase.

Copiers have an Overall Rank of 6, which does not meet the filter condition. Therefore, its rank remains the same.

Machines have an Overall Rank of 4. If we remove Phones (Overall Rank 1), Machines will move up in the overall ranking and potentially within the Technology category as well, changing its Rank from 2 to 1.

Phones have an Overall Rank of 1, which does not meet the filter condition of being Overall Rank 2. Therefore, its rank remains the same.

Bookcases have an Overall Rank of 7, which does not meet the filter condition. Therefore, its rank remains the same.

Based on this analysis, when the sub-category with an Overall Rank of 2 (Chairs) is removed, the Rank value will change for Tables, Accessories, and Machines, as they will move up in the overall ranking within their respective categories. However, it ' s important to note that while Tables will move up in the overall ranking, their rank within the Furniture category would not change as they are already at the top. The rank changes for Accessories and Machines are due to the removal of Phones, which is ranked higher overall and within the Technology category.

RANK is a table calculation, and Tableau evaluates ordinary dimension filters before table calculations. Filtering out Phones , which is the highest-sales Technology sub-category, removes that mark before Tableau recalculates Rank for the remaining Technology members. Machines therefore moves from Rank 2 to Rank 1, Accessories from Rank 3 to Rank 2, and Copiers from Rank 4 to Rank 3. The Furniture members—Chairs, Tables, Bookcases, and Furnishings—remain in their existing partition and therefore retain their current ranks. Phones itself disappears rather than receiving a new displayed rank. Tableau documents RANK as ranking values within a partition and confirms through its order of operations that dimension filtering takes place before table calculations are evaluated. Therefore, Machines, Copiers, and Accessories are the three affected sub-categories.