6 Replies Latest reply on Mar 26, 2018 7:44 AM by Vinnie Ahuja

# Percentage of the month left

Hello,

I am trying to add how many days of the month are left and the percentage of days that have passed. For instance, it is March 23 and there are 8 days left in the month. I would also like to get 74% which is (days past/total days in the month)*100.

Thanks!

• ###### 1. Re: Percentage of the month left

Geryn,

Find the attached workbook. I wrote DATEDIFF calculations to achieve this.

• ###### 2. Re: Percentage of the month left

You could try this:

Compute the last day of the month: add month to today's month and then subtract a day.  Return the numerical value of the day.  Then divide the numerical value of today by all of this.

day(today())

/

if its not today you're interested in, you can just substitute the date field in for today()

• ###### 3. Re: Percentage of the month left

Is there a way to make the "today" meaure read the date of the most recent sunday.

I ren the reports on Tuesdays but exclude current week and want it to count the days left in the month from Sunday on.

• ###### 4. Re: Percentage of the month left

Is there a way to make the "today" meaure read the date of the most recent sunday.

I ren the reports on Tuesdays but exclude current week and want it to count the days left in the month from Sunday on.

• ###### 5. Re: Percentage of the month left

Datetrunc('week', today (), 'sunday') should work. I don't think you need the 'sunday' as I believe it is the default, but it doesn't hurt anything to have it there.

On Sun, Mar 25, 2018 at 3:53 PM, geryn.ligator<tableaucommunity@tableau.com> wrote:

#yiv0747183475 * #yiv0747183475 a #yiv0747183475 body {font-family:Helvetica, Arial, sans-serif;}#yiv0747183475 #yiv0747183475 h1, #yiv0747183475 h2, #yiv0747183475 h3, #yiv0747183475 h4, #yiv0747183475 h5, #yiv0747183475 h6, #yiv0747183475 p, #yiv0747183475 hr {}#yiv0747183475 .yiv0747183475button td {}

|

 Tableau Community

|

Percentage of the month left

reply from geryn.ligator in Forums - View the full discussion

Is there a way to make the "today" meaure read the date of the most recent sunday.

I ren the reports on Tuesdays but exclude current week and want it to count the days left in the month from Sunday on.

 Reply to this message by replying to this email, or go to the message on Tableau Community Start a new discussion in Forums by email or at Tableau Community Following Percentage of the month left in these streams: Inbox

 This email was sent by Tableau Community because you are a registered user. You may unsubscribe instantly from Tableau Community, or adjust email frequency in your email preferences

• ###### 6. Re: Percentage of the month left

I am getting 80.6%...

day(DATETRUNC('week',today(),'sunday'))

/