tag:blogger.com,1999:blog-3721871707048712457.post709947538276880594..comments2024-03-28T00:39:48.395-04:00Comments on Breaking BI: Using the LOOKUP() function in TableauBreaking BIhttp://www.blogger.com/profile/02551920506874509998noreply@blogger.comBlogger59125tag:blogger.com,1999:blog-3721871707048712457.post-35312312324845402792018-04-17T19:24:26.865-04:002018-04-17T19:24:26.865-04:00Hi
What if you want the value in to return multi...Hi <br /><br />What if you want the value in to return multiple values. I am trying to figure out a financial heirarchy and one value = 4 values to give me a accurate total. Apologies for non-technical description. I am still learning.<br /><br />ConnieAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-13401360958341708792018-02-24T09:48:54.528-05:002018-02-24T09:48:54.528-05:00Hi Can someone help me on finding the greater meas...Hi Can someone help me on finding the greater measure among two columns. i have a formula for row wise written,need for Column wise formula<br /><br />Row wise calculation for color coding :<br />lookup(SUM([Profit]),0)>lookup(Sum([Profit]),1)Madhuri Adorable girlhttps://www.blogger.com/profile/16455452526885307260noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-37001831644032628072018-02-18T03:51:10.316-05:002018-02-18T03:51:10.316-05:00Good day! I could have sworn I've been to this...Good day! I could have sworn I've been to this <br />website before but after reading through some of the post I realized <br />it's new to me. Nonetheless, I'm definitely glad I found it and I'll be book-marking and checking back often!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-9039358729659030962017-11-15T04:45:55.712-05:002017-11-15T04:45:55.712-05:00Hello Brad,
I want to display the previous year vs...Hello Brad,<br />I want to display the previous year vs current year records,growth,lose everything.I am in situation where i select the particular year that year shows the all records as well as previous records also and show there is growth or lose.Is this things is possible by lookup.how we achive this things.Thanks your help is appreciated<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-34939077081024173752017-09-15T15:27:26.239-04:002017-09-15T15:27:26.239-04:00Hi , I have a situation where using custom SQL I h...Hi , I have a situation where using custom SQL I have got the data from two tabs. Now I have to get the count of those rows which matches from one tab to other . Will I be able to use lookup functionParashttps://www.blogger.com/profile/17821587610055372505noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-85017070019112843102017-06-11T11:30:06.869-04:002017-06-11T11:30:06.869-04:00Great post Brad - and I realise it's a little ...Great post Brad - and I realise it's a little old now.<br />Any thoughts on how to retain the wider indexing when action filtered down to specific subgroups that don't have data in recent dates? The lack of data causes the index to be shorter!Bangsheadagainstwallnoreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-18761634333015642392017-01-11T00:05:23.454-05:002017-01-11T00:05:23.454-05:00An way to do this WITHOUT a time series pill? Ju...An way to do this WITHOUT a time series pill? Just in filterAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-50475560617233081882016-07-27T11:21:41.100-04:002016-07-27T11:21:41.100-04:00I have columns that are labeled as follows: 1, 2, ...I have columns that are labeled as follows: 1, 2, 3, 4, 5, 6, 12<br />I then have to cost amounts in the rows. I am trying to make one of those cost amounts to shift one to the right. <br />The problem is that the number in 12 disappears. I have tried:<br />LOOKUP([cost], -1) as well I have tried<br />IF Period = 12 THEN LOOKUP([cost],6) ELSE LOOKUP([cost],-1) END This did not work for me either, because it ended up making the column 12 cost disappear.<br />Any help please?Anonymoushttps://www.blogger.com/profile/05309963149279156697noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-75314746656181340162016-07-14T11:58:32.637-04:002016-07-14T11:58:32.637-04:00Hello,
I am trying to figure out what to do if I...Hello, <br /><br />I am trying to figure out what to do if I have to lookup an account number during a time span of a month and see if its repeated. So if I have an account number on july 1 2016, I have to find if its repeated during the 28 days prior to july 1. <br /><br />Thanks to anyone that could help me. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-91152050103129305352016-03-31T13:59:40.429-04:002016-03-31T13:59:40.429-04:00Hi, thank you for this post. very helpful. have qu...Hi, thank you for this post. very helpful. have question. I got last year value with this year value but when I filter year as current year, last year field shows null. anyway I can keep last year value by filtering to current year?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-44537838122390052502016-03-08T05:54:23.700-05:002016-03-08T05:54:23.700-05:00Hi Brad,
Display Last Week Sales of each and ever...Hi Brad,<br /><br />Display Last Week Sales of each and every country for every month in the form of a map. Restart every Month.Anonymoushttps://www.blogger.com/profile/16692959842965426327noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-84279623737755584542016-02-02T15:38:18.667-05:002016-02-02T15:38:18.667-05:00Hi Brad,
Congrats on the site: it's very hel...Hi Brad, <br /><br />Congrats on the site: it's very helpful!<br />Maybe you can help me on this issue... I need to display last year's sales value for today's month. By creating a lookup calculated field, I get the figure I need for all months. But I only want to display (and calculate comparison values) for today's month. And, of course, using a date filter breaks my lookup (if I display only current month, then 12-month-ago data are not available to be looked up)...<br /><br />I've thought about using "Fixed" level-of-details, but then, I couldn't find any compatible "lookup" function. <br /><br />Any idea?Anonymoushttps://www.blogger.com/profile/03574019151924513681noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-38527612185567673742016-01-14T07:05:03.947-05:002016-01-14T07:05:03.947-05:00For order management data in Tableau, a calculatio...For order management data in Tableau, a calculation between columns plus rows is to be done. I'm trying to bring up all the observations in Tableau (a row represents a single order identified by order id) to show orders which are potentially rebooked.<br /><br />The rule is that if for cancelled orders by a specific customer for a specific product type are placed again within a week, then they are potentially rebooked. For this, difference between order closing date for any cancelled order and order creation date for a fulfilled order are to be calculated if they are by same customer for same product type.<br /><br />So, a calculation between columns (order closing date and order creation date) has to be done between rows (cancelled and fulfilled order if customer and product type are same).<br /><br />Every row represents a unique order and has an order id, customer, product type, cancelled or non cancelled code, order entry date and order closing date. How can this be done in Tableau?abhinav singhhttps://www.blogger.com/profile/10664006373870756097noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-4318160425139305352015-12-22T04:43:54.720-05:002015-12-22T04:43:54.720-05:00Hi Brad,
Awesome Post
How you mixed up the Quart...Hi Brad,<br /><br />Awesome Post<br /><br />How you mixed up the Quarters, I mixed up the Quarters on month basis so that each quarter has non repeating month but i didn't get the result...<br />Please Help me OutAnonymoushttps://www.blogger.com/profile/00680189593834242178noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-53358218514715767522015-11-09T00:38:46.929-05:002015-11-09T00:38:46.929-05:00Hi, I have a doubt.I have a column called retailer...Hi, I have a doubt.I have a column called retailers and I have pulled it in my columns.I have a sales column.when I pull it, I get sales across all the retailers.Now I want sales across all the retailers with respect to just the first retailer.That is by how much they are more or less wrt to first retailer in the view.obiiihttps://www.blogger.com/profile/01953930764233921524noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-83609586768961573432015-08-16T07:57:50.632-04:002015-08-16T07:57:50.632-04:00Awesome Post Brad .. v Helpful .. thanks :)
Awesome Post Brad .. v Helpful .. thanks :)<br />Anonymoushttps://www.blogger.com/profile/08267720120346381198noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-48470599935472709292015-03-29T08:45:44.467-04:002015-03-29T08:45:44.467-04:00I want to replace Null values with N/A,can you ple...I want to replace Null values with N/A,can you please help me in this,as far as i know we need to create a calculated field using IFNULL,.what is the exact command?<br />pavannoreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-57474356103766796592015-03-06T03:43:40.216-05:002015-03-06T03:43:40.216-05:00I've a customer level data with fields like lo...I've a customer level data with fields like location, region, purchase made flag with values 1 & 0. Now I want to derive a field (ratio) on a monthly basis which is sum(purchase made flag) / total customers of previous month.<br />I'm using the LOOKUP function in tableau and have created a formula which is<br />sum(Purchase made flag) / LOOKUP (count[customer]), -1). The formula works fine when I put MONTH variable in row but whenever I choose a new dimension (e.g. region) the values are derived as per that dimension. Also, if I select only one value of MONTH (in filter), the value comes out to be blank.<br /><br />Is there a way in tableau to calculate the above field only through the MONTH dimension. Once the value is derived I want to use other variables as filters or i BAR/circle graphs. <br />So lets suppose, the Ratio figure for Mar is 25%, so I'll use country and show how this 25% is distributed across different countries for Mar. Anonymoushttps://www.blogger.com/profile/10207226632184412888noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-63833765739219990772014-12-22T17:08:39.288-05:002014-12-22T17:08:39.288-05:00Kate,
I apologize for my delayed response. It...Kate,<br /><br />I apologize for my delayed response. It's been a hectic month. What you're asking for should be easily accomplished by adding 2 pills to your Columns Shelf. The first pill will be MONTH( [Date] ) and the second pill will be DAY( [Date] ). Then, you would put SUM( [Delivered] ) on the Rows Shelf. Finally, you would add YEAR( [Date] ) to the Colors Shelf. Does this make sense?Breaking BIhttps://www.blogger.com/profile/02551920506874509998noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-73062219755060420992014-12-08T11:50:02.886-05:002014-12-08T11:50:02.886-05:00Hi Brad,
Great posts!
I am currently struggling w...Hi Brad,<br /><br />Great posts!<br />I am currently struggling with comparing 2014 and 2013 daily delivery. Using a line graph I need to display how we delivered on a particular day in 2013 and in 2014. Tableau does enable monthly comparison, but I cannot get it to display day and month comparison.<br /><br />I'm envisioning x-axis displaying day number and month, starting with December 1, and having years as color coded lines. Any suggestions on this?<br /><br />Thanks a lot in advance!<br /><br />Katehttps://www.blogger.com/profile/09764228219357061530noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-79161895885513790512014-10-30T08:46:35.699-04:002014-10-30T08:46:35.699-04:00Mayank,
Thanks for commenting. The issue you are...Mayank,<br /><br />Thanks for commenting. The issue you are describing is quite a complex one. Let me ask you one question first. Are you trying to create a single value that is Distinct Count of Users in the 5 days previous to Today? Or, are you trying to create a chart that shows the Distinct Count of Users within 5 Days for EVERY day (not just today)? Does this make sense?Breaking BIhttps://www.blogger.com/profile/02551920506874509998noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-3338796021804767882014-10-29T15:40:11.604-04:002014-10-29T15:40:11.604-04:00Hi Brad .. interesting post. I was searching for k...Hi Brad .. interesting post. I was searching for kind of a rolling count and stumbled upon this article.<br /><br />I need to count distinct users active in the last 5 days. Active users are defined as users that have atleast one signal data in the last 5 days. I need to create this data on a day by day basis. To me it seems like a database side fix, but is there something you can advice on Tableau?<br />The table structure looks somewhat as below -<br /><br />USER SIGNALTIME<br />----- ---------------<br />100 2014-07-29 12:15:00<br />100 2014-07-29 12:45:00<br />101 2014-08-05 12:24:00<br />100 2014-08-06 12:24:00<br />103 2014-08-07 12:25:00<br /><br />Thanks,<br />MayankMayanknoreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-49005513108526614602014-10-20T10:02:19.060-04:002014-10-20T10:02:19.060-04:00Vibin,
Thanks for commenting! That's a prett...Vibin,<br /><br />Thanks for commenting! That's a pretty common issue and the approach depends on your goal. Could you explain a little further what the chart is supposed to look like and how it should function?Breaking BIhttps://www.blogger.com/profile/02551920506874509998noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-89012895292669332902014-10-20T02:52:37.748-04:002014-10-20T02:52:37.748-04:00I wanted to use this look-up for a month calculati...I wanted to use this look-up for a month calculation. For eg if i select in filter the month as January, the dashboard should show the data for months beyond January.VIBIN M VENUGOPALhttps://www.blogger.com/profile/05083975143450755135noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-61963454202676746182014-10-01T16:31:33.044-04:002014-10-01T16:31:33.044-04:00Haha! Now you're getting it. Good luck.Haha! Now you're getting it. Good luck.Breaking BIhttps://www.blogger.com/profile/02551920506874509998noreply@blogger.com