3 Replies Latest reply on Aug 16, 2016 4:36 AM by Mahfooj Khan

if Aug then June-July-Aug data should display in the week format

lalitha p Aug 9, 2016 6:52 PM

Hi I have a requirement like this.

I have 3 measures Sales, profit and Discount. I am showing all the 3 measures across my category. I have an year and month filter in my report. If i select Year=2016 and Month = "Aug" then my report should display from June-July-Aug data as in the attachment.

My X-Axis is like this. WK1-Wk12 as in the attachment. That is if i select Aug , then June-July-Aug in weeks it should display display. Right now in the attachment it is showing just for the selected month, "Aug"

Please help me up.

Rolling of 3 Months.PNG 90.9 KB

1. Re: if Aug then June-July-Aug data should display in the week format

Mahfooj Khan Aug 9, 2016 10:41 PM (in response to lalitha p)
Is that what you wanted?
Workbook (version 9.3) has been attached for your reference. Let me know If this help.

Mahfooj

Last 3 months.twbx 1.4 MB
Like Show 0 Likes(0)

Actions
2. Re: if Aug then June-July-Aug data should display in the week format

lalitha p Aug 16, 2016 3:28 AM (in response to Mahfooj Khan)

Hi Khan,

Can we achieve the same requirement without the help of parameter.
Somehow my business is not agreeing for Month as a parameter ( because Month should display relevant values accordingly to year which we cannot retrieve in Parameters dynamically ).
Both my filters Year and Month to be taken as Normal Filters only not parameters.
Like Show 0 Likes(0)

Actions
3. Re: if Aug then June-July-Aug data should display in the week format

Mahfooj Khan Aug 16, 2016 4:36 AM (in response to lalitha p)

If I'm not wrong as per your requirement user will select year and month (you've mentioned 2016 and Aug) based on the selection graph will show weekly trends of last 3 months. If you don't use parameters then how could you pass these value to filter the data? If you don't want to use parameters then using cascade filter you've to manually filter last three months from the drop down. Let me know If you've any question.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

if Aug then June-July-Aug data should display in the week format

1. Re: if Aug then June-July-Aug data should display in the week format

2. Re: if Aug then June-July-Aug data should display in the week format

3. Re: if Aug then June-July-Aug data should display in the week format

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account