Top Tableau Scenario-Based Interview Questions Set -5 (1- 10)

 

1. How would you show Top N and Others in a chart?
   Create a parameter for Top N and group remaining values as “Others.”
   Example:

   IF RANK(SUM([Sales])) <= [Top N]
   THEN [Customer Name]
   ELSE "Others"
   END
   

2. How would you display only the latest record for each customer?
   Use FIXED LOD with MAX(Date).
   Example:

   { FIXED [Customer ID] : MAX([Order Date]) }
   

   Filter records where Order Date equals latest date.

3. How would you create Year-over-Year growth calculation?
   Compare current year sales with previous year sales.
   Example:

   (SUM([Sales]) - LOOKUP(SUM([Sales]),-1))
   / ABS(LOOKUP(SUM([Sales]),-1))
   

4. How would you create a running total sales chart?
   Apply Running Total table calculation on Sales measure.
   Example:

   RUNNING_SUM(SUM([Sales]))
   

5. How would you show percentage contribution by category?
   Use Percent of Total table calculation.
   Example:

   SUM([Sales]) / TOTAL(SUM([Sales]))
   

6. How would you highlight top-performing regions dynamically?
   Use conditional formatting based on rank.
   Example:

   RANK(SUM([Sales])) <= 3
   

   Color TRUE regions differently.

7. How would you swap measures dynamically using parameter?
   Create parameter with Sales, Profit, Quantity values.
   Example:

   CASE [Measure Parameter]
   WHEN "Sales" THEN SUM([Sales])
   WHEN "Profit" THEN SUM([Profit])
   WHEN "Quantity" THEN SUM([Quantity])
   END
   

8. How would you create a dynamic reference line?
   Use parameter-driven reference value.
   Example:

   [Target Value]
   

   Drag parameter measure to Reference Line.

9. How would you identify customers with declining sales?
   Compare current period sales with previous period.
   Example:

   SUM([Sales]) < LOOKUP(SUM([Sales]),-1)
   

   Filter TRUE customers.

10. How would you create a heatmap for sales performance?
    Use dimensions on Rows/Columns and Sales on Color.
    Example:

SUM([Sales])

Higher sales automatically display darker intensity colors.

Bhagavad Gita Wisdom #shorts

https://www.youtube.com/playlist?list=PLQM-BpTd9ZSumxwKgJjuJjlx2OcP_W516