Breaking Up Weeks When Quarter Ends

Options
user19713
user19713 Member
in Charting

Hi,

 

Is there a way to break up a week when the quarter ends? For example- if the quarter ends on a Wednesday, is there a way for the next day (Thursday) to automatically start as week 1 of the next quarter on that next day?

 

Thanks!

Comments

  • ST_-Superman-_
    ST_-Superman-_ Coach
    Options

    You could use the rank and window function tile in an ETL dataflow to accomplish this.  You would basically need to have several date fields present; year, quarter, month, week, and date.

     

    Each field would essentially be a date calculation like YEAR(`Date_Field`), etc.

     

    You could then make a windowed function to rank the weeks in a quarter.  


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
This discussion has been closed.

Categories