Issue#39: Tableau - A way to create a Tableau data dictionary in order to see the Field Names within a workbook and associated formulas

  • Tableau does not have the ability to export the workbook logic and load the field names and formulas into other software, for example a program that manages metadata for a company/department to provide a data dictionary.

     

    If this can be implemented on future release then it would be helpful for developers to keep track on their Calculating fields and formulas.

    It will add the ability to provide a data dictionary or integrate Tableau into system like metadata management such as Informatica Metadata Manager is so that users will have a better understanding of how data is connected.

     

    As Tableau development of workbook dashboards becomes more complex with connecting to multiple data sources, joining multiple fields, creating numerous calculated fields and workbooks, there is a need for the following:

     

    1.To see which data sources are used in which workbooks, dashboards, and worksheets.

    2.Understand the data lineage from source to workbook to dashboard to worksheet.

    3.Ability to view the formula behind calculated fields.

    4.Integrate Tableau into metadata management  systems such as Informatica Metadata Manager.

     

    Thanks.

    0 Answers

    Sorry, your answer is too short !

  • Issue#108: Tableau - Create Hierarchy from 2 different data Sources

    Hi ,Please let me know, is that Possible in tableau to Create a Hierarchy , including fields from different data source Example :Data Source 1: Hierarchy is below: Data Source 2:  Hierarchy is below:  I have to bring in the Data source 2 Hierarchy appended below to the Field 'Country' in  data Source 1 .

  • Issue#4886: Tableau - Data doesn't match in the same workbook

    Dear Tableau expert, I created exact same view in one workbook, filters, columns and measures, please see the print screen, however, one is incorrect in terms of value, could you please let me know why the different occurred? Many thanks for your help. Best,Willow

  • Issue#12234: Tableau - How to Connect workbook with data extract ?

    Hello Team,I have a data source called A and developed some workbooks named W1 and W2, I have created a data extract for A and Published it to Server, So If I want connect W1 and W2 to the published extract A, How to connect it in Tableau Server. Thanks In Advance Sudha

  • Issue#22503: Tableau - How can I create a parameter when the Data Window is full?

    The instructions to create a parameter seem to be Right-click the Data window, and select Create Parameter. However, my data window is full and there no white space to right click. For calculated fields I can go to Analysis... Create calculated field, but I cannot find the correlate for parameters. Is there an alternate?

  • Issue#34897: Tableau - Tableau auto-populate formulas with whatever is currently in row/column field

    Hey guys, So I want to print R values into the title of my sheet and I use the following: cov - (1/(SIZE()-1))*   WINDOW_SUM(     (SUM([x]) - WINDOW_AVG(SUM([x]))) *     (SUM([y])  - WINDOW_AVG(SUM([y])))  ) R - [cov] /(WINDOW_STDEV(SUM([x]))*WINDOW_STDEV(SUM([y]))) Is there any way to build these formulas such that I can throw a measures ([x], [y]) into the row and column fields and Tableau with automatically change the names of the measure in my calculations to match? So if I wanted measure a in the rows and measure b in the columns, when I drag those measure up there, all the [x] in the calculations would automatically change to [measure a] and the same with [y] to [measure b]. Obviously I would like to avoid having to build out every single version of these calculations for each combination of measures... Thanks!

  • Issue#41991: Tableau - How to create a sub date range from an data source

    I'm trying to create a parameter from a data source that is grouped by weeks (not days) until 9/1/15.  This is messing up my ability to create a functioning parameter, then filter for my sheet because Tableau isn't able to figure out if the number order correctly.  Is there a way to create a new date range that starts at 9/1/2015 so that my filters look normal and that  I can build off? example below:  As a result my filter numbers look weird:         Here's the formula I used to create the Calculated Field for Week ID:      left(str(datepart('year',[Date])*100+(datepart('week',[Date]))),4)+"-"+right(str(datepart('year',[Date])+(datepart('week',[Date]))),2)

  • Issue#115827: Tableau - create calculated field for parameter range of float values

    What is the syntax to create a calculated field for  the below parameter, here the range of value is from 'Set from Field'  Thanks.

  • Issue#140140: Tableau - Data extract keeps updating everytime I return to workbook

    Hello there! I wonder if anyone can help me with this. I have a workbook locally that I open using Tableau Desktop. It is connected to a SQL Server, and the Data Connection is set as to "Extract". Everytime I go to the "Datasources" tab and return to the workbook, Tableau runs an update on the extract and I have to keep waiting for a job that have already been done. It should only update when I click the update button, or am I wrong? How can I avoid this? I hope I have made myself clear, and thank you for your help. Regards, Mateus.

  • Issue#145508: Tableau - Create a Line graph without date field in X Axis

    HI, I want to create a line graph in Tableau with below data. I am using oracle as database. I am able to prepare this graph in excell but not in Tableau.I am using tableau version 8.1.Please help !!!     AUDIT_RESULTAUDIT_ROUND_NAMECountRedABC272GreenABC2771AmberABC2716RedABC283GreenABC2878AmberABC2812RedABC2927GreenABC2945AmberABC2912RedABC2645GreenABC2687AmberABC2678       Sum of CountColumn LabelsRow LabelsAmberGreenRedGrand TotalABC26788745210ABC271671289ABC281278393ABC2912452784Grand Total11828177476 

  • Issue#160586: Tableau - Is there a way to show different name for the field names in the view

    I have a field Day(policy Effective Date)  ,Day(policy Expiry Date), in the view i want them to be displayed as Policy Effective Date and Policy Expiry Date.Please find the screen shot attached.

  • Issue#175895: Tableau - How to create a graph like below for this data?

    Required Graph: The data attached is datamatch. In the 6th tab,  filter column 1 to the value 10. Column C shows how person 1 scored person 2, column E shows how person 2 scored person 1, Column F shows person 1 swipe action, column G shows person 2 swipe action, column H shows the duration between the two swipes (-00:00:01 if one or both has not yet swiped), and column I shows the status.  I want a graph similar to above for  Swipes, right swipes, matches, conversations. Then a similar graph showing their percentage change.  Then, I need to create a toggle between aggregate ( showing the total amount at each period) and Discreet (showing the amount for that time period. Also a toggle between total number (either aggregate or discreet) and per user number.  P.S - Please take a screen shot of each and every step to let me know. Thanks in advance.  ThanksChandan Mishra     

  • Issue#182565: Tableau - Create a rolling average Calculated field II

    I currently have my data set up by month for 2014 and 2015. I have graphed 2015 using bars and I want to graph 2014 using two properties. I want a horizontal line representing the total at the end of 2014 (December) and would like that total to be calculated as the sum of the 12 months (numerators) divided by the sum of the 12 months (denominators). Essentially a rolling average every month ending in December.@

  • Issue#186596: Tableau - Use historical data to create dynamic target

    I hope I explain, what we are trying to accomplish, well enough. Using the Superstore Sample data for example, we want to take the historical sales data from 2011, and use those figures as a goal to measure 2012 against.  For example, in 2011, Furniture Sales totaled around $12.7M. So we'd like that to be our goal, and then if we filter the Product Sub-category, we'd like the target to change. Does anyone have a similar situation that could be used to help us accomplish this view? Thanks in advance!

  • Issue#200387: Tableau - How to create a caclulation when data blending two data sources

    Hi,I'm trying to create a calculation based on columns coming from two sources. So I'm doing data blending.  if [PLANTYPE]='Total PPlans' and isnull(ATTR([Aggregate ID's].[PLAN_ID])) then sum([Value]) else 0 end   ( throwing me an error..saying can't mix aggregate and non- aggregate) and then I 've changed the calculation to if attr([PLANTYPE])='Total PPlans' and isnull(ATTR([Aggregate ID's].[PLAN_ID])) then sum([Value]) else 0 end  ( It's valid but giving me zeroes) NOTE:Plan type and Code are from Primary sourcePlan ID from secondary source...and blended on Primary source.code=secondary source.Plan ID If needed more details please let me know. Thank you for your help in advance.

  • Issue#257856: Tableau - Data blending Zip codes performance issue

    I am looking for the best / most efficient way to blend or join a secondary data source which contains a master zip to territory mapping. Primary data source: (live connection tableau online) each row has a zipSecondary data source: (excel) master zip file with ~40k rows (all US zips) - each zip is tied to a territory I am looking to add the territories from the master zip to territory file as a filter. I tried data blending using the zip codes as a common field but I am facing very slow performance. Is there a better way to do this?

  • Issue#269214: Tableau - How to create a join to display data from both tables

    Hi guys  I am trying to create join between two tables so that dimensions and measures from both tables can be show on the same sheet. However, I am not sure how to get rid of 'nulls'. When I try to drag the measures from the 'MONTHYLRENTINCOME' table, all that comes up is null values. Could anyone help me how to display the data? Thanks 

  • Issue#276716: Tableau - Data Blending Left Join Issue

    Hi All, We are currently developing a customized usage dashboard for our business users. We are blending data using multiple data sources and both data sources are connecting to PostgreSQL databases. In the second data source we are using custom SQL which basically pulls the users who are in Usage and Admin AD groups. All sites contains corresponding Usage and Admin AD groups accordingly. Our aim is to provide the users logged in with their sites usage data. For example, user X is only part of site A and when he logs in he should be viewing only site A's usage statistics and if user Y is part of site B and C, he should be viewing both sites B and C's usage statistics. For the security piece we are capturing user login information using GetUserName() function. But we have a issue here with the Site Name filter. When a user X logs in, he is able to see only his sites corresponding data getting filtered but the site name filter shows all sites within the environment. we want to

  • Issue#298549: Tableau - How many Data sources created in one workbook with out relation on each data source

    Hi, Can I create the two are more data sources in one workbook, without data blending?

  • Issue#340617: Tableau - Calculate a field based on a previous year's data

    Hello all, How can I calculate a field for a certain year using data from a previous year.  I want to Calculate 2015 and 2016 Revenue as a Percent of 2014 Expenses. Thank you!

  • Issue#384322: Tableau - Show percent difference from totals using 2 different data sources. Calculated Field

    I was able to create a calculation from 2 different data sources to show the total incomplete reports, I also need to show it as the percentage of total completed which should be 97.88%. I tried a few different calculations without success.  Any help would be appreciated.....

  • 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 other(A, B, D) . But this figure shows 3 ICUs(A, B, D) which are in data set 1. But I need to show rest ICUs though those do not have data (C and E) 2. When I blend Data I observed this figure. This figure shows rest 2 ICUs(C and E) But failed to show discharge type correctly as in figure 1 when dragging discharge type into color shell Can anyone please kindly help me to getting this problem solved. I have attached my tableau workbook as well. I can work upto tableau version 9.2. 

  • Issue#441434: Tableau - Create a date field from date parts

    I have a CSV file that has the following sorts of data: YearMonthDay196511196512196513196514196515 I wanted to create a date field based on this. I thought it would be as easy as creating a calculated field like this:DATE([Day]/[Month]/[Year]) However this does not work, my guess is that it is because I cannot put quotation marks in it? Any tips? Thanks

  • Issue#461371: Tableau - Howto Create Calculated Field For Total Cost Of Products Sold

    Hi, I have two data sources (CSV and Excel). One is a list of line items (sales orders). It contains:Order DatePart NumberQuantity OrderedRevenue The other is a list of part numbers and their associated manufacturing cost. It contains:Part Number (data is blended on this field)Cost What I want to be able to do is calculate (for any part number or group of numbers) the total revenue generated and the total manufacturing cost. If I take one from the other, I get the gross profit. I'll do this for each year of sales to see what trends are happening. In my Excel view of the world, I would create an additional column (row level calculation) on the sales orders table. I would use a lookup to find the part number from the order in the costs table. I would grab the cost value and multiply it by the order quantity. If I filtered the orders table by the part numbers, I would then just need to sum this new total cost column and the revenue column and I could make my calculatio

  • Issue#483303: Tableau - Calculated field causing issue while publishing - all filters greyed out.

    I have a calculated field as a filter in my reports. It is working fine in the desktop preview. But when I publish my dashboard online, all my filters are greyed out (look at the picture). Is there any wrong that I am doing. Appreciated your help here. 

  • Issue#507527: Tableau - Create a category using IF statements but on a subset of data yet show total $

    Hello--I'm connecting to an Access Database.  My data looks like the following (a lot more of it, though.  Hopefully you won't need a packaged workbook but can give me hints how to do this.  My problem ends up being the total sales column.  Rather than total sales, I get a duplicate RMS sales and then everything in the "No Trade Credit Spend" Category, which isn't what I want.   Customer     $                         LOB123               50000                 Trade Credit123               15000                 Supply123 

  • Issue#519904: Tableau - Sum() the Attr() in calculated field from two data sources

    I'm the beginner of Tableau, I would like to do the Service Level Report which involves different database and dimensions. So, multiple data sources must be required. I encountered the common Tableau issue "Argument to sum (an aggregate function) is already an aggregation, and cannot be further aggregated." which is sum() the aggregated calculated field [use Attr() to compare two data sources fields]. Any experts can provide the work around for the above issue? I prepared the sample of my case.

  • Issue#531544: Tableau - How to make the data from the first line of excel as column names when imported to Tableau

    Hi all, I have tried to use an excel source in tableau. While doing so, I need to make the first line of excel as column names. The only solution I know is to make them as bold. But it looks like there is another option where you can enable the checkbox "Yes, the first row has field names in it. But I am not sure where this option is available. Can someone help me on thisI found the below screenshots while searching for the solution online but I am not sure where it is availableThanks,Ashwini

  • Issue#568633: Tableau - How do I create a measure based off multiple filters? Calculated Field question...

    Not sure if I'm explaining this correctly but I basically want to create a measure that is based off filtering. In my screenshot below you see what I've outlined in red. I want the Total Opp. Amount to only sum based off filtering on the Campaign Start and End.  I am at a loss at how to do this and if I can do it (I'm sure there's a way).  Not sure how to create this in a calculated field. Your help is appreciated.    

  • Issue#599488: Tableau - Data blending summation issue

    I am facing one issue while aggregating the data from date to month rollup on data blending of two different sources. When I am rolling up data which is % based from date level to month level, It is not aggregating based on date at month level. See below requirement to get clear idea.  Month of Date opened, Day of Date Opened, Full/Partial & Percent impacted user are coming from EXCEL data source (Primary Data source). The Total User is coming from Google Analytic (Secondary Data Source). Whereas “User impacted by percent” is the calculated field created based on these data source. Here is the formula of User impacted by percent:  if SUM([Percent impacted])=1THEN SUM([GA (GA_Dataset)].[User])ELSE (SUM([GA (GA_Dataset)].[User])*SUM([Percent impacted]))END I tired ATTR in above formula instated of SUM(Percent impact) but didn’t help me. See attached workbook sample for detailed understanding. Data at date & month level:Month of Date Open