Skip to main content
DD-TRF-002 Multi-File Transformation and Data Quality Get the data →
DD-TRF-002-Q032 Medium Time series

Largest monthly shortfall against target

Unpivot WideMonthlyTargets, join it to the cleaned export by product and month, and compare total target with total Amount for each month of 2025. Which month has the largest shortfall (target minus actual)?
Expected
One row per month: target, actual, shortfall · Clustered bar chart
Tables
FactRawEvents, WideMonthlyTargets · columns
  • FactRawEvents
  • WideMonthlyTargets
  • ProductCode
  • TransactionDate
  • Amount
Topics
Data Shaping

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in.

Create a free account Sign in