tag:blogger.com,1999:blog-3721871707048712457.post266620979473878724..comments2024-03-28T00:39:48.395-04:00Comments on Breaking BI: Creating Histograms in TableauBreaking BIhttp://www.blogger.com/profile/02551920506874509998noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-3721871707048712457.post-25917921354256054292013-08-27T14:10:39.012-04:002013-08-27T14:10:39.012-04:00You can change the parameter to be whatever value ...You can change the parameter to be whatever value fits your data best. I just chose 2000 because it worked.Breaking BIhttps://www.blogger.com/profile/02551920506874509998noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-88863768462406458672013-08-27T12:32:27.457-04:002013-08-27T12:32:27.457-04:00This is really helpful. One question: why did you ...This is really helpful. One question: why did you set the current parameter value at 2,000?Katy S.https://www.blogger.com/profile/05441346310848098969noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-76025200877403695632013-07-15T07:05:48.274-04:002013-07-15T07:05:48.274-04:00Thanks Brad for the answers. Thanks Brad for the answers. Anonymoushttps://www.blogger.com/profile/17229675190545898395noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-10362831491920397592013-07-11T10:50:50.502-04:002013-07-11T10:50:50.502-04:00Basically, when you have Number of Observations, i...Basically, when you have Number of Observations, it returns 1 for every customer in that bin. Then, when you place customer on the detail shelf, it stacks all of these 1's on top of each other, giving the illusion of a bar.<br /><br />For Step 5, I had 2 discrete measures, Profit Bin and Profit Bin (Corrected). Placing both of these on the columns shelf allowed us to see what they have in common.Breaking BIhttps://www.blogger.com/profile/02551920506874509998noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-32864884193474580642013-07-11T10:32:05.450-04:002013-07-11T10:32:05.450-04:00Thanks Brad. That is a pretty good explanation. I ...Thanks Brad. That is a pretty good explanation. I understood Step 2 now.<br /><br />But I do not understand the need for the [Number of Observations] calculated field. In other words, you have to explain how the Step 4 is actually interpreted by Tableau as that is where you are using this 1 to count the number of customers. <br /><br />On step 5, how did you get the 2 profit bins to display side-by-side. No matter what I tried i could not get to this view. <br /><br />Also, when I did step 5 as per your instruction, I did not get this chart. Then I changed the mark type to bar to get this. Anonymoushttps://www.blogger.com/profile/17229675190545898395noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-20753499853275476242013-07-11T07:07:54.291-04:002013-07-11T07:07:54.291-04:00Siraj,
In step 2, I needed to code the following ...Siraj,<br /><br />In step 2, I needed to code the following scenario<br /><br />Create a set of discrete marks at every [Bin Size], i.e. 1 * [Bin Size], 2 * [Bin Size], etc. Then, if an observation is between two bins, which is almost always will be, place it in the lower bin.<br /><br />What I did was simply a simple mathematical way to achieve that using truncation.<br /><br />As far the [Number of Records] goes, you could easily replace it with 1 and nothing would change. In fact, there is a better way to using SIZE() that I've started using.Breaking BIhttps://www.blogger.com/profile/02551920506874509998noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-92204960261241792402013-07-11T06:09:24.112-04:002013-07-11T06:09:24.112-04:00Hi Brad, I am new to Tableau. Sorry if I ask basic...Hi Brad, I am new to Tableau. Sorry if I ask basic questions. <br /><br />Can you explain the calculations in Step 2 and Step 3? What is the purpose of multiplying by bin size in step 2 and what is the purpose of the number of observations which always returns 1 - or does it? If I just substitute 1 as a hardcoded value there, what happens?Anonymoushttps://www.blogger.com/profile/17229675190545898395noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-37614042092437690142013-06-24T11:05:05.061-04:002013-06-24T11:05:05.061-04:00Thanks Jonathan.Thanks Jonathan.Breaking BIhttps://www.blogger.com/profile/02551920506874509998noreply@blogger.comtag:blogger.com,1999:blog-3721871707048712457.post-56698810877290919112013-06-24T11:01:06.567-04:002013-06-24T11:01:06.567-04:00Hi Brad, I saw your link to this post and the ques...Hi Brad, I saw your link to this post and the question on how to get the total number of observations in each bin, the key is to uncheck the "Ignore in Table Calculations" option on the discrete (Sum) Profit Bin (corrected) measure. I set it up with a couple of other optimizations in this view: http://public.tableausoftware.com/views/histogramwithcustomeronLoD/mostaccurate.Anonymoushttps://www.blogger.com/profile/07246437048304077347noreply@blogger.com