-
1. Re: Filter Date between one fixed date and previous quarter
Akram Ebrahim Nov 16, 2018 3:23 AM (in response to Tim Kennedy)Hi Tim,
You have put 'record date' on filters shelf and use that as relative date filter.
Refer the learning videos from tableau for more information
-
2. Re: Filter Date between one fixed date and previous quarter
Tim Kennedy Nov 16, 2018 3:29 AM (in response to Tim Kennedy)Thanks Akram,
Using the filter is fine but I don't want to have to manually adjust the date each quarter the report is run.
Is there a way of using a calculated field so that it always filters from '01-01-2017' - end of previous quarter i.e. it calculates the end of the previous quarter each time data is refreshed?
Thanks,
Tim.
-
3. Re: Filter Date between one fixed date and previous quarter
Akram Ebrahim Nov 16, 2018 3:42 AM (in response to Tim Kennedy)Hi Tim,
Ok now its more detailed. Why not?
Find the attached twbx file where I did replicate your requirement.
This sheet will start from 01-01-2017 always and will only take last 3 quarters dynamically.
Example. Now in the attached workboook, the data is available till dec-2017. Now its taking last three quarters dynamically. If Jan-2018 comes
2017 Q3,2017Q4 and 2018 Q1 will get updated dynamically.
Hope this solves your requirement. plz mark this as helpful and answered if correct.
-
Last 3 quarters.twbx 346.9 KB
-
-
4. Re: Filter Date between one fixed date and previous quarter
Tim Kennedy Nov 16, 2018 3:53 AM (in response to Akram Ebrahim)Hi Akram,
Thanks for this, nearly there! Apologies for any confusion.
I need to exclude the current quarter though i.e. as we are currently in Q4 I want the data to show all quarters from Q1 2017 - Q3 2018.
When we move to Q1 2019 I need the data to only show data from Q1 2017 - Q4 2018 i.e. excluding the current quarter.
Tim.
-
5. Re: Filter Date between one fixed date and previous quarter
Akram Ebrahim Nov 16, 2018 4:25 AM (in response to Tim Kennedy)Hi Tim,
My understanding is wrong. Now I've modified the twbx file according to the requirement.
It will exclude the max date quarter from the view and keep the remaining quarter starts from 2017.
-
Last 3 quarters_10.5.twbx 354.5 KB
-
-
6. Re: Filter Date between one fixed date and previous quarter
Tim Kennedy Nov 19, 2018 1:33 AM (in response to Akram Ebrahim)Thanks Akram,
his answer is perfect.
Tim.
-
7. Re: Filter Date between one fixed date and previous quarter
Akram Ebrahim Nov 19, 2018 1:40 AM (in response to Tim Kennedy)You are welcome Tim!