1. But as you have one row for each ID and you really only want one row for each location, you need to filter the results so it only shows one result per location. Now if you are asking to total across rows, well that's a different story and will take the type of new calculated fields like above - so would be a pain ** Robin, The ZN function will not work because of the data blending. The easiest way to make a crosstab table is to drag measure values onto the Text mark. Tableau Desktop; Data Blending; 2 Data Sources with. Loading. Below is an example of using Attribute in a table calculation. However, this. When finished, click OK. 1, your parameter values and list of values will automatically update to the most current values every time the workbook is opened. I created calculated field 'SO Placed?' in the account inquiry data source using the following: IF [Data (Sales Orders)]. Thanks a lot. If the 2. e. Is there any way to get a total in a field for secondary data source fiedl I have 2 data tables I am blending - both are tableau extracts. 85-95% of target may equal Bronze, 95-105% may be Silver, etc. Also the SP list "DB Name" field has a 1 to many relationship with the incident records in the CSV. created a parameter and added values to parameter from the primary data source and created calculated field like Parameter = column_name from secondary data source. But by default they're the fields from the primary datasource. In the workbook, we have 2 data source . then right click on the parameter and show it. When I created a calculated field to. When you try sort by a calculated field that uses blended data, the calculated field is not listed in the Field drop-down list of the Sort dialog box. I have two source of data: sales data from SAP and Excel file. The solution to this was to blend this data on top of my primary to get all 400 chargers. Step 2: Create the Calculated Field. The easiest way to make a crosstab table is to drag measure values onto the Text mark. Normally if i am using the same data source to calculate running sum of a measure ,I would create a calculated field using running sum function and go to the compute using-> advanced-> field and then select the measure and check the descending order button. but Primary Data Source is a Tableau Server Data Source (I do not have direct access to the database), and Secondary Data Source is an excel flat file. In this example, the calculated field is named "Replace empty cells with zero (opt 3)" In the formula field, create a calculation similar to the following: ZN(LOOKUP(SUM([Amount]),0))Here is the sample data (tableau file attached) After Blending i'm expecting to receive this result: the rule is joining the 2 table using [Client number] & the order of the record per each Client by date (1st policy match with 1st Sales for each client). If I blend my data, create a dashboard with data visualized from both the blended sources, I expect to be able to set a global filter on the linked field(s) of the blended data. This was the method used before Version 10. Please find a sample of the data below - it's on my Tableau public profile. Hi, I have two tables like below. Expand Post. For issues sorting on a calculated field, see Sorting by Fields is Unavailable for Data Blended Measures. Build whatever calculated fields. So once you update this data source in all other workbooks using joins, going forward you just need to update this single source. Using filtered data in a blended calculated field Hi all, I am trying to find a way to use a value that is passed in from an API as a filter value (it has to be a filter value) to highlight one value amongst non filtered data, essentially working like a set,Double-click State to create the map view. Instead of the sum of all sales per region, perhaps you want to also see the average sales per customer for each region. Open a new sheet and place Sales to columns, Ship Mode to rows, and Reference Line to details. Resources Toggle sub-navigation. When I searched "Door ID" in data source 1, I was able to find some of the values. In this example, the calculated field is named "Index". Course Description. "All fields in a level of details expression must come from the same data. Excel files contains only two columns: the name of category and date of premiere of category. You can use Tableau's own pivoting function. In the last two articles of this parameters Deep Dive, we’ve learned how to use parameters with filters and within calculated fields. From the “Apply to worksheets” menu, select “All using related data sources. In the Data pane, select the Store - North data source. Replace the calculated field that references a field in secondary data source with calculated field created in step 2. Then drag Quarterend date to Rows, since we want financial data by date. Let me. Ali. Advertising cookies track activity across websites in order to understand a viewer’s interests. Depends on how your data is set up, and what field you're blending on. Tableau provides Date Functions to deal with temporal data, like DAY, MONTH, and YEAR. I tried having both the calculated fields in the same data sources and using the filter values applied to the data set within the same source but it is no use. If you want to hide this column from your report, just remove the tick mark on "Show header". You can build out the basic ATTR function by adding conditions for when the ATTR function. When you’re in Tableau creating a calculated field, you might find yourself running into the following red-text error: "Cannot mix aggregate and non-aggregate arguments with this function. Where [Date] is the field you want to filter and [Parameter Date] is your new parameter. Step 1: Create the calculated field. The option to change the aggregation type of the grand total to something other than Automatic is grayed out. Performing calculations with fields from more than one data source can be slightly different than an ordinary calculation. Expand Post. Your visualization updates to a text table. Counting a row in a. If you're concerned about proprietary data, anonymize your data as demonstrated in the video linked here:Can someone help me understand why a calculated field is a measure? I've blended 2 data sources based on loan number. One solution we have is to include "Region" column in DB apart from "Biz Region", based on which we can swap the column. Tableau Public; Data Management; Advanced Management;. Then drag Measure Names to Columns. If all the field are in the original data set already would be like this. In the Table Calculation dialog box that appears, make your changes. In the Formula text box, type the following formula to create dynamic labels for the customers in the set:1) Created a view with Project ID & Date field on Rows. Products Toggle sub-navigation. Data blending is different from joins in that joins are done at a row level, but data blending is done at an aggregate level. Felt like this table cal is like Level of Detail calculations. See Troubleshoot Data Blending to learn more about the asterisk. Sales Order Placed? ZN comes from the sales order data source. I would like to see a ratio of the two, so I created the following calculated field: The above method is called data blending. The total revenue appears. The published workbook is connected to the published ds. To create this metric you need to divide Transactions by Revenue, however, we did not bring the Revenue metric into our new Blended dataset so we can not create a calculated field like we normally did above. Filter Out Null Values. At this point, the options are to join the two sources using two other actual data fields or modify the underlying data in one of the sources so that a relationship can be established between the desired fields. A datetime field may be converted to a date field using a calculation to remove the time portion. Are you able to create 2 fake data sources and blend them in a workbook and upload it here. Tableau Public . You'll learn Tableau calculation concepts,. Create a new calculated field on the "Sheet1 (faketeamnames)" data source with the calculation [Team Name Parameter]=[Team Name]. Use a FIXED expression to remove the duplicate data. I have two data sources, one with costs, the other with sales. Regards. Blending from a polygon-based map to an existing data source which uses 1-to-many joins. Parameters can be used to filter across data sources that have no relationship. Now, let’s go step by step and see how to use rank function in tableau. According to the year, quarter, month, week, and day, you need a new calculated field to display the sales. Both source fields and target fields appear on the Filter shelf in their respective worksheets. 2) As they mentioned in the solution, it is not production complaint. 4. 1. data sources Filtering parameters Tableau Tableau Tips. Please check the attached workbook for details. I appreciate the response! I suspect the issue is due to a logical layer being applied via relationships to the data sources. superstore sales]) Then in a single mark i could get the total sales for both data sets, and where dimensions are added, and blended, the sum by these dimensions. When you are in your calc field editor, you have a list of all your fields. At that point the calculations only exist in that workbook and aren't available in the data source. 3. Thanks for your time and assistance. The aggregation. Hello everyone, I am working on the accounts data of a certain financial institution. Note: the parameter belongs to the workbook and can be created from any data source (primary or secondary). not just join table from 1 database. Option 2: Use a separate bar for each measure. From the Data pane, under Measures, drag Sales to Text on the Marks card. I then create two calculated fields: 1) Event Duration within Period - This is the length of an event during the specified period length. Change the default sort order of the field using the various options, and then click OK. 3) Tableau pads the data to fill in the missing dates. In the view toolbar, select Data Guide to open the Data Guide pane. 0” in. Tableau Deep Dives are a loose collection of mini-series designed to give you an in-depth look into various features of Tableau Software. Initially it seemed to work. Additionally, if one field is aggregated in a calculation, all others must be as well, so wrapping those fields with an ATTR() aggregation will. With data blending, the linking field from the primary data source must be in the view before you can use a level of detail expression from the secondary data source. e. In the Calculated Field dialog box that opens, enter a name for the field. Blend as normal - you'll only return 1 value per name from the. In the custom SQL field or dialog box, copy and paste the UNION ALL query. Then I have a calculated measure field with the formula SUM(DS1 Measure) + If ATTR(Structure) = "Description. Best wishes. Union combines the data vertically, concatenating the rows from multiple sources. number of policies, total premium etc. The field I am linking on is ‘Order ID’, so I have called my field ‘Selected orders’ and written the calculation below. The Assigned Block calculated field goes through the logic and gets to the "IF. Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Environment. Create a calculation field Diff. You might want to create another datasource with these mapping data and use this data source in all other workbooks. From the dashboard, add a State filter to the Coffeechain data set. I am not able to blend on this calculated field. Problem is summarizing that up. This data is not captured every 15 minutes but is event triggered. In the worksheet view you see the both tables: earnings and prices. Right click the column and sort on your measure. Above that list is a pulldown of all your other datasources. Select one, and you'll see the fields for that tadasource. Under List of Values, select Add from Field > Sample - Coffee Chain > State. 4. Loading. Unfortunately, this isn't something I can modify. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. If you create a quick filter on a field from data source 1 and apply this quick filter. 2) In the primary data source, created a Top 1 Set called "Is Latest Date" on the Date field dimension using MAX(Date). You could add "date rows" with a union statement in your database connection and then convert this to a date in tableau using a calculated field: Date =. If the 2 datasources have the same columns, you shouldn't need to re-pull the data. Right-click the 2017 header in the view and select Exclude. 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. You can put the data in different sheets in an excel file and create simple joins. About Tableau. Tableau provides a set of predefined aggregations that are shown in the table. Data Blending - Calculated Field Hi, I have a workbook which contains a blended relationship between three data sources. Your new blended data source and chart will be created. To calculate: 1. The data per month is correct (see calc1), but if I add totals (see calc2) or drill up to year, they are wrong. As you have probably guessed, blending messes up the aggregated calculation for the total cost of each order, and consequently of each day. Hiding unmatched nulls. {FIXED [Machine Nr] : COUNT ( [Machine Nr] )} / {FIXED [Machine Nr] : COUNT ( [Machine Nr] )} This works fine when there is no secondary data source but when I blend with a secondary data source it grays. I selected "Specific Dimensions", then checked on all the dimensions, and finally selected to restart every month. Hello! I have 2 datasets with one connecting field. For example, you can blend data from different BigQuery tables—say customer information and order details—and visualize that information in a single Looker Studio table. 1. Upvote Upvoted Remove Upvote Reply. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. Data blending is particularly useful when the blend relationship. I'm in a catch 22. You can set the default aggregation for any measure that isn’t a calculated field that itself contains an aggregation, such as AVG([Discount]). 0” and enter “1. There are calculated fields which calculate the global average. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. I am trying to use the below formula instead of countd function because my data comes from Impala. Workaround: Option 1: Instead of using Data Blend, please use Relationship to relate the data sources, and the "Only relevant values" option is available to show only existing values. Work across blended data sources. Example Using Tableau 10. For example, it might be the SUM function. The formula that I am tried is shown in the image below and is: IF [Period] = {MAX([Data to Map From (Tableau Dummy)]. Here in this workbook I am Calculating Percentages using Inner Join and Data Blending. ; Drag Number of Records to Label on the Marks card. It's the data on sheet 2 that I'm having trouble with in dividing the middle column (% count of sales. If you are looking at data from two disparate data sources, then you either need to join the data into one data source, or define the relationship within Tableau in order to use data blending. In the Open dialog box, find your Excel workbook, click the Open drop-down menu, and then select Open with Legacy Connection. If I have filter 'Category' and choose 'Furniture', the 'Sub-category' filter items on the dashboard are not reduced to show values relevant to only 'Furniture' category. So, now the third field could mean displaying the table across values in the pane for the individual values, and the table down value for the total/grand-total value. We recommend using relationships as. Click on the triangle and you can select "Edit Table Calc". The secondary data source only has: Google Play, iOS. For Data Type, select String. Process for Creating the Dynamic “Parameter”. CSS ErrorThe data set considered here has information regarding order date and ship date for four different regions. Then just drag fields from data field list for the secondary source into the calc editor. Also the SP list "DB Name" field has a 1 to many relationship with the incident records in the CSV. i. So you did answer my question, such that, to filter data from 2 different data sources based on date - create a parameter, then create calculated fields in both the data sources. Here, you would still see 'Null'. Step 3: Create the new field. All of the fields from my primary data source are not aggregated, and when I bring in the fields from the blended data source for the calculation, it automatically aggregates those 2. When you are in your calc field editor, you have a list of all your fields. I have a parameter date that I use to be able to filter across both sources and to show last year's information and this year's information in the same view. If I have: blended data with date as the linked field. In the calculation dialog box, do the following: In the name text box, enter Sales for Store - South. In the calculation editor that opens, do the following: Name the calculated field, Running Sum of Profit. All of the work is done in Tableau. Here are the 7 major steps for putting this together: Set up your primary (main) and secondary (parameter) data sources. So the question here is the user comes to the Parent_child worksheet which uses first data source and clicks the parent, I populate Child set with all child associated with that parent selected using Worksheet Actions. Drag the calculated field to the Color shelf on the Marks card to create a view that shows which fields match and which fields are different between the two data sources. Data source 1 (Region to Sales) - This has sales as per region, in region column we have "KAC" and "IMP" which is business defined Region. Both source fields and target fields appear on the Filter shelf in their respective worksheets. I create calculated field "Number of period" in many steps. Tableau(Calculated Field) 0. If you are looking at data from two disparate data sources, then you either need to join the data into one data source, or define the relationship within Tableau in order to use data blending. I need to find the difference in days between "Open Time" and "Go Live" for calculated column I want to use as a filter. 2 data sources blended: 1 published: where I have at reference level information of the flows that help me calculate the min and maxi inventory. I have a scenario in which I need to blend the data. The two data sources are blended on a string value they have in common called "DB Name". The concept of "row" is meaningless across two unrelated data sources. Work across blended data sources. That said, I'm not sure how I can then use this data to create labels on line chart that comes from the blended data. When you want to add fields from your secondary source, while still in the calc editor, click on your secondary data source in the data source shelf. It wouldn't turn the two date fields into one. Additional Information While replacing ATTR() with MIN() will cause "Automatic" grand totals to show, the grand totals might not be the expected values. So it will always be pulled into the calculated field as aggregated field and for that your 1st field needs to be an aggregate too because you can't the mix the two. Within same worksheet, you don't lose table calc settings unless you keep all fields in the table. Total aggregations cannot be applied to table calculations or fields from a secondary data source. Option 2: Create a calculation using WINDOW_SUM () Drag the linking field (s) from the secondary data source to Details on the Marks card. For example, type SUM([COGS]). Step-2: Select the chart whose calculated field data type you want to change: Step-3: Find your calculated field in the properties panel: Step-4: Hover your mouse over the ‘AUT’ symbol. a)="x" and ATTR(D2. For example, suppose you have two data sources that are related by the State and Date fields. I have been struggling to come up with a way to fix the global average field while traversing through accounts in the quick filter (to show account's. If you look at the Blocks tab (which is sorted by day and start time), a procedure starting at 1:11pm would fall in the ROBO 1 block, which started at 12:30pm. Parameters as you'll likely be aware, are global so they can be used by all data sources. In the Calculation Editor that opens, do the following: Enter a name for the calculated field. Some examples include: cookies used for remarketing, or interest-based advertising. This often requires using user functions in a calculated field; The published, filtered data is used to build contentWhen using multiple data sources, it is common that I will create a metric and sum it from the various sources, for example: sum([superstore sales])+sum([b. The only filters that will remove values are data source filters and context filters. Row level calculations are by definition within the same data source. The target field on any given worksheet is a field from another data source that is. Parameter field could not be refreshed automatically, if underlying data is changed by tableau server scheduler. In a calculated field, try writing a measure that combines the data you want to sort. You can use different approach like custom SQL join. A datetime field may be converted to a date field using a. b) Use an R script. Doubleclick on one of those fields, and it will be added to your calc window. In this case you partition by Movie and address by days. If I blend my data, create a dashboard with data visualized from both the blended sources, I expect to be able to set a global filter on the linked field(s) of the blended data. In the custom SQL field or dialog box, copy and paste the UNION ALL query. And dragged the calculated field to filter to select true. Your visualization updates to a text table. I knew there is a way as below link, but that way I have re-do all calculated fields which is really time consuming. Create (or edit) your calc. For example, select Analysis > Create Calculated Field, and in the Formula text box, type the following formula: How to compare blended data sources to classify matching and non-matching records. To concatenate in Tableau: Go to the Analysis menu and select Create Calculated Field. I blend the costs with the sales to determine for each sale whether it was above or below cost. By extension, Bob's colleague Tom Brown requires access to his own sales data, and also all sales data for NY, PA, and FL. If you've multiple different data sources then you can use cross-database join option. Use a blend when: You want to combine measures or dimensions with the same meaning but different names in each table. For Allowable Values, select List. Parameters can hold any arbitrary values, whereas sets are always tied to a field in the data source. ; Drag the Region field to the Color shelf on the Marks card. There are 2 data sets (for this example, there is 1 column, and they are the same field). Format the date show that is shows the full date. Let’s begin with what it is: the ATTR() function is for the aggregation of dimensions to turn them into measures. Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. The inner IIF() is a row-level calculation that evaluates the In/Out of the Set, then that gets wrapped in MIN() because we’re working across the blend – Tableau requires us to aggregate all measures and dimensions used in calculated fields from other data sources. 3) To keep only the last row create a second calculated field Whether Last or not using the Last() function and selecting the default table calculation (blue font) with the same selections as Running total above i. In the formula field, create a calculated field similar to the following: SUM([Profit])You can also solve this using data blending. Tableau’s INDEX () function allows you to easily compute the number of weeks since opening. Select one, and you'll see the fields for that tadasource. In the calculated dialog box, complete the following steps: In the name box, enter State Filter. Because multiple, related tables have independent domains and retain their native level of detail, when you drag fields into the view: Data is queried at its natural level of detail. From the Measures pane, drag Measure Values to Rows. How to filter on primary data source only in blended data chart. Loading. In the worksheet view you see the both tables: earnings and prices. items) as a string in a parameter and pass that to a second workbook. Loading. ×Sorry to interrupt. Learn Tableau. The source field is the field you're filtering with. Any thoughts on ways round this would be much appreciated. Step-2: How to create Table Calculation. Create a Calculated Field to Link Account. Then the calculation is in the data source and available to other users of that data source. . Option 2: Join tables that are in the same data source, instead of blending them. It displays the measure accurately within each color segment. The view is setup like this: The Grandtotals for the View are not correct. ) with the column on the right (% population). Filtering Across Multiple Data Sources Using a Parameter; Cause A sheet cannot be filtered by a field from a secondary data source. I have a Finance Dashboard that contains a data source with thousands of transactions. Otherwise how Tableau will know what to filter. After some research, I have learned that using a LOD on blended data isn't possible. When finished, click OK. The DS1 field is supposed be under Description A1 and the DS2 field will be under Description B2, although Description B2 also has data in DS1 (DS1 data for description B2 will not be used in this viz). Performing calculations with fields from more than one data. The CY dataset contains around 1100 records. Open a new workbook and on the Connect page that opens click Excel. Tableau Data Management. If this aggregation is ATTR() then the grand totals may be blank. I believe this will resolve your issue. Next, drag Category from the Orders data source onto the view, then select the Orders data source and click the chain icon to blend on Order ID. Filtering data from the other source seems to incur restrictions such as "All fields must be aqqreqate or constant when using table calculation functions or fields from multiple data sources. A union in the tableau data source screen is 100% the best way to go. Sales and budget are located in two data sources. Step 1: Create the calculated field. according to a representative at tableau, there is no solution to this problem at present, though they are looking to solve the blended data aggregation issue. ThomasData blending is a very useful tool, but there are some effects on performance and functionality. Calculated Field based on two data sources. @Adrian Zinovei (Customer) yes, I already tried that, that only makes the Tableau workbook more complex but still won't achieve the end goal :) . Right-click the parameter and then select Show Parameter Control. I then used this method for Blended Grand Totals. {FIXED [Business Unit],[Region],[Current Month]:AVG([Billable Utilization])} Is it because we calculated Billable Utilization with aggregate functions, we have to use Table Calculation. When creating a calculated field using fields from blended data sources, the field must be aggregated. A new window will appear on your. Data blending brings in additional information from a secondary data source and displays it with data from the primary data source directly in the view. if actual run time falls in between expected start and end time, file is processed otherwise failed. The source field is the field you're filtering with. With this action, the null values will be removed from your view, ensuring a more accurate representation of your data. Calculated fields are always saved in the workbook and you can see them in the . Hello Mo, Considering how Tableau blending works--basically as an aggregated subquery rolled up to the level of your related fields--you are stuck with needing all fields to be aggregated before being leveraged in a blended-data-source calculated field. When I created a calculated field to show me if the name from Data Source 1 equals the name from Data Source 2, I can't get a count for the True/False without having two drag the two fields onto the pane. [Sales Cycle])} THEN [PY Sales] ELSE 0 END That article mentioned this method works when "2 Data Sources with Identical Data Structures" which is not the case here. Now, let’s go step by step and see how to use rank function in tableau. Embedded Analytics. ×Sorry to interrupt. You won't see the 'Null' and as you change the values in the parameter, the calculated field changes in the background. With Tableau Data Blending, the key to blending with dates is: the time period you blend on. . Just create a parameter with data type as a date then create a calculated field like this: [Parameter Date] = [Date]. You are now ready. First one shows number of specific calls for agent by date, second one shows total number of calls by agent, by date. Hi all, I have a massive workbook which contains 10+ data source and most of data source have a few calculated fields with blended data. Using Sheet 4 of your Excel data set, in Tableau's data source tab, highlight your measure 1,2,4,5, & 6. The actual data set I use is huge and a join is too slow. are the. Any time data blending is in action tableau will be querying multiple datasets. It is necessary to know which dimension in the data source is unique for each row value, or the combination of dimensions. Tableau’s answer to this situation is the blended calculation, in which fields from more than one data source can be used in a single calculated field. - When Tableau creates or optimizes a Tableau data extract, record-level calculated fields that don't depend on parameters or runtime functions like DATE(), NOW(), USERNAME(), or ISMEMBEROF() will be materialized (i. 0. The target field on any given worksheet is a field from another data source that is. Which can be interpreted as "there is more than one value". Expert instructors. The View Data window displays row level data at the correct level of detail, without replication, to make validation easier. ×Sorry to interrupt. Tableau Data Management. There are some potential work arounds, but they are limited and clunky. Create a calculated field in both data sources as below. Option 2: Create a calculation for a more dynamic sort. A datetime field may be converted to a date field using a calculation to remove the time portion. 0. In the following example, the Market Share calculated field is not listed in the Field drop-down list. Hi there! I am using two data sources that must be blended and I want to create a calculation on the maximum date of the primary source. Then I created a calculated field like the CASE WHEN in that post. [Total Cost]) - ATTR ( [Previous]. Oh, we're using Tableau 9. (TABLE(across) tells tableau to do it on a row-by-row basis. In this example, the field is called, Discount Ratio. Create the new field by adding Impressions + Total Views. However, there are ways to constrain blends using filters and calculated filters. You can turn on subtotals and totals too. The percentages are calculated with the Sales measure aggregated as a summation, and are based on the entire table. Deploy your workbooks with dynamic parameters and never again think about manually updating your parameters with the latest data. In the Calculated Field dialog box, do the following and then click OK: Name the calculated field. There are some potential work arounds, but they are limited and clunky. And the "show empty rows" selection is automatically greyed out when i blend data. Then I will right-click Order ID and select Sort. This says to take all the values within a month across the Category dimension. Doesn't work as this means that there is a one to many relationship for multiple fields, meaning that just a * is displayed; Generate lists of (e. In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. d)="y" then "Filter Me"I have a calculated field that computes a ratio using two data sources that are blended (SUM(souceA. You could add "date rows" with a union statement in your database connection and then convert this to a date in tableau using a calculated field: Date =. For each data source, something like: DATETRUNC('year',[row_date]) Can be used to create a field from the Year. Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Jonathan. Data blending brings in additional information from a secondary data source and displays it with data from the primary data source directly in the view. This will be the field we use to link to our secondary data source. While blending a secondary source, you are blending the second source thats post-aggregated and the results will be grouped based on dimension that is being joined. Join combines the data horizontally, merging the data based on a specific field, such as a shared key or identifier. For example, you could manually map a user named “Alice” to the value “East” so that she only sees rows in the data source where the “Region” column is. Using a data source that has multiple, related tables affects how analysis works in Tableau. I've tried filtering across multiple data sources using a parameter + calculated field. To do this, I will drag the “Sort By” calculated field to the Detail Marks Card on my view. This extract will included all the calculated fields that are included in the current workbook.