tag:blogger.com,1999:blog-3998628784041768080.post7548009441298651141..comments2024-03-28T03:27:07.147+00:00Comments on VizWiz: Tableau Tip: Showing all dates on a date filter after a Server refreshVizWizhttp://www.blogger.com/profile/11408220384219218043noreply@blogger.comBlogger34125tag:blogger.com,1999:blog-3998628784041768080.post-23344781556422217782017-01-25T18:26:55.497+00:002017-01-25T18:26:55.497+00:00Thanks for responding. Thanks for responding. SRA Analyticshttps://www.blogger.com/profile/06461097104665605427noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-23235233082980822112017-01-10T15:58:12.418+00:002017-01-10T15:58:12.418+00:00There's no solution yet for discrete dates tha...There's no solution yet for discrete dates that I'm aware of.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-2142401677736403012017-01-05T16:22:41.456+00:002017-01-05T16:22:41.456+00:00Thanks for this blog. I see that a lot of people ...Thanks for this blog. I see that a lot of people are asking about discrete dates with no response. Is it possible to create a quick filter that will default to the most current date, while allowing users to choose other dates. SRA Analyticshttps://www.blogger.com/profile/06461097104665605427noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-62799202313465341502016-03-08T20:35:07.405+00:002016-03-08T20:35:07.405+00:00I'll jump in with my own issue, if you guys do...I'll jump in with my own issue, if you guys don't mind. I have a sheet that shows data 14 days(rows) at a time. Each segment is a pay period. The filter has only pay period end dates and as time goes by, new dates get added. However, every time the sheet defaults to the date when the workbook was last saved. I'd like to have it so that the most recent date is selected by default.Raminhttps://www.blogger.com/profile/04504572743111436307noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-71040068944826609642015-10-09T18:44:44.911+01:002015-10-09T18:44:44.911+01:00I never expected to have a reply this immediate. t...I never expected to have a reply this immediate. thank you so much and greatly appreciate your help. <br /><br />I have a "date filter?" calculated field that allows the worksheet to filter the records based on the parameter <br /><br />int(case [Select Date Field to filter ]<br /> when 1 then (<br />MIN([Date Range (SERVICE_DESK)].[OpenDate_Range]) <= MIN(DATE([Open Date]) )Anonymoushttps://www.blogger.com/profile/10864203001663317791noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-64804560753727599872015-10-08T23:51:28.691+01:002015-10-08T23:51:28.691+01:00Sri, it's very difficult to understand your si...Sri, it's very difficult to understand your situation without a more specific example.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-43390939685612497672015-10-08T22:05:39.971+01:002015-10-08T22:05:39.971+01:00I have been using this method in variations and pl...I have been using this method in variations and pleasing the customers with their needs but something recently that's pulling me in is I'm not able to display the number of records or similar summary counts in the worksheet any idea or workaround is greatly appreciated. ThanksAnonymoushttps://www.blogger.com/profile/10864203001663317791noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-32526092781188004302015-05-14T17:58:48.073+01:002015-05-14T17:58:48.073+01:00Nice work Jenny! Your method is similar to what I...Nice work Jenny! Your method is similar to what I showed during the Hack Jeopardy presentation at TC14.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-9065577996529894312015-05-14T17:27:54.399+01:002015-05-14T17:27:54.399+01:00Hi,
I am using Tableau dekstop and Tableau online...Hi,<br /><br />I am using Tableau dekstop and Tableau online. I did this way:<br /><br />1. Created a calculated field with [Date] < Today() ( in my case, I need the filer to be up to Today but you can change it to Max ([Date]) from the copied data source).<br />2. Added the calculated field to the filter shelf and choose filter to be true<br />3. Drag the [Date] to filter shelf and choose Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-20938692648869591932015-03-15T22:37:26.316+00:002015-03-15T22:37:26.316+00:00Brian, when you need to pass an action filter to s...Brian, when you need to pass an action filter to sheets that are from another data source, you need to specify the fields that are in common when you edit the action if the dimensions do not have the same name. If the dimensions DO have the same name, then note that Tableau filters the secondary data source based on the aliased names, so the names within the dimenions have to match exactly, just VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-39142685914080224902015-03-12T16:05:03.241+00:002015-03-12T16:05:03.241+00:00Andy, do you know how to make this filter into an ...Andy, do you know how to make this filter into an action on a dashboard? I've tried making an action with the filter made from a similar worksheet, but it won't commit the action to filter other worksheets on a dashboard. Would your other post here (http://vizwiz.blogspot.com/2012/06/create-global-filter-in-tableau-across.html) be applicable?Anonymoushttps://www.blogger.com/profile/05680656166519549555noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-31226619926400812802015-02-24T18:16:37.329+00:002015-02-24T18:16:37.329+00:00That does deserve an individual write up. Buried i...That does deserve an individual write up. Buried in an hour long video, is not good for search engine to index and for people to find. Alexander Mouhttps://www.blogger.com/profile/08750031316598620047noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-29130804573478745812015-02-24T15:36:54.571+00:002015-02-24T15:36:54.571+00:00Awesome. Thank you so much!Awesome. Thank you so much!Gina Smithhttps://www.blogger.com/profile/03775506256759698744noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-43070222217740592092015-02-24T01:54:35.906+00:002015-02-24T01:54:35.906+00:00Gina, go to the 23:15 mark in this video http://vi...Gina, go to the 23:15 mark in this video http://vizwiz.blogspot.com/2014/09/facebook-jeopardy.html. I just realized I haven't written this one up individually yet.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-54249973277937079582015-02-23T13:53:37.782+00:002015-02-23T13:53:37.782+00:00Thanks Andy! I'm looking around for the video ...Thanks Andy! I'm looking around for the video but cant seem to find it. Do you have a link?Gina Smithhttps://www.blogger.com/profile/03775506256759698744noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-59392111977413919932015-02-20T20:47:12.190+00:002015-02-20T20:47:12.190+00:00Not that I'm aware of. We did find an easier w...Not that I'm aware of. We did find an easier work around though which we demoed at our TCC talk. The video is on the blog. VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-86593759542226518602015-02-20T20:24:24.542+00:002015-02-20T20:24:24.542+00:00Do we know if there will be a fix for this in Tabl...Do we know if there will be a fix for this in Tableau 9?Gina Smithhttps://www.blogger.com/profile/03775506256759698744noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-58978697853622697342014-11-13T16:23:19.308+00:002014-11-13T16:23:19.308+00:00Hi Andy,
Can you please explain discrete Date qu...Hi Andy,<br /><br />Can you please explain discrete Date quick filter dynamically update and change to the most recent value when new data is added. <br /><br />ThanksAnonymoushttps://www.blogger.com/profile/06762861180426368758noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-57202500489605881952014-10-10T19:31:06.754+01:002014-10-10T19:31:06.754+01:00How you know what problem I am going to face and w...How you know what problem I am going to face and write a blog about it.<br />Great work.<br />Thanks! :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-86928728298561037952014-10-09T22:47:21.054+01:002014-10-09T22:47:21.054+01:00Open the filter, choose the last tab, and pick All...Open the filter, choose the last tab, and pick All Values. VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-72039721796495817562014-10-09T20:38:26.012+01:002014-10-09T20:38:26.012+01:00We have a similar problem, here we have "Numb...We have a similar problem, here we have "Number of Students" and number of students value changes after certain amount of time. We want slider to adjust automatically,tried above logic but not working. Please guideAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-23885720923265914432014-07-18T05:06:35.371+01:002014-07-18T05:06:35.371+01:00I tried some variations of the above design and fo...I tried some variations of the above design and found an oddity.<br />http://vizdiff.blogspot.com/2014/07/date-dimension-design-of-rolling.html<br /> <br />My data set is from an Oracle database and is updated every day. As is told in your blog, I created a 2nd data source as the reference date and unlinked it from the main data source. The date slider is then entirely dependent on the 2nd data Alexander Mouhttps://www.blogger.com/profile/08750031316598620047noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-41607178805311749132014-05-27T20:48:31.154+01:002014-05-27T20:48:31.154+01:00Joe,
I followed all 3 steps and, as you said, when...Joe,<br />I followed all 3 steps and, as you said, when I went back to the dashboard, the Date filter showed the full range of data in the data source.<br />But when I refreshed my data source the Filter instead of the slider displayed "Not available".<br />What am I missing?<br />~LeonidAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-27614883808479861242014-05-13T08:12:51.010+01:002014-05-13T08:12:51.010+01:00@Jasmeet: That will not help the current issue.. y...@Jasmeet: That will not help the current issue.. your solution will surely provide all the values however the slider will not set it self on the latest date available in the database..Addy!https://www.blogger.com/profile/13593758768097007728noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-61844699354105443252014-05-02T11:52:25.106+01:002014-05-02T11:52:25.106+01:00We were facing a similar issue today and a simple ...We were facing a similar issue today and a simple workaround worked for us. <br /><br />Edit Date/Day filter and select "Special" and then "All Dates". <br /><br />Now when workbook is refreshed when there is new data for a day then time slider moves ahead and selects all days.Anonymoushttps://www.blogger.com/profile/05460588747903172390noreply@blogger.com