BrentJensen Member

Comments

  • Thank you @GrantSmith - Your advice is what solved this for me. As suggested by GrantSmith, I created an excel upload dataset with a file that references our 4 digit YYWW to every calendar date in that week. Here is a sample of the spreadsheet used to create the date conversion dataset: The dataset was created by uploading…
    in Number of week calculations for fiscal YYWW (Year, Week of year) Comment by BrentJensen October 2022
  • GrantSmith Expecting that in the screen capture of the card output above that the beast mode: SUM(CASE WHEN `SALE_DATE` > CURDATE()-40 AND MONTH(DATE_ADD(CURDATE()-1, 7 - DAYOFWEEK(CURDATE()))) = `FISCAL_PERIOD` THEN `SALES` END) would be able to provide correct data for the first fiscal week of November even though that…
    in Period to date sales beast mode Comment by BrentJensen November 2020
  • @GrantSmith This was not an adequate solution. All of last week, the calendar month and fiscal month were in different months. I created a beast mode in our dataset using the code from this solution and set it up for a side by side comparison with the hard-coded beast mode: I think the part of the beast mode in the…
    in Period to date sales beast mode Comment by BrentJensen November 2020
  • @GrantSmith Only remaining concern is the 1st period of a fiscal year. This is often a fiscal month where there are days in different calendar years. This chart helps explain: 2021 Fiscal week 1SunMonTueWedThuFriSatDecember 2020January 2021272829303112 I'm still testing to see if this becomes a problem. @GrantSmith , any…
    in Period to date sales beast mode Comment by BrentJensen October 2020
  • To what is 'dt' referring? It looks like a reference to a data column in the dataset, but there isn't a column with that name. ???????
    in Period to date sales beast mode Comment by BrentJensen October 2020
Avatar