Skip to main content
Topics#Tableau Desktop & Web AuthoringLance Martens's Question
Lance Martens (Home101) asked in #Tableau Desktop & Web Authoring
Aug 31, 2016, 5:29 AM

Assistance required with configuring a Customised “Date” Calculated Field

Hi All,

 

I would appreciate any assistance with how to configure a Customised “Date” Calculated Field?

 

Logic:

  • I have unique “Reporting Weeks”

 

Required:

  • I am attempting to create a calculated field that will give me unique “Reporting Months” based on the grouping of the Reporting Weeks

 

  • Calculation / Formula example of what I’m aiming for and I need help with please?

IF [Reporting Week] = 1, 2, 3, 4, 5 then "January"

ELSEIF [Reporting Week] = 6, 7, 8, 9 then "February".........etc. all the way to December

 

My workbook is attached.

 

Any assistance will be appreciated,

 

Cheers,

Lance

Unique Reporting Month CF_TSupport Copy.twbx
5 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Aug 31, 2016, 9:39 AM

    Hi Lance,

     

    Please take a look at the solution. I don't think you need any calculation to fix this up. You can do it with the tableau date options which you should be using on the Calendar Date.

     

    Please find the below attached screenshot to verify the same. Also find the attached tableau 10 workbook for the same for reference.

    Hi Lance, Please take a look at the solution. I don't think you need any calculation to fix this up. You can do it with the tableau date options which you should be using on the Calendar Date.

     

    Thanks and Regards,

    Ashish Chaudhari

Write an answer...
0/9000