3 Replies Latest reply on Dec 5, 2018 2:42 PM by Don Wise

How do you get the number of months for a year and also use a cumulative function on it?

Sanil Thomas Dec 5, 2018 2:11 PM

I have a column in a table which shows the number of months for a year and another column which shows the number of days for each of those months. I want to do the following:

1. I want to get a cumulative calculation where it will add the previous months number of days and keep incrementing till the end of the year. Is that possible in Tableau and if so, how?

2. I want to also find if there is a function which can get the number of minutes for a month.

Days of Month TEST.xlsx 10.1 KB

1. Re: How do you get the number of months for a year and also use a cumulative function on it?

Don Wise Dec 5, 2018 2:19 PM (in response to Sanil Thomas)

Hello Sanil,
Please see below screenshots as example to achieve what you're looking to do. There aren't specific functions, but there are calculations! Thx! Don
Like Show 0 Likes(0)

Actions
2. Re: How do you get the number of months for a year and also use a cumulative function on it?

Sanil Thomas Dec 5, 2018 2:26 PM (in response to Don Wise)

Thanks Don, I appreciate it. That's what I was looking for. However, I have a question. Is this calculation possible to do in Datasource when you load the file as a calculated field?
Like Show 0 Likes(0)

Actions
3. Re: How do you get the number of months for a year and also use a cumulative function on it?

Don Wise Dec 5, 2018 2:42 PM (in response to Sanil Thomas)

Hi Sanil,

You can create a calculated field based off of other available data, yes, in the Data Source window section. Right click the column of data you're looking to calculate off of and go forward from there!

If this answers your question, please mark the response as correct to close the thread.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

How do you get the number of months for a year and also use a cumulative function on it?

1. Re: How do you get the number of months for a year and also use a cumulative function on it?

2. Re: How do you get the number of months for a year and also use a cumulative function on it?

3. Re: How do you get the number of months for a year and also use a cumulative function on it?

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account