Skip to main content
DD-TRF-003 Complex Joins, Exceptions and Transformation Logic Get the data →
DD-TRF-003-Q013 Medium Time series

Clean amount by month

After cleaning, parsing every date format and keeping the first occurrence of each TransactionID, total the Amount in SAR by month. Which month is highest? Break ties by earliest month.
Expected
One row per month: YearMonth, total · Line chart
Tables
FactTransformationEvents · columns
  • FactTransformationEvents
  • TransactionDate
  • Amount

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