My solution doesn't need any SQL code or new tables.1. Add a formula column Month_Start_Date to sales table: monthStartDate( sch_CommunityChallenge3.SALES__1_.TIME_ID) 2. Go to insight, select aggregated table, group by Month_Start_Date, previous ...
Hi Rasha, here's my solution:1. Upload csv and load tables2. Set up join between sales and customers3. Create insights with "In Query" individual filter: queryDistinct( Challenge.COUNTRIES.COUNTRY_ID, Challenge.COUNTRIES.COUNTRY_NAME = "Germa...