This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...