-
1. Re: Custom Date filter that can show last 12 months in Month and Year format in drop down
Zhouyi ZhangDec 5, 2017 4:13 AM (in response to Abhishek Belnekar)
1 of 1 people found this helpful -
2. Re: Custom Date filter that can show last 12 months in Month and Year format in drop down
Abhishek Belnekar Dec 5, 2017 5:40 AM (in response to Zhouyi Zhang)Hello Zhouyi,
Thank you for the reply.
What I want is to get it done inside the filter. So when I choose the date for which records are not available I can show "No data"
So if you build a filter around order date on Month and Year, it will show you only 3 records. But I want all 12 months of the year.
Thank you,
Abhishek
-
3. Re: Custom Date filter that can show last 12 months in Month and Year format in drop down
Norbert MaijoorDec 5, 2017 6:43 AM (in response to Abhishek Belnekar)
Hi Abhishek Belnekar,
Find my approach as reference below based on "Scaffolding" stored in attached workbook version 10.3 located in the original thread.
1. Scaffold is explained here
2. D1 Display: if datediff('month',[Date],today())>=0 and datediff('month',[Date],today())<=11 then [Date] END
3. Drag required objects to the indicated locations and "un-check" Show Header of D1. Display > Right Click > Text Menu > Show Header
Regards,
Norbert
-
Scoffold_Actual_nalmai_10.3.twbx 27.8 KB
-
-
4. Re: Custom Date filter that can show last 12 months in Month and Year format in drop down
Abhishek Belnekar Dec 5, 2017 1:48 PM (in response to Norbert Maijoor)Hello Norbert,
Thanks for the reply.
What I want is this should happen inside the filter and not in crosstab. I want to have the missing values in filter.
Thanks,
Abhishek
-
7. Re: Custom Date filter that can show last 12 months in Month and Year format in drop down
Zhouyi ZhangDec 6, 2017 5:55 AM (in response to Abhishek Belnekar)
Have you opened my workbook and have a look?
or you could share yours?
ZZ
-
8. Re: Custom Date filter that can show last 12 months in Month and Year format in drop down
Norbert MaijoorDec 6, 2017 6:55 AM (in response to Abhishek Belnekar)
Hi Abhishek,
Find my "updated attempt" below and stored in attached workbook version 10.3 located in the original thread
1. M1. True/False: isnull(if attr([Number of Records])=SUM([Actuals].[Number of Records]) then attr([Date]) end)
2. Define dashboard based on two sheets of which sheet Selector is Use(d) as Filter
Regards,
Norbert
-
9. Re: Custom Date filter that can show last 12 months in Month and Year format in drop down
Abhishek Belnekar Dec 7, 2017 5:31 AM (in response to Zhouyi Zhang)Hello Zhouyi,
Can you please post it in 10.2?
-
10. Re: Custom Date filter that can show last 12 months in Month and Year format in drop down
Abhishek Belnekar Dec 7, 2017 5:33 AM (in response to Norbert Maijoor)Hi Norbert,
Can you please post your workbook in 10.2?
Thanks,
Abhishek
-
11. Re: Custom Date filter that can show last 12 months in Month and Year format in drop down
Norbert MaijoorDec 7, 2017 6:04 AM (in response to Abhishek Belnekar)
Hi Abhishek,
Find attached in version 10.2:)
Hope it helps.
Regards,
Norbert
-
Version 10.2_nalmai_10.2.twbx 40.3 KB
-
-
12. Re: Custom Date filter that can show last 12 months in Month and Year format in drop down
Zhouyi ZhangDec 7, 2017 3:42 PM (in response to Abhishek Belnekar)
Hi, Abhishek
Here you go.
ZZ
-
Sample_v10.2.twbx 1.2 MB
-
-
13. Re: Custom Date filter that can show last 12 months in Month and Year format in drop down
Abhishek Belnekar Dec 11, 2017 1:54 PM (in response to Zhouyi Zhang)Hi Zhouyi,
For you the all the dates are coming from Order Date. Thats not what I want.
For me I am getting only 4 dates in Month - year format. But I still want to show all 12 in filter.
If that is not possible then reading the current month and Year how to show 12 month in Month-Year Format in Filter dropdown.
Thanks,
Abhishek