Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have the data as below format , date associated with a week , i need to show data for rolling past 4 weeks , so if i consider today() - 30 then i am showing data for only a part of the week ... how do i make sure that i get data for complete week ?
example in the below data i am seeing only 1 day in W3 instead i want all days in w3 week
here is my current expression:
=count({OpenDate= {">=$(=Date(today()-30))"},Type ={'TS'}>} DISTINCT(CaseNumber))
03/18/2018 | W7 |
03/17/2018 | W7 |
03/16/2018 | W7 |
03/15/2018 | W7 |
03/14/2018 | W7 |
03/13/2018 | W7 |
03/12/2018 | W7 |
03/11/2018 | W6 |
03/10/2018 | W6 |
03/09/2018 | W6 |
03/08/2018 | W6 |
03/07/2018 | W6 |
03/06/2018 | W6 |
03/05/2018 | W6 |
03/04/2018 | W5 |
03/03/2018 | W5 |
03/02/2018 | W5 |
03/01/2018 | W5 |
02/28/2018 | W5 |
02/27/2018 | W5 |
02/26/2018 | W5 |
02/25/2018 | W4 |
02/24/2018 | W4 |
02/23/2018 | W4 |
02/22/2018 | W4 |
02/21/2018 | W4 |
02/20/2018 | W4 |
02/19/2018 | W4 |
02/18/2018 | W3 |
May be Weekstart can help -
=count({OpenDate= {">=$(=Weekstart(Date(today()-30)))"},Type ={'TS'}>} DISTINCT(CaseNumber))
Hi Steve,
You may use something like below using weekstart function or the attached approach.
Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=WeekStart(Max(Date), -14))<=$(=Date(Max(Date)))’}>} Sales )
Find the attached qvw.
-Siva
Please take a look at my file , i am using 1 in my expression(To avoid other selections) .. i want to show past 5 weeks only , and other selections made should NOT effect this chart.
But here when i select other filter values the charts keep changing .. please help!
Any help on this?