tableau Discussions

About 3993 results - Page 1 of 400
  • Issue#93696: Tableau - Display values in text based on certain dimensions

    I have a worksheet with the following fields: [Sales], [Units], [Year], [Sales % Difference from Previous Year] in the marks section. I have the YEAR(Date) and [Sale Type] fields in the rows section. I want to have the text section with a short paragraph that show values based on different dimensions. For example, I want to say something like In 2015, overall sales totals were ([Sales] WHERE Year = 2015) compared to ([Sales] WHERE Year = 2014), a ([Sales % Difference from Previous Year] WHE...

  • Issue#326827: Tableau - Excel_mySQL DB_Calc Error

    Hi Guys,  I am connecting an Excel Sheet with mySQL db, which is the primary data-source. WHile creating calculated fields, I am getting error. I have attached the files in which I have  explained the motive in excel file. Any help would be much appreciated. Regards,Ajeet...

  • Issue#123092: Tableau - Does Tableau nomenclature defining the application's features and layout have historical c

    I am curious about Marks, Cards, Shelves, Partitioning, Addressing, and other things that might not come to mind immediately. For Marks and Cards, I have not encountered these terms in software before and I wonder if they have historical significance in some early form of business intelligence, analysis, or data visualization. Same for Partitioning and Addressing; did Tableau invent this method of defining elements of a calculation or do they have context in prior art?...

  • Issue#131749: Tableau - Publising a DataSource to a different Tableau Server

    Hi Folks, Current we are on Tableau Server 9.1.0 and I need to test the behavior of  tableau  data-source on a new tableau server (9.2.3)  which is hosted on a different machine for the purpose of testing. I open tableau desktop->Connect to Tableau Server-->connect to tableau datasource-->Create an extract out of it-->Go to the server menu and sign-out from there. I then need to sign-in to the new server and publish this extract as a datasource. However when I cli...

  • Issue#147004: Tableau - Applying filters on Parameters

    Hi, In the attached workbook, I am using “Select City”, “Select Radius” and “Year” as parameters. The flow of the filters/parameters is as follows: First I select a county, then I select a city (for example Hopkinton -1), residing in that country. Then I get a list of records in map and table. To filter further, I give a radius of about 500 miles. After adding this filter, it will show only those records which are 500 miles away from Hopkinton-1. Now...

  • Issue#163748: Tableau - how to publish report for 1 day back

    Hi, Is there steps to publish report for 1 day back date. I have used the function Today()-1  to publish report for 1 day back date. This is not correct solution. Is there any other solution to publish report for 1 day back. ThanksAman...

  • Issue#174135: Tableau - Adding Non-Existent Values to a Dimension

    How do I add string values that do not exist in domain? For example, I have field called "stuff", which could contain the following three categories: "foo",  "bar", and "qux". Now, let's assume, depending on the parameters of my query to the data source, one or more of these categories is not present. How do I force Tableau to display these items and populate them with 0?...

  • Issue#183643: Tableau - Missing Fields on <<>>

    Hi All I have two dashboards and I m creating dashboard action from one to the other and I m getting above error message and action not performed well. The reason to get this error is the Source Field is not on the dashboard/sheet There is no way I can bring that field in to the worksheet/dashboard and I tried to place it on Detail Marks  as suggested on the below post. But then values of dimension is appear on the worksheet. http://kb.tableau.com/articles/issue/warning-...

  • Issue#199461: Tableau - Please help - I have a number of projects with forecast benefits, I need to calculate the

    Hi All, Please can you help me. I have a number of projects with forecast benefits, I need to calculate the difference between latest months benefits and original months benefits, the problem is that not every project starts in the same month. I have attached a workbook (Tableau v 8.3), this shows the projects, the benefits and the months, I need to add a calculated field so that I can show difference between latest months benefits and the original benefits/forecast. The difficult bit is th...

  • Issue#212105: Tableau - Combine Date and String Fields to Create a Timestamp

    I have two fields in my table (stored in an Oracle database) called: Effective Date, and Time of Day. Effective Date is stored as a Date datatype and Time of Day is stored as a VARCHAR2(6 BYTE) in my table.  I am looking to see if it is possible to combine these two fields in order to create a new Time-stamp field. That way, I would be able to create a continuous time-series in Tableau. Any type of input would be greatly appreciated. Thanks!...

  • Issue#221484: Tableau - how to create a correlation chart between noise level and % of people annoyed

    In the dummy csv file there are three columns of data: user ID, noise level, and if the user feel annoyed by the noise level (y: feeling annoyed, n: not feeling annoyed). I want to create a chart like the following that shows the correlation between the noise level (x axis) and the corresponding percentage of people feeling annoyed at that noise level (y axis). May I ask how to create this correlation chart in Tableau? I know how to create cumulative frequency distribution chart f...

  • Issue#240005: Tableau - Field returns null values after changing from string to date.

    I have a field on my report that when its data type is set to "String" it returns a date in the following format: However, when I right click the field and change it to either date or datetime, then all records become null. Does anyone know how to handle this?...

  • Issue#252167: Tableau - Is there a way to put a filter in a calculated field?

    In my data I have two data types - Count and Percent In the bullet graph in the viz below I am filtering on Percent. I created a calc field to show the value which is [County Data]Now the client would like to see the Count data in the same graph, as a column before the Value column. Is there a way to create a new calculated field that would override the Percent filter and show the Count instead. Here is the link to the viz. I tried Inserting it, but it showed a previous version of...

  • Issue#263626: Tableau - Grouping hours

    Hello First question I have ever asked here - I hope it is not too stupid but the other answers don't quite seem to be the right thing for me I have data based on an event based date and time - ie its regularity varies. I would like to group the data just to show the average value in off-peak hours - which are hours 0-6 AND 20-23. I have read this Sum data using a 6-hour time interval  but I can't quite work out how to make this work for a group of hours that is not continuou...

  • Issue#281177: Tableau - custom number formatting for Measure Values with Grand total with Automatic Units

    Hello Tableau Users, Is there any workaround to show the Measure values along with Grand total in same worksheet with automatic units. for exam 1,000 = 1k, 100,000 = 100k, 1,000,000 = 1m so on... Please share ideas if anyone have. Thanks...

  • Issue#292496: Tableau - Vizql log - No user identifier

    I am looking at the log files however the user tag is always set to "-". Is that normal? Does anyone know how to resolve it?   {"ts":"2016-03-16T12:46:35.542","pid":14552,"tid":"3908","sev":"info","req":"-","sess":"-","site":"{FF5E7E69-4F00-41DC-875F-3032CDDF4D02}","user":"-","k":"end-query","v":{"query":"SELECT `sale_phone`.`Category` AS `Category`,\n  SUM(1) AS `sum_Number of Records_ok`,\n  SUM(TRUNCATE(`sale_phone`.`Spend`,0)) AS `sum_Spend_ok`\nFROM `sale_phone`\nWHERE (...

  • Issue#301216: Tableau - Cannot mix aggregate and non-aggergate comparsions or results in IF Expression

    Hi All, I am stuck in this question and so majority of my work is stalled. I have written the logic below but getting error in calculation. Is there any way to solve this?[Metric to View] is a parameter which is working for other things except "Expired Members" [NOTE: There are 2 important things to note: 1) THERE IS A SEPERATE METRIC CALLED "Expired Members"2) THERE IS A CALCULATED FIELD CALLED "Expired members" ] My Expired members is a calculated field as shown b...

  • Issue#320619: Tableau - Marks Label

    Hi, I have attached a .twbx file. If you open and look at the Corporate Total tab you'll see that I have several text boxes to show the numbers for the measures "Mktg Influenced (Count)" and "NOT Influenced by Mktg (Count)." Is there a way to show both the count and the dollar amounts on the same bar chart so that I don't have to manually insert text boxes for each one? This would be a huge time saver for me. I looked through previous questions in the community and I couldn't duplicate....

  • Issue#332965: Tableau - Annotations in different hierarchy levels

    Hello,I have the following question:When I create an annotation, e.g. a point with some information in a special week of the field "Date" - is it possible that I can see the same point, when I am in another hierarchy level of date - e.g. in months instead of weeks? So that there is also the information about the special week - related to the month. I didn't find any solution, but perhaps somebody has any ideas. I attached 2 screenshots:week-hierarachy: screenshot with the "point of inf...

  • Issue#348074: Tableau - Future values based on previous actuals

    Hello,I have a series of customers with historical sales for prior month, and each customer has varying expiration dates.  What I'm trying to do is populate the 12 months following each customer's expiration month with the values from the previous 12 months.  I'm thinking it's a simple formula but I haven't nailed it yet.  I have a sample data set attached. Thanks!Steve...

  • Issue#367313: Tableau - Tableau Desktop 9.3 Install Problem

    Hi Team, I have a Tableau Desktop 9.2 Student license. Now I will upgrade to Tableau 9.3.But In system Both version are available instead upgrade that is installed sperate one. Is it correct one. Can I install the Tableau Desktop 9.2?. And also I need the Tableau Server License for learning purpose as I will join as a Tableau Trainer. Could you provide me The Tableau Server License? Thanks in Advance....

  • Issue#379111: Tableau - Hello All, Just migrated to Tableau 9.2.4. Where is Export button in Tableau 9.2.4

    Hello Friends I just migrated to Tableau 9.2.4, Cannot find Export button in Tableau 9.2.4....

  • Issue#401955: Tableau - Data Blending Issue

    Hi All, I am working with two data sources and I need to blend some data fields from both data souses to create some dash boards. I did data blending but it does not give me correct results what I expect. I have attached a sample workbook by enclosing similar example which I faced. For your convenience, I have attached two screen shots of results what I expected and observed 1. This kind of figure I am expecting to have. In my two data sets one have 5 ICUs(A, B, C, D, E) and 3 for othe...

  • Issue#414177: Tableau - Month in the stack bar (dynamically change based on the current date)

    Hi All, Can some one please help in finding the way My requirement is Based on the current data, my graph x-axis has to dynamically change to till the starting of the financial( For ex: April month the graph has to show the from July 2015 to april 2016) and if its starting of financial year, it should show the last three monthsAnyone please advise.  Thanks...

  • Issue#425098: Tableau - Average between 2 columns

    I want to find the average of Control Seg1 and Control Seg2 , then compare it with Test Segment. So what I trying to display is :if avg(Control seg1 and Control Seg2) > Test Segment then 1else 2 The measure is Sum of Ad_Revenue. So, can  someone help me with this situation. ThanksAnkit...