Issue#48: Tableau - Hyperlink on multiple columns using Data base values

  • Hello:

    I've a report that has four columns that need to be hyperlinked.

    I've created variables for each and used those variables for hyperlink action using Menu option.

     

    Issue is when there is no value in one column it takes the link value from the right column.

     

    Anyone faced issue like this. Please advise.

     

    Thank You!

    0 Answers

    Sorry, your answer is too short !

  • Issue#210830: Tableau - Conditional Formatiing (multiple columns data summed)

    Hi, I need to have each index rating formatted RED if they breach a specific SUM of OASD I.EIF IS AAA, FORMAT RED IF SUM OASD > 0.2IF IS A, FORMAT RED IF SUM OASD > 0.15ETCalso Would be nice to have a filter for RED items onlyWorkbook attachedCurrently my formatting rule applies across all ratings..(not what I want)

  • Issue#462939: Tableau - Combining multiple columns of data

    Hello, I have data from a csv file which contains lists in one of its columns, ie each row has a column in the format - ["a", "b", "c"] I have split  the column so that I have multiple columns each with an individual value, I am now trying to combine those values to use as filters and to for visualisation. For example my resulting fields are similar to the following: TimeIDListSplit Value1Split Value2Split Value3Split Value400.01Jack["car","bus"]carbus00.02Jim["bus","car","boat","plane"]buscarboatplane00.03John["plane","boat","car"]planeboatcar I could like to be able to get the total of each of the categories, ie-  Car - 3Bus - 2Boat -2Plane - 2 And then plot these against my time field, could anybody advice me on what I'm sure is a very simple issue. Thanks

  • Issue#490147: Tableau - Grouping and summing multiple columns of data

    Hello,I include a simple example of what I am trying to do below.  Basically, I have multiple fund columns and multiple number columns in the same row.  I need to be able to sum by fund and include all data from all columns.  Is there a way to do this without changing the underlying data?  Desired OutcomeFundImpacta14b11c27  Data StructureFund 1Impact 1Fund 2Impact 2Fund 3Impact 3a7b2c8b4c14a6c5a1b5

  • Issue#556: Tableau - Multiple Data Source Filtering Using Different Dimension than Parameter's

    Hi all, I’ve got a dashboard that has numerous sheets on it from multiple data sources. I’ve used a parameter to allow me to filter across all the data sources at once. The problem is, the dimension that I’ve used for my parameter is a product code that people can’t use for searching. What they need to use is the product name, but this product name dimension is in only one of the data sources. So is there a way for the user to select a product name in a quick filter on the dashboard and have all the vizzes change, even though it's the product code parameter that's filtering all the sheets?  Thanks!

  • Issue#7851: Tableau - Changing multiple filters before loading data

    Hi All, Currently, I have a few quick filters on my dashboard on Tableau Server. Every time I change a filter, Tableau Server will begin to load and refresh my charts/tables. Is it possible to change multiple filters at once on Tableau Server before it starts refreshing the data on my charts/tables?

  • Issue#41025: Tableau - Sorting Blended Data - Multiple Axis Crosstab

    I have a calculated field: Percent to Budget = SUM([Sales])/SUM([Budget]).  Sales and budget are located in two data sources.   I'm using a multiple axis crosstab as I need to be able to color individual columns separately, but I can't sort the data on "percent to budget", it doesn't show up in the "Sort by Field" list.   Any ideas on how I can sort by this field? 

  • Issue#50419: Tableau - Applying a filter to multiple data sources

    Hello, I have come across an issue which I need some help with. The attached sample workbook can be used to illustrate the situation. My original problem revolved around creating a running sum of orders which were undelivered. The goal behind the calculation was to add new orders as they are created and subtract them from the running sum as they are delivered. With the help of a contributor on this forum, I was able to put together a solution; however, I am running into an issue with the filters. To solve the original problem, I created a calendar in Excel and imported it as a data source. Then, I duplicated my data source which included all the orders and information about them, linked the order date and delivery date fields from the two data sources to the imported calendar and put together a running sum calculation using the imported calendar as the primary data source which worked perfectly.  The issue I am running into now is adding filters on top of the running sum calc

  • Issue#59964: Tableau - Not show Null Values in Quick filter for a dimension in secondary data source

    Hello, I am using two excels; one is primary data source (Employee-Issues) and other is secondary data source (Employee-Data). I have built a tableau worksheet using Employee-Issues and then created a relationship (data blending) with secondary data source using employee id field. However I here is a dimension called Country in secondary data source and I want to use it as a Quick Filter. The issues is that when I am using it as quick filter "Null" values show up and I am not finding a way to get rid of null values. P.S- tried creating set and then using calculated field. However, after creating set and calculated field I am not able to use that cal field in the filterI have also tried using IsNull in condition but it still shows upI have tried creating this formula:if ISNULL(ATTR([ClusterMapping (ClusterMapping)].[Cluster]))=FALSE thenATTR([ClusterMapping (ClusterMapping)].[Cluster])ENDbut it is throwing me an error: the "==" function can not be applied to table calculations

  • Issue#107976: Tableau - Multiple Date Fields in Columns

    Is it possible to create a text table with multiple date column fields? Please see my example below:  

  • Issue#108165: Tableau - Populate filter with values from 2 columns

    Hi guys.. =) I don't know if this is possible to make in Tableau. I would be very happy if you could help me or give me some workaround to solve my problem.  On my dashboard I have sheet like this:In database I have Home and Away columns (Match is calculation [Home] + "-" + [Away]) My client would like to have possibility to select Club and to see in this table All broadcasts where that club is home or away club...   If I put Home filter he will see only broadcasts where selected club played at home. Thesame with Away filter.. so this will not work for me.   I tried this solution:I made parameter with all club values, and calculation (If home = param OR away = param) whichI put as filter and choose "true".Problem with that solution is that I always have 34 clubs in it. I would like to have "only relevant values" in that parameter. So I think parameter is not a good solution because it provides only static options.   Is there a way to populat

  • Issue#124595: Tableau - Filtering across multiple data sources using parameters

    I am referencing the tutorial url below:Filtering Across Multiple Data Sources | Tableau Software  I have 2 worksheets which are using 2 different data sources and I have displayed them in a dashboard where I want to use 3 filters and all the graphs in the dashboard should change based on my filter selections. I am using parameters to create filters and adding the calculated fields in respective worksheets to filter values but the graphs are now empty. Not sure what am I missing here.

  • Issue#141503: Tableau - How do I only show data that exists in both values of given dimension

    Hi there, This is quite a tricky one to give a title to, but the problem should be fairly simple (it took me less than 1 minute to do the same thing in Excel). I've created a table which is split by search queries, and I have a "Week" dimension which I'm splitting the metrics out by. In this specific table, I want to only show the queries which appear in both of the dimensions. I've attached a screenshot of what I have at the minute, but the outcome I'm expecting is for there to be no instances where there are nulls in either side of the table. I really hope I'm just being stupid and that this is an easy fix, I've been at it for an hour already! ThanksDan

  • Issue#179922: Tableau - Trying to combine multiple columns of flags / filters into one...

    So I feel like this should be an easy thing to set up but it's not clicking.I want to be able to combine multiple flags into one where the user can select from a drop down box or radio button.  For example, to select "Global", "Europe" or "US" each have it's own criteria to make it for that region / country (not just a simple nation selection) so they are separate columns and the data types may be different (string for region or 1/0 for true/false) I tried doing this with a parameter and a calculated field but I couldn't get it working.  Not sure if sets would do it either but yeah ultimately just trying to combine multiple columns of filters into one so that the user can select from one list

  • Issue#201526: Tableau - How to use same alias for multiple columns

    Hi,  I have a report where there are multiple columns with same alias. For e.g. There are columns namely - "Volume for 2014", "%Share", "Volume for 2015", "%Share"  But I am not able to use same alias for multiple columns. Is there any I can do it? Regards,Romil

  • Issue#205617: Qlik - Display zero values in multiple columns in a Table

    Hi I've three columns in a table. Column 1 represents accounts, Column 2 represents Sales% and Column 3 represents Sales Target %.A salesman is assigned to sell certain products.Products are sold to clients who hold accounts.Each account has a sales Account Target associated to it.Both a client account as well as Target accounts hold products.Some accounts are sold products that are not part of the target account and vice versa. The performance of a salesman is measured by the sales he generates for a given account compared to that account's target sales.The attached qvf file contains the sales analysis illustrating the above example.The table needs to show following cases.1. An account has generated >0 sales2. An account has generated 0 salesUsing set analysis I am able to get the 1st case. But not able to show cases where account has generated 0 sales (case 2).In the data you'll see account IGV which has generated 0% sales compared to it's target of 0.13% sales. Please h

  • Issue#223655: Multiple Values in Geographic Maps Issue

    I am currently experiencing an issue where when trying to apply multiple values to countrys in a Map Chart it moves one of the values to "color saturation". The values in the data source (Excel) are formatted the same (currency). Can anyone help? I am trying to create the "Classic small pie charts on each Country".

  • 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#262561: Tableau - Filter on joined data sources omits dates if no filter values exist (despite no relation t

    Some help with the following would be much appreciated. I have tried "show missing values" and the solution on Unable to Show Missing Values (Dates) when date level is switchable using parameter but both approaches do not work for my data sources. I have two data sets, one with daily values ("Time Period" dimension) and one with values for Mondays only ("Week Commencing" dimension). I would like to plot values from both data sets on a week-by-week basis so I have used DATETRUNC to change the daily values to weekly dates. A "End Date Selector" parameter filters the data to show data ending on a specific "week commencing" date. The data is also filtered to dimension values in the daily data set (i.e. "Colour"). Problem: A dimension value (i.e. Colour = Blue) in the daily data set is not present for an entire week (i.e. 29 Feb 2016 - 6 Mar 2016). When the End Date Selector is set to 29 Feb 2016 and the Colour filter to only Blue, then the graph shows the last week for which data

  • Issue#263252: Simpler way to move data from all in one row multiple columns to multiple rows??

    Hello my fellow spicers. I am working in Access 2010, yes I know its old, but it does the job. Here is what I have and what I am trying to do.I have data in fixed length format coming into access, the data looks like this:NAME YEAR QTR DEDUCTION1 DED1 AMT DEDUCTION2 DED2 AMT etc..Kevin 2015 4LIFE0055.00HEAL0025.45DENT0005.60what I want is to get the data so that I have one column for deductions and one column for the amount. so it would look like this:Kevin 2015 4 LIFE 55.00Kevin 2015 4 HEAL 25.25Kevin 2015 4 DENT 5.60So what I have been doing is multiple queries. The first query creates the table and inserts the first 5 columns of data. Then I create another query that appends the first table with the first three columns and the 6th and 7th column. Then another that appends the first 3 columns and columns 8 and...

  • 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#291010: Tableau - Import only selected columns from Excel data source - Desktop v8.3.7 and v9

    Hello all,I have Tableau Desktop v8.3.7 and v9. I am connecting to Excel data source containing 20 columns but I need to import only 8 columns into Tableau for viz development. I searched the forum and the solution suggested was to open the xls file as 'open as legacy connection' and then use custom SQL. But, for the versions of Desktop I have, I am not able to get the custom sql option. Could someone provide screenshot to help? If there is some other option to delete the columns after import, that should also be fine Any help is appreciated Thank you,Praveen

  • Issue#300220: Tableau - How to make measurement values get aligned on columns or rows despite range?

    Hello team,I am attaching an view of the issue I'm facing when trying to display the values of different measurements being aligned to the left of each column (but it would apply if i want to align vertically as well). Since this are numeric values the axis will automatically jump into a range then the values alignment gets based on the range. I would like to get them all aligned horizontally, no matter if left, center or right.

  • Issue#322227: Tableau - Required columns are not present in the file with new data.

    Hello Team, I am having a issue while appending the existing file in tableau desktop. I have similar column in the tableau data source connection and the new file. but still I get the below error while uploading the new file. Required columns are not present in the file with new data.Column [Column Name] not present in the file with new data.Column [Column Name] not present in the file with new data. Please let me know if anybody come across the similar issue.

  • Issue#345235: Tableau - Two columns of data

    hi everyone,I couldn't find this so I thought I would ask. If I have two columns and I want to creat a calculated field that says. If column A has a date "any date" and if column B is blank then show that as 1  

  • 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#448629: Tableau - Combining Values in Multiple Fields

    Hi everyone, I have a data table that I need to work on that looks something like this. The column for (Program Attended 1, Program Attended 2, Program Attended 3, Program Attended 4, Program Attended 5) shows the name of different program attended by every respective company. Currently I need to show the number of company that has attended for every program. A bubble chart of the table above would show something like this.  Could someone help me regarding this. Thank you so much,

  • Issue#480715: Tableau - Using relative date filter across multiple data sources

    Hi all, I am currently building a dashboard in Tableau v9.2 based on 2 separate data sources (located on Tableau server). They contain many common fields, including a date field.I would like to use this date field as a filter in the format of 'relative date' filter, so users can chose whether they want to see the current/previous year/month/week/day etc. I can't get this to work with blending and am a bit stuck on how to proceed from here. What I want:At the top of the page I will have a number of filters, which need to apply across the two data sources to filter the relevant charts.The date filter should be formatted as a 'relative date' filterthe others are simple multi-select filtersall filters are based on fields that are available in both sources How can I present an elegant date filter solution to the users?   Many thanks for your help,Eva

  • Issue#483883: Tableau - Trouble with multiple columns of dates

    Attached is a file similar to the one I am working on. There are 10 types of animals. Along with those animals, there are dates associated with estimated birth dates. I have written a few calculations that say if the date is > 0, put "A", and so on for each column for charting purposes. I am running into a problem with having 8 different dates in 8 different columns. If I put "Type" in the row, "A_Date" into the column and then enter "A_Date" into "label" it works and shows the correct verbiage for the associated months. However, when I want to enter "B_Date" into the same chart it does not work because the A_Date is dominant.  I do not know how to have the "B_Date" show up in the correct associated date. Any ideas? Please let me know if I did not explain well enough.

  • Issue#486079: Tableau - Monthly Updated Dashboard with Data from Multiple Excel Files.

    I am looking for guidance to set up data from multiple excel spreadsheets to work well in Tableau. I am creating a high level overview dashboard for a network of 50+ schools. The dashboard will include around 30 different metrics housed in 7 separate excel spreadsheets.All 7 separate excel spreadsheets are normalized, have the same unique identifiers, these files are kept separate because their formats are slightly different and most important they are owned by different people that update them when data is available, some updates are monthly, others 3 times or twice a year. As soon as data owners update the spreadsheet, the dashboard should be updated too.  In my research, I learned about data blending and data joining. Data blending looked like a good option until I couldn't figure out how to control the dashboard with a global filter. Data joining has potential, except every time I experimented with this feature I noticed numbers changing in my dataset, specially in Levels