CODEWITHSUNDEEP
datevisualizationtableau-apidate-formattingtableau-desktop
Data Double O
Data Double O

Reputation: 13

Tableau Function - Dates (Day)

I am looking for a tableau formula that would help me create a field that assigns what day number it is in the year. If I use format options the day number restarts every month in the year... I have also tried to create my own formula however it is counting all the days numerically however it does not restart the count after the year ends. I have provided the Formula below:

DATEDIFF('day',DATE('1900-01-01'), [Date: ReportDate]) + 1

I have tried changing the format of the date and I have tried creating a formula to count days and have failed at both :(

Upvotes: 1

Views: 107

Answers (1)

Debayan
Debayan

Reputation: 854

Try using : DATEPART('dayofyear', [date])

Assuming you are in a year filtered on 2022, try applying AVG()

enter image description here

Upvotes: 2

Related Questions