tableau Discussions

About 3993 results - Page 1 of 400
  • Issue#93: Tableau - Ability to Disable the One-Click Sort

    The one-click sort button can over-ride and totally mess up the set sorts in a view. We really need the ability to disable/disallow these buttons for end-users. --Shawn EDIT: Here's a good example of why this idea is important. Recently in Viz Talk Judith asked if someone could replicate a viz of the standard College Boards AP Report. (See attached.) It looks like this: The easiest way to do this was to create two different worksheets and put them side-by-side, hiding one of the c...

  • Issue#6275: Tableau - Aggregating near-duplicates to a single entry

    Hi, I need to measure the amount of units that occur per URL in a large dataset. However, the data is somewhat messy and because of this, multiple URLs which actually point to the same page (HTTP vs HTTPS versions of a URL, for example) have different measurements attributed to them. I'd like those multiple measurements to roll up to a single measurement for a more accurate read on what's happening. I cannot clean up the data in the source file itself because the dataset contains 2 million ...

  • Issue#15593: Tableau - multiple dimensions and measures

    I have a table which has 90 columns ( dimensions and measures). Clients want me to display all these columns in the details view  as per the requirement. I know tableau have as limitation of initial 6 and can be extendable using table layout with 16 columns.If i want more columns then another option is editing the xml code to desired no of columns.Though i do all these but view is not coming with scrolling feature. I read several posts one of the post was created for multiple column but the...

  • Issue#24558: Tableau - Change Layout container colour

    "The layout container is transparent by default, but we want it to hide what is underneath. Format the layout container using the drop-down menu, and add white shading so that it is indistinguishable from the background" this is an instruction from "Learning Tableau by Joshua Miligan" . I was doing the Chapter 10 exercise "Dynamically showing and hiding other Controls". I cannot follow the instruction because I can't find the drop down menu. Is he talking about the drop down menu on the lay...

  • Issue#41992: Tableau - using parameter in a live datasource and the same parameter in calculated field within a V

    I have a question WRT using parameters in the data source. Please help me understand the below situation. I am using a live (Postgres) connection to a workbook. I am controlling a denominator value in the custom sql using a parameter “X". Which is working fine.Now, in the same workbook I am using the same parameter “X” within another calculated field. However when the value x changed is not being reflected in the viz.. Am I doing anything wrong here? Is it that the sa...

  • Issue#54315: Tableau - Tableau Formatting assistance

    Hi,I have created a MOM (Month over Month) KPI report. Dataset is last 24months. I am having some difficulties in formatting and placing on the sheets on the dashboard.Till last year 2015 everything was in place however due to year change all formatting is lost and 2 years values are seen instead of one. Below are screenshots and attached twbx file Last year dashboard view                   &...

  • Issue#64890: Tableau - Count of Companies by Revenue Bins

    Hello All, I apologize in advance if this is simple. I have looked at Jonathan Drummey and other people's solutions to this but I don't know how or why I am missing this. Anyhow:  I have attached a Tableau Packaged Workbook.  BackgroundThis data set contains a list of companies broken out by date, ID, and user_ids. 7 days worth of data. I am having difficulty setting up aggregate bins. I created an IF FORMULA to create bins, but for some reason only "1000+" shows up even though I ...

  • Issue#50: Tableau - Tableau creating wrong syntaxs when accessing data through ODBC connection

    Hello , We are accessing data from one of our hive cluster using quboles ODBC connector and for some reason Tableau is not able to recognize the data types ,So we did change the data types from the tableau interface and tableau is trying to send a query with a wrong syntax to the hive server . So here is an example of what I am talking about set hive.cli.print.header=false;explain SELECT 1 AS `column1`, `Tablename`.`column2` AS `xyz`, `Tablename`.`ad` AS `ad_slot`, `Tablename`.`ad...

  • Issue#507361: Tableau - Vertical Reference Line Based on Filter

    I have a graph like this: 1. Date (with function : DATETRUNC('day', [Sales Date])) in the column pill2. Sales Qty (with function: RUNNING_SUM(SUM([Qty]) with "show missing values") in the row pill3: Quick filter on Sales Catetory What I want to do is to have a vertical reference line with a formula like this: CASE [Sales Category]WHEN 'Book' THEN '7/20/2015'WHEN 'Others' THEN '10/25/2015'END However, when I right-click on the x-axis and select "Add Reference Line" the dropdow...

  • Issue#522352: Tableau - Dual Axis map of US Regions and plotting marks for zip codes

    I've been struggling with this for quite some time.  I would like to color code a US map by region.  I do this by supplying a list of states and regions.   I would then like to place marks on the map for zip codes.  Zip codes come from one data source (db) and i'm supplying the state/region mapping via an excel spreadsheet. Ultimately, the marks will represent client locations.  Then i want to aggregate client data by region.  I was able to do this a while...

  • Issue#532979: Tableau - Sheet Borders on Hover

    I've layered up some sheet on the dashboard so that I could have a nice rounded boarder around my quick filters, but when I hover over that blank sheet I get the borders of the sheet. Can I turn that off for hovering?...

  • Issue#542356: Tableau - How does tableau handle mysql table structure changes?

    Hi, I have added a MySQL data source in Tableau 9.3. I was wondering how Tableau handles MySQL table changes, changing names, datatypes, etc. ? Thanks for your answer. Kind regards, Heiko...

  • Issue#557777: Tableau - Calculating difference between two separate charts?

    I have two heat map style charts on one of my dashboards. What I would love to create is a 3rd chart that shows the difference in the total of the various segments of both charts. For example the new chart would have a value of 32.5% in the top left box. Would anyone know how I could go about creating a chart like that using the values from the two original charts I generated ?  ...

  • Issue#569566: Tableau - Calculated field

    Hi, I'm trying to create a calculated field where if a customer's visit = X then divide two columns to get a percentage. Here's my calculated field so far: If [Visit Type] = "Referral"then[Goal Completions]/[Visits]END On the attached image - my calculated field is the last column. That number should be 78,706 / 437,047 = 18% but it's giving me a percentage of 137.46% What did I do incorrectly in my calculated field?...

  • 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...

  • Issue#596137: Tableau - Converting Weekly format

    Good Morning, Need your help friends. I have a query. if I choose  weekly number on April, it will show week 14, week 15, week 16, week 17 and week 18. Can we convert that become Week 1, week 2, week 3, week 4 and week 5? thanks...

  • Issue#604413: Tableau - Clustered bar chart in Tableau

    Hi, I want to create a clustered bar chart in Tableau but I am not able to create the gaps between the dimensions so as to distinguish them easily Sample workbook attached. I want some thing like this  instead of  Thanks,Dileep...

  • Issue#613191: Tableau - Coloring charts top 5

    Hello, Is it possible to do something that, top 5 sales of sub-categories have always the same 5 colors and the rest is random.As in example below what year would not have chosen sales and sub-categories should change but the top 5 sales should have the same color and the rest random from the palette.Now plate is assigned to sub-categories. ...

  • Issue#627698: Tableau - Team, I heading towards to next level of Tableau. i .e Need to integrate tableau with html

    Hi Team, Team, I heading towards to next level of Tableau. i .e Need to integrate tableau with html. its client requirement. Please help me in terms of learning on integration. Thanks in advance. Thank you,Rushi....

  • Issue#638416: Tableau - Filter by date based on date range selection in different worksheet

    Hi, I have worksheet A with two date/time columns "StartDate" and "EndDate".I have worksheet B with one date/time column "TimeStamp" After selecting one row on worksheet A I want to show all rows of worksheet B where TimeStamp is within StartDate and EndDate. I tried an Action Filter but this does not allow me to enter expressions like StartDate < TimeStamp AND EndDate > TimeStamp. I also tried to use a Parameter-based filer on Worksheet B but the Action Filter cannot be app...

  • Issue#647150: Tableau - Layman's ETL - Automate Data Extracts

    Hello! I know Tableau, I dont know best ETL practices.  I have a handful of platforms I need data from, all of which must be updated weekly. - Salesforce exact target (email marketing)- ForeSee (survey)- Linkdex (seo tracking)- Google analytics (we now have in google bigquery so that may solve our issue for this data source) I hear rumors about FTP, ODBC, API connections.What is the best way to ETL these data sources to Tableau given that I'm not a developer.  I'm also curren...

  • Issue#662663: Tableau - Summary Table

    I have daily price data table (around 1M rows) for some products from different supliers. I want to prepare a summry table, where I can show "average price from all suppliers", "min price" and "max Price" /day/Product. And i want to show name of the supplier with max and min price as well in the summary table (May by via tooltip or any other way...). I am new to Tableau and stuck with this task, is there anyone who could help me here? Thanks   DateProductSupplierPrice2016-01-02Axy...

  • Issue#670363: Tableau - Just wanna make sure...a PUBLISHED data source with no objects connected to it is not bein

    Example:If I were to delete this data source then nothing would happen, right?  If it was on a schedule then that schedule would be dropped (expected behavior which is good).  The only downside would be that if someone wanted to use this data source they would not be able to because it wouldn't be present here:I just want to make sure that if I delete an unused(?) data source the action won't break something ...

  • Issue#676605: Tableau - How to find the dominant answer in a survey table

    I'm very new to tableau and need some help here. I have a survey table and I'm trying to find out the most selected answer for each question, and display only this answer on the dashboard.  Is there any quick way to realize this? For example, Dimension "which breakfast item do you like" is a survey question, and there are three options to select (single select): Pancake, Waffle, Sandwich. 6 out of 10 people selected Pancake. How can I make the worksheet display only the text as below?&...

  • Issue#686182: Tableau avec afficheur d'indice de type enum

    Bonjour,Je suis à la recherche d'un moyen, si possible, d'avoir un tableau multi-dimensions mais avec un afficheur d'indice de type enum au lieu d'un numérique.Cela serait un plus pour moi du coté affichage. Car il est difficile de s'y retrouver avec un Tableau de 4 dimentions par exemple. ( chaque Volume réprésentant un type de test et chaque page une étape du test). J'ai bien trouvé la solution de faire un Tableau de cluster de tableau de cluster de tableau 2D mais c'est un peu bea...