tag:blogger.com,1999:blog-3721871707048712457.post4035394304337182634..comments2024-03-28T00:39:48.395-04:00Comments on Breaking BI: Creating Table Calculations on Values outside of the Filter Range in TableauBreaking BIhttp://www.blogger.com/profile/02551920506874509998noreply@blogger.comBlogger24125tag:blogger.com,1999:blog-3721871707048712457.post-89283811802769588152018-03-06T00:54:11.143-05:002018-03-06T00:54:11.143-05:00Hi Brad, is there any way I only display the value...Hi Brad, is there any way I only display the value of the 12month rolling number only for the latest month or the month I select from a parameter of date. I am stuck with this for more than 5 days now.<br /><br />Basically just wanted to show the value of the 12month rolling for any given month based on what I select through a parameter. Looking to hear from youDibyendu.Sharmahttps://www.blogger.com/profile/00791162948964563220noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-39669741088825304902018-02-28T06:44:32.141-05:002018-02-28T06:44:32.141-05:00I've had a go at using this for calculating Th...I've had a go at using this for calculating This Year v Last year, and it appears to work. I have Order date, down to a month level and the Sum([Sales]) as the figure.<br /><br />I want to be able to change the length of time to look at, so I created a Parameter to be able to change the '36' in the Index filter you've created. Which seems to work ok, but what if I want to aggregate it up so that I don't see the Years and Months listed?<br /><br />Basically I want to see Total Sales and vLY set by the parameter of how many months I select. E.g. if today is 28th Feb, and the parameter is select as last 6 months, I want to see Total Sales from 1st Sep 2017 to 28th Feb 2018 and the vLY to show % difference compared to 1st Sep 2016 and 28th Feb 2017.<br /><br />How would you go about this?<br /><br />Thanks. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-3002308356399611232016-12-20T11:01:41.123-05:002016-12-20T11:01:41.123-05:00Excellent thankyouExcellent thankyouAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-79318822005701525702016-09-30T00:12:47.605-04:002016-09-30T00:12:47.605-04:00Hi.
I tried using the LOOKUP function instead of I...Hi.<br />I tried using the LOOKUP function instead of INDEX. But the issue I'm facing is that when I place the calculated field on the filter shelf. When I show the filter, there is a value "#Missing" populating in the filter values. How do I solve this?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-7506810940975205242016-07-27T11:24:18.606-04:002016-07-27T11:24:18.606-04:00Hi Brad,
Great stuff! really Helpful
I have a fol...Hi Brad,<br />Great stuff! really Helpful<br /><br />I have a follow up question on the 12-Month Rolling Average.<br /><br />I want to see the "AVERAGE" of a rolling 12 Month SUM<br />See my example question below:<br />https://community.tableau.com/thread/211893<br /><br />What's your approach on this?<br /><br />Thanks in advance<br /><br />Tharushi<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-81341809607840023992016-06-08T22:35:19.196-04:002016-06-08T22:35:19.196-04:00Intuitively what is this calc doing? Also, is the...Intuitively what is this calc doing? Also, is there a way to incorporate this with another year filter? For example, if I want to filter every sheet on a dashboard to only show 2015 data, but I want to compare year-over-year on a specific sheet (i.e see both 2015 and 2014)? Ryan Chasehttps://www.blogger.com/profile/14230899073261275044noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-50795801053087389562016-03-01T00:19:01.257-05:002016-03-01T00:19:01.257-05:00Hi
I have a very doubt in Whiskars plot,would yo...Hi<br /><br />I have a very doubt in Whiskars plot,would you suggest to post a simple example of Whiskars PlotAnonymoushttps://www.blogger.com/profile/01960363056132693299noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-79068933486824659012015-11-06T14:41:40.884-05:002015-11-06T14:41:40.884-05:00hi
i have a parameter which has category values. ...hi<br /><br />i have a parameter which has category values. i want to show for each category , only its sub-categories sales percentage in pie chart. can you help me?Anonymoushttps://www.blogger.com/profile/16907007971098014670noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-12176796462612743222015-10-07T15:39:24.407-04:002015-10-07T15:39:24.407-04:00Hey, Awesome post!
My data has fields: Date Purc...Hey, Awesome post!<br />My data has fields: Date Purchased, Country Tickets_Purchased, MyTickets, Others Tickets, Total Tickets sold<br />I have created calculated fields to compare last week sales to this week sale % using DATEDIFF.<br />Now when I pull Country to filters and filter desired country the % shows 0.00000%.<br />Please help me tackling this problem.Anonymoushttps://www.blogger.com/profile/06912959271022117741noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-4100635073526692172015-04-17T12:18:33.257-04:002015-04-17T12:18:33.257-04:00Thanks Brad - is there a way of defining that numb...Thanks Brad - is there a way of defining that number (36) by a parameter? By that I mean, I have a date, after which I want to see the data. I don't know the index of that date. Can I calculate the index of the date or is there any other table calculation function that can help me get the right data for my view? IE, the parameter will say 2012,2013 etc and the data is going to be filtered accordingly.<br /><br />Thank you Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-5002610847161642852015-04-15T06:26:22.349-04:002015-04-15T06:26:22.349-04:00Hi, I am hoping to be able to get some help on a s...Hi, I am hoping to be able to get some help on a similar issue I have where I need to do calculations on values outside of the filter results.<br /><br />I have MY(Date) on the filter shelf and the resulting table will show all the values for the different variables for the selected month. I need an additional column to show the % difference from the selected month and the previous month for a particular variable. I am having some problems trying to apply the solution to my context and will appreciate any help! <br /><br />Thank you so much! Celestinenoreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-63470586015078113332014-07-04T03:18:30.349-04:002014-07-04T03:18:30.349-04:00Thank you!Thank you!Anonymoushttps://www.blogger.com/profile/17480390097257182315noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-8490206439713499172014-05-13T09:17:17.336-04:002014-05-13T09:17:17.336-04:00Thanks for commenting! This is where "Comput...Thanks for commenting! This is where "Compute Using" comes in. You can refer to this post for information on how to use "Compute Using".<br /><br />http://breaking-bi.blogspot.com/2013/07/introduction-to-table-calculations.html<br />Breaking BIhttps://www.blogger.com/profile/02551920506874509998noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-21381042833990968712014-05-13T09:13:16.588-04:002014-05-13T09:13:16.588-04:00Hi Brad, Great post. Do you have experience creati...Hi Brad, Great post. Do you have experience creating graphs that display the current and historical average WITHIN a category rather than across categories? This seems simple but I can't find a way of calculating this in Tableau...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-90602476101715942832014-05-06T08:13:27.160-04:002014-05-06T08:13:27.160-04:00If you create a calculated field for
LOOKUP( MIN(...If you create a calculated field for<br /><br />LOOKUP( MIN( YEAR( [Order Date] ) ), 0 )<br /><br />You can drag it onto the filters and filter for the year you want. Your second question is a little more complex. However, the technique in this post shows you how to use window_sum to look at values that you can't see (i.e. not in the year window you are looking at).Breaking BIhttps://www.blogger.com/profile/02551920506874509998noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-76154919084463788202014-05-06T06:51:51.627-04:002014-05-06T06:51:51.627-04:00I'm really new to Tableau and I really thank Y...I'm really new to Tableau and I really thank You, for such a good blog. As I am new I didn't figured out, how this LOOKUP( MIN( YEAR( [Order Date] ) ), 0 ) could be used instead. How exactly?<br />And in your other post you write "The LOOKUP() function allows you to find values that exist elsewhere in your table, or not in the table at all" Do you know example, where LOOKUP is used to find values that are not in the table at all?<br />Thank you anyway :) You seem really good expert on TableauBI huvilinehttps://www.blogger.com/profile/00302782177619483675noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-5548818830672679332014-04-18T13:23:18.510-04:002014-04-18T13:23:18.510-04:00Perhaps I'm misunderstanding but that's pr...Perhaps I'm misunderstanding but that's precisely what I do in the post.Breaking BIhttps://www.blogger.com/profile/02551920506874509998noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-27361092688702030552014-04-18T10:37:22.112-04:002014-04-18T10:37:22.112-04:00How do i display the Running Total calculation for...How do i display the Running Total calculation for last 12 months Irrespective of year eg: apr 2013 - apr 2014. Anonymoushttps://www.blogger.com/profile/12610892258261742269noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-87835438023024599662014-01-30T12:36:58.066-05:002014-01-30T12:36:58.066-05:00Thanks for commenting! Please check out the follo...Thanks for commenting! Please check out the following link, it should help.<br /><br />http://www.speedyshare.com/ZbcAc/Top-5-This-Year.twbx<br /><br />This is a simple mock-up of what I understand your question to be. Let me know if this helps!Breaking BIhttps://www.blogger.com/profile/02551920506874509998noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-35553250235621202362014-01-30T11:45:16.573-05:002014-01-30T11:45:16.573-05:00Hey my data has both TY and LY figures. I want to ...Hey my data has both TY and LY figures. I want to use the index function only on TY figures and display top 5 dynamically (both TY and LY number for which TY falls in top 5 segment) based on a selection in paramater. However, index function is ranking Ly and Ty numbers separately and so some fields come up wher LY has rank lesser than or equal to 5. Is it possible to use index function conditionally on only TY numbers?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-57570163659587494992013-03-30T21:01:58.795-04:002013-03-30T21:01:58.795-04:00No matter how much I learn, you always seem to tea...No matter how much I learn, you always seem to teach me something new. Thanks :DBreaking BIhttps://www.blogger.com/profile/02551920506874509998noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-59008557180958984302013-03-30T20:28:21.588-04:002013-03-30T20:28:21.588-04:00Another option that may be more intuitive than fil...Another option that may be more intuitive than filtering on Index is to filter on a calc field like:<br />LOOKUP(MIN(YEAR([Order Date])),0)<br />keeping only the year that you want.Joe Makohttps://www.blogger.com/profile/15643500270169278424noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-69556507787601736682013-03-29T08:17:51.308-04:002013-03-29T08:17:51.308-04:00Glad I could help. If you find any other situatio...Glad I could help. If you find any other situations that you can't seem to solve, or find a clever solution. Let me know so that we can spread the word. Enjoy!Breaking BIhttps://www.blogger.com/profile/02551920506874509998noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-73262485451727651332013-03-28T18:40:41.626-04:002013-03-28T18:40:41.626-04:00This was exactly what I needed to drive my calcula...This was exactly what I needed to drive my calculations based on most current month! Thank you!Anonymousnoreply@blogger.com