Johan Yu

Introduction In addition to the powerful dashboard offered by CRM Analytics, the tool also offers a powerful data transformation tool, the Recipe. This week, the challenge is not the dashboard itself but preparing data based on a requirement.  Requirement: retrieve all Customers without “activity” in the last 6 months. Activity here means: – Opportunity creation– Contact …

2024 Week 23 – Account without Activities in the last 6 months Read More

Introduction In this workout, we received weather data from weather machine, where every hour degree are stored in a column, and degree for each area are represented as a row. To easily work on this data, we need to transpose the data from column to row. sample source data Requirements Create a dev org or use an …

2024 Week 08 – Transpose Columns Read More