Issue#9: Tableau - Funnel chart

  • After searching the net for some time for funnel charts Tableau solutions, I found that the proposed solutions were still
    missing something: from not being too much of a funnel visually, to some labeling issues, and to a bigger problem - that is the limitation of having the values progressively decreasing from top to bottom (else the funnel would look funny). And in a sales pipeline case, where the opportunities move from one stage to the next, the total amounts by each stage do not necessarily decrease from top to bottom.

     

    I am aware that the funnel chart may not be the best solution to visually represent your data, but if your boss/client really wants it, you may have to deliver. So here is the solution that I implemented in order to draw a funnel chart in Tableau that does not have any
    of the above specified issues. There may be some other that I did not see yet…
     

     

    Please feel free to use it and tune it up if need it. Attached you will find the solution files.
     

    0 Answers

    Sorry, your answer is too short !

  • Issue#583091: Tableau - Educational Brain Teaser - Funnel Chart with Labels

    There have been a number of posts about Funnel Charts... like many chart types in the land of data viz, they can be a bit involved to set up and are sometimes difficult to interpret. Need to show the data on Funnel chartArea chart all one colorRe: How do I do something like this?Re: Building an opportunity pyramid Tableau even has an instructional video that is pretty good to get started (although I really don't like the Gantt step at the end): Funnel Charts | Tableau Software Here's my contribution toward a 'better' Funnel Chart with labels that (hopefully) make the view easier to set up, more informative, and easier to interpret.  This was all done on a single worksheet - cobbling together multiple views onto a dashboard IS NOT ALLOWED and will be grounds for disqualification   The inner 'bold' funnel shows active candidates currently moving through a hiring process.  The outer 'shadow' funnel represents active + rejected candidates that h

  • Issue#701882: Tableau - Waterfall Chart Issue

    Please find the attched file ,it shows the what i am expected. I want to comparing the jan'2015 sales with jan'2016 with bridge product subcategory....

  • Issue#875100: Tableau - How to create funnel chart using multiple fields?

    Hi Is it possible to create funnel chart using multiple fields (like emails sent, emails delivered, emails open, etc). I am trying to create a funnel view, but no luck till now. can anyone help?

  • Issue#20: Tableau - Aggregation issue

        Hello all, I just want to begin by saying how much this forum has saved my job! Thanks everyone! I am having an issue getting my values to aggregate properly. I have attached two pictures below to help explain:BEFOREAFTERThe problem is that when I remove a dimension, the values are not aggregating properly. Each Facility and Cost Center should have 1 App attached to it and taking away Summary Pay type should not aggregate those Apps. Once I take away Cost Center, then they should begin to aggregate. I can use MAX() but then it keeps the same value when I get rid of cost center and I would want that to be Summed. The end goal of this is to track Dollars/App By facility and able to drilldown to cost center, then summary pay type and another layer of fidelity that I may add in. Thanks!

  • Issue#95: Tableau - Shift bar chart axis zero point

    Hi, I have a bar chart that shows the sum of sales. The idea is that there is a minimum target (e.g. €50m). The requirement is not to show a reference line at €50m but rather to have the sales start at -€50m so when sales hit €50m the zero-point for that year is reached.Simply substracting 50m from the total sum obviously does not work since this will just reduce the total sum and not shift the bar. Any input on how this can be achieved is much appreciated. Here is a graphical illustration:  Many thanks in advance,Philipp

  • Issue#11084: Tableau - How can I show two running sums in bar charts and the sum of them as a line chart in one c

    Currently, I have two running sums of two groups of data. Also, I have a calculated field showing the sum of these two running sums. As a result, I have a picture shown below: Now is there any ways for me to combine the sum of two running sum into one coordinate?It seems like Tableau only allows me to synchronize the axis when dealing with two calculations but not three. Could anybody help with this problem? Any tips will be appreciated. Thank you.

  • Issue#16418: Tableau - How to make gantt chart using SSAS as datasource

    Hello everyone, I want to know if it is possible to make gantt charts using SSAS cube as a datasource. After some inventigation about how to make gantt charts in Tableau I found there is necessary to use a calculated field with this value (for example):  DATEDIFF('day',[Order Date],[Ship Date])  Build a Gantt Chart  How to apply this if my datasource is SSAS? Or what I need to do in the cube in order to get this. Do you know a workaround for this? Thanks in advance for your reponse.David

  • Issue#18723: Tableau - Can a line chart display gaps when there are outliers?

    Is it possible to show a gap in a line chart? I would like to have my line chart be discontinuous.TWBX file is attached.As seen in the first chart below, there is a spike in the readings. This is when the data logger malfunctioned.Can I suppress the display of the line during that time interval? The desired result is shown in the second chart below (this was done in Snag-It).I don't want to alter the data. Simply want to show no data points during specific time intervals.    

  • Issue#20248: Tableau - how to create a stacked bar chart with threshold indicators

    Hi all, New to Tableau - have an interesting stacked bar chart with threshold indicators on top of the bar charts.  Is it possible to reproduce this (originally in Excel) in Tableau? How to do that?

  • Issue#21518: Tableau - Bar chart comparing company sales and competitors' average sales

    I'm trying to create a barchart that compares the sales of a selected company with the average sales of competitors I have a dataset where each record is a sale.  I would like to create a barchart where the user selects the total unit sales for a target company in a particular week.  Additionally, the user also selects competitors from another drop-down menu.  This selection calculates the average unit sales of the competitors and this bar is displayed to next to the original one. I've played around with this a bit and have confused myself. First, I referred to this http://kb.tableau.com/articles/knowledgebase/summary-and-detail-60 article.  I set up the worksheet in the following fashion.  I have parameters on the Company and Week field.  I create a calculated field which is set to 1 if week = parameter, 0 otherwise.  I do not use Quick-Filters because I need the week to apply to all worksheets in the dashboard.  I drag this

  • Issue#25779: Tableau - How to change Columns name in chart level

    Hi ,i am new to Tableau,,,how to change Dimension name in chart?here i want to change "segment" to "Dim1".PFA.....

  • Issue#34377: Tableau - Registration Funnel Variants

    I'd like to share this solution (in progress) that I've come up for comparing conversions through a registration page which is split over multiple pages. It's not perfect but seems to be working as the real version of this anonymised example is helping drive the decisions it was designed for.There are 2 conversion rates. One is Impressions to Register and the other is Step 1 to register. This is the % of people who register who have started engaging somewhere on the form by entering something. I do this because depending on the traffic source we can get a huge bounce rate which distorts the data. The first thing to look at is the background colour. This is the step 1 conversion rate. I can immediately see that Feedme.net (fictional companies here) converts better than the rest and mainly on desktop and mobile. We seem to be having big problems on GoEat.biz I can then switch the view to the actual form step names and filter on the people who didn't complete the form to see dro

  • Issue#38208: Tableau - Bar Chart W/ A Sized End-Point

    Hi Everyone, I'm throwing out a question on this last day of January (that's wild to think)…. Assume you have four buckets (North, South, East, West), w/ two measures (# of trips and a separate Shopping Index) for each. You set up a simple bar chart, w/ NSEW along the bottom, sized by the # of trips.  At the end of each bar, how do you include an end-point (a node, circle, or something), that's sized based on the Index Measure (which is not directly tied to the # of trips, or length of bar)…...So North may have the largest number of trips (and longest bar), but East indexed the largest in Shopping sales (and has the largest end-point).  I'm trying to push the bounds of a simple bar chart a little….Thanks for any help & thoughts here!!! Paul

  • Issue#41610: Bullet Chart category issue

    Custom Visual Bullet chart prepared by Microsoft has a bug.Length of categoary name is fixed, if we have a lenghty name, the visual isn't properly adjusted. (Attached image for more clarification.) Any help on how this can be changed? Or what should be changed in BulletChart.ts file available under the downloaded (converted) visual. ï»¿

  • Issue#55306: Tableau - Measure values Conditional color on horizontal bar chart

    Hello. Would you please help with coloring horizontal bar chart. I have a horizontal bar chart with 5 measures selected. they show if these measures are bellow or above plan.They colored corresponding: bellow = red, equal or above = green.The problem with the last measure "Headcount", as it coloring should be reversed: bellow = green, above = red. But I cannot change the color for this single measure.Currently on shelves I have following: I tried to move headcount measure to secondary axis, but this does not solve the issue, as I still cannot set the color for it separately. Any idea how to do this?

  • Issue#56066: Tableau - How to build pie chart out of multiple measures

    I've got a big file of survey response data (600+ columns, 800+ rows). I'm trying to build a pie chart that pulls data from 5 different columns. Each column has 1's & 0's. Ideally, I would sum the numbers in each column and use those 5 sums to build my 5 pie slices, but I can't figure out how to do this. I assume I'll have to create a calculated field, but I don't know how to structure the expression to do this. I tried this syntax:sum( A+B+C+D+E)but it doesn't work. I'm attaching an image that shows my data columns in Excel and a pie chart from the survey app using similar data, to show what I'm trying to do.  Any ideas how to do this? Thanks! 

  • Issue#62514: Tableau - Dual Axis Chart with Multiple Different Measures

    HI, Please see the attached TWBX. I am trying to create a dual axis chart whereby the first chart contains a line chart of the N-1, N-5, N-10 values and the second chart contains N-1 SPY, N-5 SPY, N-10 SPY.  As there is no option for a "Measures 2" or equivalent in order to effectively group these measures my only option is to either display all the values or only half. I want to end up with 2 line charts overlapping each other on the same axis as in the picture below. Can anyone help? Many thanks! 

  • Issue#70482: Tableau - Need help on creating Gantt chart with two different rows

    Hi..Anyone knows how to plot a graph like below?.If so,pls provide some inputs or ideas or solutions. Release LevelPlanDesignBuild TestImplementFreeze Dates31-Jan29-Feb31-Mar30-Apr31-May            Project 125-Jan25-Feb25-Mar25-Apr25-MayProgress15%5%0%0%0%  85%        Project 220-Jan20-Feb20-Mar20-Apr20-MayProgress75%65%50%40%10%            Project 325-Jan25-Feb25-Mar25-Apr25-MayProgress65%50%40%10%15%

  • Issue#70484: Tableau - stack line/bar chart requirement

    Hello Everyone, Today I came across an issue which I tried to replicate in a sample file. I have a report where my net Sales = Base + Commission  I can either create a parameter (dynamic) or may define the base price (fixed) of each object. However I want to show the graph as per the attached picture. it should be a stacked line chart which will represent Base+Commission in one line and together should represent the sum of sales for each object. Currently I am not able to distinguish them in colours Please let me know if anyone could help me with a solution. Regards,Somok

  • Issue#78085: Tableau - Why does the Backgrounder fail though there seems no memory issue ?

    Hi All, I have Tableau Server version 9.2. Data sources are extracts and MySql data connection. I have 3 backgrounders. The system is of very high configuration (64bit, 32 Gb RAM, 7.5 TB memory). MySql Db is on different server than Tableau (which is also with good config) Sometimes there seems error as Lost Connection-com.tableausoftware.nativeapi.dll.TableauException: [MySQL][ODBC 5.3(w) Driver][mysqld-5.5.39]Lost connection to MySQL server during queryin background status of extracts although the refresh extract query is not heavy and executes in seconds. When I look at show processlist there was no memory issue/lock or anything during the execution. Also the system memory on both the servers seem fine too during the error time. I have seen in some threads where it is mentioned that the backgrounder restart itself in some interval.Is that true?  I am getting this issue in this version only. Din't get in previous version. Also, not every time same extract gets fai

  • Issue#81484: Tableau - How to add the window total to line chart

    Hello,  If I have the most ordinary line chart, one that I dynamically quick filter by dates, and have a few other static filters, is there away to add the grand total to the window? Such that, I can answer, total X, in this period of time? One way that I found was to use a calculated field(Sum) to be doped as a dual axis, and then add a reference line to that; thus the entire straight line is the window total.  But there has to be a more elegant way? Thank you!

  • Issue#94420: Qlik - Bar Chart Static Max Issue

    Attached please find the sample qvw.  I would like to use the dynamic data for bar chart axis.  Data is out of bounds right now.  I am using error bars also. HOw can I make the bar chart axis dynamic  and not provide the constant max value.

  • Issue#94630: Tableau - Sizing issue

    HiNeed help with server sizing issue.30~ datasourcesAll datasources are liveDB is Hive/Hadoop100~ users – means 10~ concurrent usersA lot of data – 500~ Tara

  • Issue#98344: Tableau - Trying to Dynamically Sum Top Ten Clients for Percentage of Total Revenue Chart

    I'm working on an item to show what percentage of the total revenue earned in a period could be attributed to the top ten clients.  I want to be able to show the top ten clients in a variety of different cuts and they should hopefully update dynamically.  For example I'd like to be able to show the top ten revenue as a percentage of total revenue for a given month, a given geographic area, a given region and account manager. Is there a way to sum up the top ten so that I can divide it by a TOTAL(Sum(Revenue)) table calculation?  I've attached a sample workbook along with the ranking formula I've been using up until this point.  I'll be happy to try to explain further. Thanks,Brian

  • Issue#101949: Tableau - BAR Chart - Can you roll together all bars for a summary

    I have a bar chart with one bar per category. Normally this is the viewthe user of the published workbook (Tableau Server) will want. Occasionally the user will want to group all of the categories together andshow only one bar with overall information.  What is the best option toaccomplish this with a published workbook? Thanks,Doug

  • Issue#110918: Tableau - Adding a running total to a bar chart

    Is it possible to add a running total calculation to a stacked bar chart? I've been able to add a running total to a text table, but that same calculation is not producing a running total for the bar chart I am trying to create. The working formula for the running total is as follows: running_sum(sum([Recognized Revenue])) You can see that the running sum in the second column of the table below is performing a running sum on the first column (Recognized Revenue).  My question is how do I get this running total column to be usable within a bar graph? If I just duplicate this sheet and then reorganize the data as shown below, the Recognized Revenue and Recognized Revenue Running Total are the same. The running total is not working properly. Help! 

  • Issue#116798: Tableau - Creating Chart with negative growth

    Hi Tableauers, I have attached the data file which contains Yearly product sales. I want to create the chart in Tableau same like below  Basically chart display the Product comparison for two years and line display the growth.For example in Year 2010 Sales was 100 & in 2011 it became 200, so growth is 100% for Product A.Likewise for product B growth should be -15% Please help me to create the chart in Tableau

  • Issue#120843: Tableau - Need to add another column to show the percentage. In this chart, the last column is the d

    Hi Techs, Need to add another column to show the percentage. In this chart, the last column is the difference in revenue between July and August. I am trying to show in Tableau is the percentage of each row (Products) in the total difference. As an example, what is the percentage of Product A difference ($2,658,370) in the total difference ($10,585,571).

  • Issue#124067: Tableau - Unable to create Pie Chart

    Hi-- I am trying to create a basic pie chart. I have listed the top 30 Vendors by the # of Claims (filtered on the top 30 using the 'nested" technique: INDEX() and then placed it in front of Vendor Name on the row) . For some reason, I am unable to click on the "pie charts" icon in"Show Me" even though I am using a dimension and a measure. I attached a PDF because my info has PHI and I cannot upload the full workbook. Any Suggestions how to get around this?  Thanks, Julie