-
How to derive the MTD achievement based on monthly target and daily sales data on various dimensions
-
Derive monthly closing balance of various items from yearly opening balance and their monthly transactions data
-
How to derive the recently purchased city of each customer from daily customer transactions from various cities
-
Use case for a Jewellery agent’s order count calculation where orders and customers can be divided amongst multiple transactions for the same order
-
How to Derive Daily and Monthly Opening and Closing Covid Cases
-
Deriving week start date and week end date of a given date
-
Derive Week of year considering the week starts from Saturday
-
Create Custom column values from the dataset
-
Minimizing Number of Steps using Custom SQL in SSDP