7 Replies Latest reply on May 21, 2018 10:27 AM by Yuriy Fal

# Tableau Problem Statement

I have a problem statement in tableau , Please check if you can suggest anything

we have to bring the following scenario in tableau, please provide your suggestions  on the same.

Scenario

1)      Source is the published data source.

2)      Having two columns date and value.

3)      Value column will get change frequently on different date (for eg):  if the value is 4.00 on “1st of May 2018” and it may get change on “4th of May 2018” as 4.10.

4)      Thing is we need to use the value of 1st May 2018 (4.00) for 2nd and 3rd day of May. That Is we need to use previous value for absence days.

5)      Like the way we need to bring it for every day in a year and get AVG(Value) on month basis.

• ###### 1. Re: Tableau Problem Statement

Hi Anindam,

You could do it with the help of Table Calculations

and date padding (Show Missing Values on the Date pill).

Please find the attached as an example.

Hope it could help.

Yours,

Yuri

• ###### 2. Re: Tableau Problem Statement

There is no attachment , please share again

• ###### 3. Re: Tableau Problem Statement

Hi Anindam,

Actually, it's out there.

Please open the thread in a browser

and look at the lower left of the reply.

Yours,

Yuri

• ###### 4. Re: Tableau Problem Statement

Hi Yuri ,

I really cannot find it.

Will it be ok to email me  my email id is   anindamjob@gmail.com

Thanks

Anindam

• ###### 5. Re: Tableau Problem Statement

Just did it.

• ###### 6. Re: Tableau Problem Statement

Hi Yuri ,

I think the problem statement I was not able to explain .I am doing again

 Source will be like below date in dd-mm-yyyy format Date Value 01-01-2017 2 02-01-2017 4 05-01-2017 7 06-01-2017 8 07-01-2017 9 08-01-2017 10 etc. We want to transform data like below 01-01-2017 2 02-01-2017 4 03-01-2017 4 04-01-2017 4 05-01-2017 7 06-01-2017 8 07-01-2017 9 08-01-2017 10

The date will be of say a year .We want to show the average per month for each year.

Regards

• ###### 7. Re: Tableau Problem Statement

Hi Anindam,

Ok, i've applied the calcs

from my example to your data.

Please find the attached.

Yours,

Yuri