7 Replies Latest reply on Mar 14, 2017 2:00 PM by Chaan Thomas

    What is this week function as a calculated field?

    Chaan Thomas

      Unfortunately I cannot paste a workbook because my company does not allow me to upload files, but this can be quickly easily reconstructed using Superstore data (currently using 9.3).


      In a blank workbook drag "Ship Date" to columns:

      Click the + on the pill to expand the year to quarter, then to month.


      On the right of the month pill left click the arrow. From the selections given choose "Week Number"


      A new (green) calculated field is created called "Week(Ship Date)"



      I want to know how to manually create that "Week (Ship Date)" as a calculated field. I want to do this so I can make a parameter that toggles between week and month, but am not able to figure out how to do this and have it drilled down to that level by default.


      I know that I can use DATETRUNC('week', [Ship Date]) then drill back down to that manually as I did above, but using that within a parameter toggle does not seem to be working for me.


      Any help on this is greatly appreciated,


      Thank you.