3 Replies Latest reply on Oct 21, 2015 8:05 AM by Kent Sloan

Plotting graph based on this this week's date as well as same days last week

babu ironman Oct 20, 2015 10:51 AM

Hey guys,

Big fan of this forum. Need your expertise on the problem i am facing. Below is the original data in my EXCEL which i am uploading to tableau and saving as extract.. I will leep adding data at the end of the row everyday and refresh and the extract.

Area	Date	Percentage
Bandwidth status	7-Oct-15	21%
Bandwidth status	8-Oct-15	69%
Bandwidth status	9-Oct-15	67%
Bandwidth status	10-Oct-15	15%
Bandwidth status	11-Oct-15	66%
Bandwidth status	12-Oct-15	23%
Bandwidth status	13-Oct-15	67%
Bandwidth status	14-Oct-15	15%
Bandwidth status	15-Oct-15	66%
Bandwidth status	16-Oct-15	67%
Bandwidth status	17-Oct-15	15%
Bandwidth status	18-Oct-15	66%
Bandwidth status	19-Oct-15	67%
Bandwidth status	20-Oct-15	15%

So here's the solutioni need:

First thing. I need the bar graph for today()-3 days. I.e. if today was 20th oct, i need the graph to be plotted for 20th, 19th and 18th. When i refresh teh data on 21st, it should automatically update. Probbably we can use datediff for this.
Second thing: Along with those 3 days, i need to plot data for last week, same day. i.e. If today is 20th, i need data to plot graph for 20th,19th,18th and 13th,12th and 11th. I am not sure how to use LOOKUP formula for this.

I have attached the sample answer i am looking for. Please note that, as the day moves forward, whenever i refresh, data should automatically refresh. Ex: If today is 21st, when i refresh, data should automatically change to 21,20,19,14,13,12.

Tried with many things but couldnt figure out this one simple thing.

Also it would be of great help if you can let me know some websites where i can learn tableau well.

Experts, please help here.:)

1. Re: Plotting graph based on this this week's date as well as same days last week

Kent Sloan Oct 20, 2015 12:01 PM (in response to babu ironman)
Hello Babu,

Below is the formula I used to create the groups you described. I also included a parameter driven version where the user can select the number of days to go back and how many days to compare. To pick up some more of the basics of Tableau I would recommend checking out the InterWorks Tableau Essentials blog series. For general reading I would lookup the list of Tableau Zen Masters and look over their blogs. I hope this helps!

IF [Date]<=DATEADD('day',-3,TODAY()) AND [Date]>=DATEADD('day',-5,TODAY()) THEN "This Week"
ELSEIF [Date]<=DATEADD('day',-10,TODAY()) AND [Date]>=DATEADD('day',-12,TODAY()) THEN "Last Week"
END

Thanks,
Kent Sloan
InterWorks

Dates Example.twbx 37.2 KB
Like Show 0 Likes(0)

Actions
2. Re: Plotting graph based on this this week's date as well as same days last week

babu ironman Oct 20, 2015 9:56 PM (in response to Kent Sloan)

Hi Kent,

The solution looks great. Thank you so much.

However is there anyway we can get the solution like below:

First get the recent 3 dates(today, yest and day before yest) using datediff or dateadd, then use LOOKUP to get last week's date and data??
Like Show 0 Likes(0)

Actions
3. Re: Plotting graph based on this this week's date as well as same days last week

Kent Sloan Oct 21, 2015 8:05 AM (in response to babu ironman)
Hi Babu,

I personally would avoid using a table calculation for this unless there was a situation that required it. Attached is an updated version of the example that uses a table calc to lookup the percentage for the previous week.

Thanks,
Kent

Dates Example.twbx 68.4 KB
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Plotting graph based on this this week's date as well as same days last week

1. Re: Plotting graph based on this this week's date as well as same days last week

2. Re: Plotting graph based on this this week's date as well as same days last week

3. Re: Plotting graph based on this this week's date as well as same days last week

Actions

More Like This