Replace the calculated field that references a field in secondary data source with calculated field created in step 2. Synchronize axis across worksheets, blended data. Option 1: Use a separate bar for each dimension. When creating a calculated field and then having platform as columns I get the following result: Steam and XBOX does not have revenue appearing even though the primary data source has data for those values. The data per month is correct (see calc1), but if I add totals (see calc2) or drill up to year, they are wrong. And the "show empty rows" selection is automatically greyed out when i blend data. 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). Some examples include: cookies used for remarketing, or interest-based advertising. You may need to use it when creating calculated fields across blended data sources, for example. 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. Loading. Complication(s): Data is spread across different tables in different databases (biggest motivation to use Tableau, in fact). CSS ErrorThe data set considered here has information regarding order date and ship date for four different regions. 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. Under List of Values, select Add from Field > Sample - Coffee Chain > State. Blend as normal - you'll only return 1 value per name from the. The COUNTD Alternative example workbook uses Distinct Customers. Please check the attached workbook for details. [% age]>=SUM([Percentage]) . This extract will included all the calculated fields that are included in the current workbook. Is it possible to label these data sources something like 'Current' and 'Previous' so that my calculated fields can refer to the labels rather than to the actual date-named data sources - something like: ATTR ( [Current]. According to the year, quarter, month, week, and day, you need a new calculated field to display the sales. 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. Training includes 30 hours of hands-on exposure to ensure that you are left will a feeling of being an expert at the Tableau tool usage. Tableau Deep Dives are a loose collection of mini-series designed to give you an in-depth look into various features of Tableau Software. 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. Usually complex and aggregated calculations may be too complex to be used in the Sorting and those which use table calculations or other restricted ones are excluded. Drag Measure Names to Color on the Marks card. This will be the field we use to link to our secondary data source. No. Step-2: How to create Table Calculation. 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. I create calculated field "Number of period" in many steps. But since it is a blened data source, i can't use LODs. This task assigns the states in the Population data source (primary) in the "null" region into a region. Tableau Data Management. And Put this field in your view at the start of all the columns in table/Grid. Create (or edit) your calc. Combining dimension values to create an additional dimension value. Both source fields and target fields appear on the Filter shelf in their respective worksheets. Create a calculation field Diff. The other to get the Max month as and when the data source is updated. Two other things: The ,0,IIF(FIRST()==0,LAST(),0) optimization is not needed if you’re using Tableau v8 or later. 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. Above that list is a pulldown of all your other datasources. This is the "self-left join" worksheet in the attached. Option 1: Join the data sources with a cross-database join instead of blending. Tableau Public . In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. Create a calculated field (“previous value”) that contains: PREVIOUS_VALUE (0) + SUM ([Ones]) Drag this new field into the Measure Values container: Play a bit around with it, change the expression of the function, use it in another calculated field – there is no right or wrong, just learning. To calculate: 1. b) Expected subtotal method = SUM (SUM (primary. 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. Data Source page changes. In the Calculation Editor that opens, do the following: Enter a name for the calculated field. Has been rolled over: A binary field that is true if an account has been rolled over. Note: the parameter belongs to the workbook and can be created from any data source (primary or secondary). Tableau has an answer: Data Blending. For more tips, see Tips for Working with Calculated Fields in Tableau. I appreciate the response! I suspect the issue is due to a logical layer being applied via relationships to the data sources. Create a Calculated Field to Link Account. Any thoughts on ways round this would be much appreciated. co as a source. achieving the above mentioned fraction with the condition of selecting data only for the last month available using a *calculated field* and blending the two data sources with the available fields for dates in both data sources?. e. Also, if your calculated field is a regular aggregate (i. A calculated field is a formula that performs some action on one or more other fields in your data source. Relationships are a flexible way to combine data for multi-table analysis in Tableau. Hi Voltaire, One approach is to use the option to Show Empty Rows / Columns (available from the menu, select Analysis > Table Layout) which will force Tableau to show every value for a dimension on Rows/Columns even if it is filtered out. Step 2: Create a Set and use it in a calculated field. 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. An equal sign (=) appears next to the data type icon. Replace the calculated field that references a field in secondary data source with calculated field created in step 2. Is there something in the original data source that fills in that field (like a space)? edited: I think I figured out part of the problem - both the STL and Tulsa P10 2015 data sets don't even have t. Hello everyone, I am working on the accounts data of a certain financial institution. On Color, right-click Measure Names , select Filter, select the check boxes for the measures to display, and then click OK. LOD calculation and blended data sources. Advertising cookies track activity across websites in order to understand a viewer’s interests. Products Toggle sub-navigation. With this action, the null values will be removed from your view, ensuring a more accurate representation of your data. Total aggregations cannot be applied to table calculations or fields from a secondary data source. Absolutely - if you just take out Location from the view, this will work. If Channel<> 'Video'. A new window will appear on your. Build a Data Culture. Here is another solution using your Excel data set on Sheet 4. In the Calculated Field dialog box that opens, complete the following steps: In the Name text box, type Subset Labels. Then drag Measure Names to Columns. In the Data pane, fields and calculated fields are automatically organized by their native level of detail. But by default they're the fields from the primary datasource. ×Sorry to interrupt. number of policies, total premium etc. You can use Tableau's own pivoting function. Course Description. Drag the New Custom SQL table from the left pane to the join area. In Tableau, select Analysis > Create Calculated Field. Click on the triangle and you can select "Edit Table Calc". This means that date ranges, filters, and calculated fields in a table are applied to the query that generates the table before any joins are performed. This article describes how to create and use calculated fields in Tableau using an example. Where [Date] is the field you want to filter and [Parameter Date] is your new parameter. Your visualization updates to a text table. 2. I wonder if that is the reason it does not work for me. Tableau provides a set of predefined aggregations that are shown in the table. so I would like to show a pie chart how many files are. The problem is that the filters from the blended data source that are used on a dashboard otherwise showing data from the secondary data source are not interactive. In the formula field, type the following, and then click OK: WINDOW_SUM(MIN(1)) The problem is the target line should go all the way through the end of the event, even if it is in the future, but since there is no sales data for the future the line gets limited on the blended data. The data appears as if from one source. Then transfer the created measure to the Rows or Columns shelves. [tier] == 2 'Top Vendors' else 'Mid Vendors'. Assignment Actual Work is a field from secondary data source. Process for Creating the Dynamic “Parameter”. Option 2: Create a calculation using WINDOW_SUM () Drag the linking field (s) from the secondary data source to Details on the Marks card. When you are building a viz with fields from these tables, Tableau brings in data from these tables using that contract to build a query with the appropriate joins. Since we are not sure of what the source is, you may want to start from the non-calculated fields first and keep adding to. Hi All, I have expected file results and actual file results tables in two different databases, (linking is not allowed), and I am blending these two data sources to get the data from these 2 tables. Initially it seemed to work. I've tried filtering across multiple data sources using a parameter + calculated field. This warning occurs when you have no active links in the secondary data source. The IN/OUT of the Set returns True for the latest date across the entire data set. I want to get a grand total of teh secondary data source column in a calculated field, just like we can use FIXED LOD to get the total same across each row. Of clients = RunnigTotal. a)="x" and ATTR(D2. How to use a field from Blended data source in FIXED LOD calculation? Why Tableau Toggle sub-navigation. Parameter field could not be refreshed automatically, if underlying data is changed by tableau server scheduler. Key Performance Indicator (KPI) Dashboards. The option to change the aggregation type of the grand total to something other than Automatic is grayed out. An example, perhaps sales progress to a target impacts the bonus. It. If I have: blended data with date as the linked field. if actual run time falls in between expected start and end time, file is processed otherwise failed. The Salesforce Advantage. Tableau Data Management. CSS ErrorTo do this operation, we require the following steps: Create a new sheet. Any time data blending is in action tableau will be querying multiple datasets. Click the drop-down arrow on the Marks card and select Map. This data is not captured every 15 minutes but is event triggered. Row level calculations are by definition within the same data 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. Data blending is particularly useful when the blend relationship. Option 2: Create a calculation for a more dynamic sort. In the worksheet view you see the both tables: earnings and prices. 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. Hiding unmatched nulls. Then I created a calculated field like the CASE WHEN in that post. Hello everyone, I am working on the accounts data of a certain financial institution. ”. In this case, Tableau reads MAX (Block) as MAX (ROBO 1, ROBO 11) and chooses ROBO 11. Cause Tableau Desktop cannot identify what information to use for the action filter if the field used for blending is not included in the views that are affected by the action filter. The simplest way to achieve row-level security in Tableau is through a user filter where you manually map users to values. Creating a calculated field for "SerialNo" or lets say Index(). 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. A datetime field may be converted to a date field using a calculation to remove the time portion. When finished, click OK. See Data Aggregation in Tableau for more information. This says to take all the values within a month across the Category dimension. If you have two very similar data sources each with dozens or hundreds of fields and for one you already created a huge amount of calculated fields, set and parameters, it would be great if you simply could copy and paste them to the other data source. Tableau data blending with calculated field There are rare situations where the requirement is to blend on a calculation, on a measure. Select Analysis > Create Calculated Field. Option 2: Create a calculation using WINDOW_SUM () Drag the linking field (s) from the secondary data source to Details on the Marks card. 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. In my other data source I have a field called sum_total_request_count (How many total requests were made). Data Grid. I attended a 'Tableau Doctor' session at the Tableau Conference, and the expert confirmed this functionality is not possible on a blend due to the order of operations, with blending happening last on Tableau's processing logic/order of operations. All of the work is done in Tableau. In the secondary data source, create a calculated field. There are accounts present in the account inquiries data source that are not in the sales order data source (i. doesn’t use table calcs or fields from another data source) and you’re on v8. At the line level it's fine, but what I require is the sum based on supplier like a pivot. The source field is the field you're filtering with. You'll learn Tableau calculation concepts,. I created calculated field 'SO Placed?' in the account inquiry data source using the following: IF [Data (Sales Orders)]. Expert instructors. Step 2: Create the LOD expression. Move the Year of Order Date and Customer fields to. A row-level calculation is something that is computed for each record in the data. This post covers tips and tricks for working with relationships. "The calculated field I am nesting within the other calculated field has a value of: [Measure] = 'MedWg' AND [Characteristic] = 'Totals' . Doubleclick on one of those fields, and it will be added to your calc window. Create the new field by adding Impressions + Total Views. ([Measure] in this case is the name of a field in my db, not the Tableau measure) This evaluates as a valid calculation. Create a user filter and map users to values manually. 0” and enter “1. 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. As seen in attached sample workbook, we. Although those field values can be re-aliased. I believe you need to create a calculated field for the YEAR of row_date in order for your blending to work properly. One solution we have is to include "Region" column in DB apart from "Biz Region", based on which we can swap the column. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. Optimizing performance. It can. For example, it might be the SUM function. Tableau needs to be able to see the actual data in the fields in order to create the relationship. I then create a calculated field as follows: IIF(SUM([history_]. Advanced topics. The source field is the field you're filtering with. The other option is to add a min and max date to your primary data source. Then drag Quarterend date to Rows, since we want financial data by date. In the rows pane, Add the Id fields from the Primary data source BEFORE the PayerName from the secondary source. You can set the default aggregation for any measure that isn’t a calculated field that itself contains an aggregation, such as AVG([Discount]). " manually every time. For the calculated field, I'm setting it to 1 or 0 based on the condition. The target field on any given worksheet is a field from another data source that is. Loading. Select Analysis > Create Calculated Field. Row level calculations are by definition within the same data source. Data blending is a method for combining data from multiple sources. The other option is to add a min and max date to your primary data source. When two data sets are blended together there is an increase in time to. Provide a name to the calculated field: Shipping Delay. Select Analysis > Create Calculated Field. {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. Tableau Public; Data Management; Advanced Management; Embedded Analytics. according to a representative at tableau, there is no solution to this problem at present, though they are looking to solve. Typically, the ATTR() aggregation can be used to get row-level values from the blended field. Open a new workbook and on the Connect page that opens click Excel. We need to do step "Under List of values, click Add from Field, and then select Coffee Chain Extract > State. e. But by default they're the fields from the primary datasource. Name the new calculated field to your preference. AccID - unique Acc ID. I believe this will resolve your issue. Thanks, June 2, 2016. In addition, some data sources have complexity limits. But my main concern was, what if I have to use the same date field in the calculated fields in both data sources. 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. With Tableau Data Blending, the key to blending with dates is: the time period you blend on. Mark just true values; Now you are good to go :-) Best, - Hil This is what I did to create v1 of the attached. In the formula text box, type the ZN function, the SUM. Hope this helps. In this video we blend several data sources and show you how to use the relationship dialog box to understand the automatic relationships, and how to use it. 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. Drag the State (group) dimension over. If the 2 datasources have the same columns, you shouldn't need to re-pull the data. - 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. In the calculation editor, we need to define the calculated field. In Tableau, data blending refers to the process of joining or linking data that resides in separate sources, such as databases, Excel files, or web services. I have a filter for Resource Manager-The totals were correct for the. The two data sources are blended on a string value they have in common called "DB Name". 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. a) If the data source is a data table, you can do a self-left join on Column 1 from Column 2. The actual data set I use is huge and a join is too slow. Tableau offers several blend methods, including Union, Join, and Data Blending. Replace the calculated field that references a field in secondary data source with calculated field created in step 2. 2. Select Analysis > Create Calculated Field. At that point the calculations only exist in that workbook and aren't available in the data source. 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. Select one, and you'll see the fields for that tadasource. Tableau Desktop; Resolution Use one of the following workarounds:. In the view toolbar, select Data Guide to open the Data Guide pane. When you apply a filter to multiple data sources, you create a source field and one or more target fields. END. From the Compute Using list, choose Advanced…. In the following example, the Market Share calculated field is not listed in the Field drop-down list. To overcome this, I used a workaround – I created a chart-specific calculated field with the following formula: COALESCE(Country (FB data),Country (LI data)) COALESCE() here picks the first non-null values from the two columns which works perfectly for me. Right now I need to update each calculated field to find variation from previous data file. Right-click the axis > Add Reference Line with the following settings. In general, data blending should incorporate secondary data sources which are at the same LOD or more coarse-grained than the primary data source. 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. to another account. When I searched "Door ID" in data source 1, I was able to find some of the values. Right-click the replacement calculation on the shelf, and select Edit Table Calculation. shin - while your solution solves the problem for the blended data, it introduces a problem for the pivot data (NAICS code, hoovers industry, and company name); i am now getting 'asterisks' in those tag clouds. Create a Calculated Field to Link Account. In this case, Tableau reads MAX (Block) as MAX (ROBO 1, ROBO 11) and chooses ROBO 11. I'm going insane searching for an answer online for this and have read all the guides I could find on the forum etc, but days later, still no luck! This is how the data is showingI am running into an issue where i am creating a calculated field that uses several fields from my primary data source and 2 fields from a blended data source. I want to filter on X or Y. Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. If this aggregation is ATTR() then the grand totals may be blank. doesn’t use table calcs or fields from another data source) and you’re on v8. A union in the tableau data source screen is 100% the best way to go. Due to the nature of a data blend, there are some things to keep in mind when working across blended data sources. In Tableau Desktop, connect to Superstore sample data. 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. Some examples. In the last two articles of this parameters Deep Dive, we’ve learned how to use parameters with filters and within calculated fields. The table shows sales by market, market size, and. The Example. Place the linking field in all worksheets that the action filter affects. Create a new field called “Total Google Reach ” . Ali. I'm in a catch 22. I need to find the difference in days between "Open Time" and "Go Live" for calculated column I want to use as a filter. (This will not work on calculated field's that have been created in Tableau). " It seems like conceptually, one would want to have calculated fields that are independent of any data source (because they are independent of data) and. This is computed row-by-row for each transaction—the results can be thought of as adding a new column in the data. Duplicate your tableau data source, by right clicking on it and selecting duplicate; Use the Data menu to define a custom relationship between both owner name in. " It seems like conceptually, one would want to have calculated fields that are independent of any data source (because they are independent of data) and. It's the data on sheet 2 that I'm having trouble with in dividing the middle column (% count of sales. Union combines the data vertically, concatenating the rows from multiple sources. When I am blending data in Tableau the data based on day is correct but not if I drill up to month. How to filter on primary data source only in blended data chart. 3) Tableau pads the data to fill in the missing dates. I hope that somebody can help. You can also set the aggregation for a field already in the view. ×Sorry to interrupt. I have a field called "group" in one of the sources for each product. Drag Measure Names to Columns. CSS ErrorSelect Analysis > Create Calculated Field; In the Calculated Field dialog box that opens, do the following, and then click OK: Name the calculated field. In a calculated field, try writing a measure that combines the data you want to sort. thanks, so even with extracts the calc fields are stored only in the workbooks. In the Data pane, switch to the [name of secondary data source] data source, and click at least one link icon to blend these data sources. From the Measures pane, drag Measure Values to Rows. 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. Your visualization updates to a text table. Data Blending - Calculated Field Hi, I have a workbook which contains a blended relationship between three data sources. create a calculated field off your event like this and use it in place of the parameter . From the Data pane, under Measures, drag Sales to Text on the Marks card. not just join table from 1 database. Open a new dashboard and place. From the “Apply to worksheets” menu, select “All using related data sources. Sales Order Placed? ZN comes from the sales order data source. This article will guide you through the process of concatenating. 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. The two separate table calculated fields could mean one of them being computed as table across, while the other is computed as table down. 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. Now, let’s go step by step and see how to use rank function in tableau. Select the arrow icon and click on the "create a calculated field" option, as shown below. IFNULL([Client], [Client (Pipeline)]) Date Combined // If the Date from the transaction data is null, use the Pipieline data. Data blending has been around for a long time – it was there before the Google Analytics connection. If you want to hide this column from your report, just remove the tick mark on "Show header". To create a new calculated field, from the primary data source (here: Sample Superstore), select Analysis > Create Calculated Field. Issue. There are calculated fields which calculate the global average. Tableau Public; Data Management; Advanced Management;. then right click on the parameter and show it. Environment. Also the SP list "DB Name" field has a 1 to many relationship with the incident records in the CSV. ThomasData blending is a very useful tool, but there are some effects on performance and functionality. You are now ready. ThanksThe ATTR function evaluates all the members within the field and returns a value if 1) there is only a single value (MIN = MAX) or 2) all members are identical (MIN = MAX) else it returns "*". Too slow; Filter across blended data sources filtering across data sources. Just change your calculated field like shown below. 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 toggled the calculated field to the filter pill. Some examples include: cookies used for remarketing, or interest-based advertising. SUM ( [Sales])-SUM ( [Sheet1 (target)]. The formula I'm trying to get to is: (2018 Actual for March)/(2016 Actual for March)+1] * PLAN (for June 2018) Calculation on a calculated field on blended data. Hello Folks,. Blending from a polygon-based map to an existing data source which uses 1-to-many joins. 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. Create an extract of the blended data source, and publish that extract to the server. Option 2: Create a calculation for a more dynamic sort. However, because I want to have a filter on the UI for the time period, the number of events in the primary data source is a calculated field. I selected "Specific Dimensions", then checked on all the dimensions, and finally selected to restart every month. I've tried using a combination of parameters and calculated fields to try and create a global filter such as explained on this VizWiz blog entry VizWiz: Create a global filter in Tableau across multiple data sources in eight simple steps - Data Visualization Done R…, however I was not successful on applying this method to a date filter. Tableau Calculated field (can't mix aggregate - non aggregate functions)Applies to: Tableau Cloud, Tableau Desktop, Tableau Server. Filter Out Null Values. This is called "DB1" for "Data Blending 1" by Tableau. 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. These are the basic steps to run Explain Data in Tableau Desktop, Tableau Cloud, and Tableau Server: Open a dashboard or sheet in a workbook. Work across blended data sources. ; Drag. "In the Secondary data source create a calculated field with definition as below-STR(ATTR([Primary. According to the year, quarter, month, week, and day, you need a new calculated field to display the sales. 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. Above that list is a pulldown of all your other datasources. For example, Bob Smith should have access to his own sales data per the calculated field username = local_identifier. Use a blend when: You want to combine measures or dimensions with the same meaning but different names in each table. Note: The primary data source is indicated with a blue check mark, any secondary data sources and fields from secondary data sources have an orange check mark. In this example, the calculated field is named "Ex 1: % of total sales per segment within region" Drag the green SUM(Sales). Using Sheet 4 of your Excel data set, in Tableau's data source tab, highlight your measure 1,2,4,5, & 6. I have blended the data on 'Account Number'. e, Advanced selecting Date & Item and select Date in the Restarting Every. Right-click the replacement calculation on the shelf, and select Edit Table Calculation. Calculated fields are always saved in the workbook and you can see them in the . 1 or later you can avoid the need for the custom calculation and use the two pass. The output of a calculated field can then be displayed for. Ben I have a scenario in which I need to blend the data. The new calculated field is added to Data pane as a measure because it returns a number. I selected "Specific Dimensions", then checked on all the dimensions, and finally selected to restart every month. Here in this workbook I am Calculating Percentages using Inner Join and Data Blending.