-
1. Re: Action filters on date filter not working
Chinnala J Oct 10, 2018 9:37 PM (in response to Chinnala J) -
2. Re: Action filters on date filter not working
Simon RuncOct 11, 2018 1:09 AM (in response to Chinnala J)
hi Chinnala,
Is this the same problem as your other post?
Filter having month names of last 6 months using calculated fields
Your action seems to be working for me. If you can let me know what it should do when you click Go, I'll take a look (but think the Pivot Data method is much easier, if you are able to get the data in that shape)
-
3. Re: Action filters on date filter not working
Chinnala J Oct 11, 2018 3:28 AM (in response to Simon Runc)Yes Simon. Its the same one..
On clicking go, data in ”Updated” view shud be filtered based on month filter selected. Also month filter shud be sorted based on date type I.e. jan 2018, feb 2018, etc and not based on string type i.e. Alphabetically
-
4. Re: Action filters on date filter not working
Simon RuncOct 11, 2018 4:16 AM (in response to Chinnala J)
and just to double check!
The Month filters needs to filter the Updated Date on the Update Sheet and the Deleted Date on the Deleted Sheet?
-
5. Re: Action filters on date filter not working
Chinnala J Oct 11, 2018 4:35 AM (in response to Chinnala J)Correct
-
6. Re: Action filters on date filter not working
Simon RuncOct 11, 2018 4:47 AM (in response to Chinnala J)
Could well be me...but it looks like it's working!!
I've attached a GIF of it in action (the file I've downloaded from the thread) and it's sorted in the right order and when I use it it seems to show the right information
-
Action Filter Community.gif 465.3 KB
-
-
7. Re: Action filters on date filter not working
Chinnala J Oct 11, 2018 5:03 AM (in response to Simon Runc)Not sure why it isnt working for me.. can you copy the version you are using, Simon? may be if it’s same.. There is some magic in your pc
-
8. Re: Action filters on date filter not working
Simon RuncOct 11, 2018 5:11 AM (in response to Chinnala J)
1 of 1 people found this helpfulNow that's the kind of question/answer I like...I just have to open the file on my magic PC!! I don't think I've done anything to the file (I've resaved it, adding a _sr affix)
I'm using in T2018.2
Also let me know if you want to go down the pivot route? Either using your SQL skills, or those in your company...and failing that I can probably* write you out the query (if you let me know what database you are using)
* I've used quite a few databases, so if it uses standard SQL I should be able to help.
-
9. Re: Action filters on date filter not working
Chinnala J Oct 11, 2018 8:17 AM (in response to Simon Runc) -
10. Re: Action filters on date filter not working
Simon RuncOct 11, 2018 8:34 AM (in response to Chinnala J)
very strange. It works on my version (which is exactly the same one I posted back)
In the attached GIF you can see me go into each of the sheets and check the Action Filter is sending August 2018...does yours look like that when you do the same
-
Action Filter Community2.gif 297.5 KB
-
-
11. Re: Action filters on date filter not working
Chinnala J Oct 11, 2018 9:08 AM (in response to Simon Runc) -
12. Re: Action filters on date filter not working
Chinnala J Oct 11, 2018 10:38 AM (in response to Chinnala J) -
13. Re: Action filters on date filter not working
Joe OppeltOct 11, 2018 11:25 AM (in response to Chinnala J)
In the attached (I downgraded this to test on an older version to see if there was some new behavior) I took off the formatting on the [Month Filter] and [DateUpdatedCalc] calcs. Now they display the full internal value of the respective dates.
I get empty sheets, just like Chinnala reports, both on 2018.3 and on 10.5.
The Month Filter dates all have 30 for the day portion of the date. the [Date Updated Calc] values all have 1. Nothing will ever match that way.
Formats don't change the internal values, and that's what Tableau is using in the action filter.
-
14. Re: Action filters on date filter not working
Joe OppeltOct 11, 2018 11:40 AM (in response to Joe Oppelt)
In the attached I added a calc to do a datetrunc on [Month Filter]. This changes the value to MM/01/YYYY.
You can use that instead.
But there was an additional change I needed to make. I have displayed the value of Calculation1 on the GO sheet. Initially it was always 10/1/2018 no matter what I set the filter to.
I changed the calc settings for Calculation1 to run along ID rather than Table(down) on the GO sheet. Now when you select a value, you get the proper value displayed on the GO sheet, and that value gets passed to the Update sheet. (See filter 3, by the way.) Previously it was always passing October no matter what you set the filter to, and there are no October rows here. So you get the blank sheets.