The default week() function extracts the week number from the start of the year and runs 1 to 53 or 54. I need to show week number within the quarter, running 1 to 13 or 14 within each qtr.
Is there a way to do this using beast mode or using the formula tile in Magic ETL ?
Thanks!