tag:blogger.com,1999:blog-3998628784041768080.post3581838321723835427..comments2024-03-28T03:27:07.147+00:00Comments on VizWiz: Tableau Tip Tuesday: Using LOD Calcs to Sort by the Total of the Last N DaysVizWizhttp://www.blogger.com/profile/11408220384219218043noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-3998628784041768080.post-9374451803713690262016-01-16T08:03:13.713+00:002016-01-16T08:03:13.713+00:00Awesome Bridget!!! Thanks for sharing and thanks f...Awesome Bridget!!! Thanks for sharing and thanks for improving my work!VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-80230615482675425622016-01-16T05:41:18.467+00:002016-01-16T05:41:18.467+00:00Cool trick! You requested, so I played with this ...Cool trick! You requested, so I played with this and changed the calc to: {INCLUDE: SUM(IF [In Last N Days?]=TRUE then [Sales] END) }. The include makes it responsive to whatever you have within your view and allows you to sum like normal. Putting the calc inside the aggregation filters it only to the last N days. I ran a few spot checks and it seems to work.<br />My crazy takes on LODs are Bridgethttps://www.blogger.com/profile/08960840345595234339noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-84890040885200600492016-01-06T00:17:02.583+00:002016-01-06T00:17:02.583+00:00Andy, thank you!
Please, why we should use Min fu...Andy, thank you!<br /><br />Please, why we should use Min function to wrap IF statement?Anonymoushttps://www.blogger.com/profile/14915923505805048361noreply@blogger.com