I would like to visualize number of distinct hardware. This didn't work alas, "cannot blend secondary data source because one or more fields use an unsupported aggregation" I am using a filter from a different datasource to filter by region . The date values you want to blend on must exist in both data sources. Twbx and also the . You will need a common column between the two tables in order to blend. i. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. ×Sorry to interrupt. 1. E make table 2 the primary and table. In the Add/Edit Field Mapping dialog box, select the date fields from the primary and secondary data sources, and then click OK twice. The secondary data source just pulls in some names to associate with ID numbers in the primary and some filters for the staff data. ×Sorry to interrupt. But when I am trying to do that I am getting an errorThe issue comes when I try and add a metric that is an aggregate of the two different sources. To alias field values. I am blending (2) data sources based on the date. Loading. the blend relationship is defined on driver Code, and working fine when adding both basicSalary (from main data source) and fuel (from secondary) to the sheet. However, it gives me following error: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation"We have an enterprise data source that is an SSAS Tabular model. For more information, see Troubleshoot Data Blending; Blended data sources cannot be published as a unit. Process for Creating the Dynamic “Parameter”. I am using tableau 2020. Currently, I have to rebuild the worksheet and bring in the secondary source first. Marked as. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. Cube (multidimensional) data sources have certain characteristics that make them unique in Tableau. Applies to: Tableau Cloud, Tableau Desktop, Tableau Server Data blending is a method for combining data from multiple sources. If multiple logical tables are related in a Tableau data source that source cannot be used as the secondary data source in a Tableau data blend, it can only be used as the primary Therefore one workaround is the Create Primary Group function that you described which "copies" the field from B into A as a group. I've read through the various posts on here, plus the general troubleshooting posts on the Tableau page on blending data, but can't find a solution. One small workaround which you can do is: 1) Create a calculation as {Max([Date])} 2) Create a parameter as follows: 3) Create a calculation as . I am trying to blend the same data against the other because I wanted to show Same Period last Year. Data blending; Table Calculations; Resolution Use one of the following workarounds: If possible, join instead of blend your data. Currently, data sources that contain logical tables cannot be used as secondary data sources for data blending. "Cannot blend aggregated data from the secondary data source with the data on this sheet because there are no linking fields use din the view" I'm using 2 separate data sources connected to Oracle and published to the Tableau server. Drag the State (group) dimension over the Region dimension on the Rows shelf to replace it. I'm trying to create a frequency distribution as a percent of total for individual products in a single category on one chart, then dual axis a second chart with the frequency distribution of the category for comparison purposes. Hi everyone, my first attempt to blend 2 data sets was not successful (Sheet called 1st attempt - attached), because its appears the following message "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". When I make the data source as Primary, I am able to see the respective values, Kindly see the below screenshot:- But, when I consider this data source as secondary and then try to use it in primary data source sheet, I get this error:- Cannot blend the secondary data source because one or more fields use an unsupported aggregation. * Supplemental data from a secondary data source is needed. Maxdate) There is one more way, make the datasource which is using the fixed calculation to primary data source. Another way to approach this is to do a join of the data outside Tableau via a federated data source. Another sheet:W2 is created with Data source A - taking Role in Row shelf. General Information. You can choose whether functional and advertising cookies apply. . Data blending is a method for combining data from multiple sources. e. The blend applies to that worksheet only. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. The blend applies to that worksheet only. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. Expand Post. Because the question is related to how the data sources are being related, it would help to see the real data structure. Hi All, I have blended primary and secondary data sources. I have a Remaining Value calculation, but it is not correct. Good morning @Fred Yu (Customer) . Hi All! I would like to ask for your help, I do have two data sources: BI Cube (primary source) & Excel file (secondary) BI Cube Data 1 pc. The two data sources are identical. If one of those measures is brought into a view with a linking dimension not in the view, or a linking dimension is turned on that is not in the view, the pill will turn red, the view will turn grey, and hovering over the pill reveals a "Cannot blend the secondary data source because one or more fields use an unsupported aggregation. You have a nice example to use for filing a support case, and I recommend that you do that. [Field_Name]":"Value_to_filter" in the Options will not work. Become a Better Analyst in Just 5 Minutes a Week. I have two data sources and doing a data blend. Cannot blend the secondary data source because one or more fields use an unsupported aggregation . For example, sheet A uses data source 1 as the primary data source; sheet B uses data source 1 as the secondary data source. 2 and later. In my primary, I define another calculated field to do the aggregation for each project by tier: VendorClass: if max [Secondary]. This field works but when I want to add in my Fianl Dashboard I have this message "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" Moreover my first and secondart data sources are linked by the "Sales ID", but this field is not displayed in the final Dashboard. 4. Fields cannot be used from the [name of secondary data source] data source, because there is no blend relationship to the primary data source. Cube data sources can be used only as a primary data source to blend data in Tableau, and cannot be used as secondary data sources. However when I use B as primary data source, drag [A]. While on a view, right click a data source, click replace data source. Secondary 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. It takes advantage of the data collected from previous research and uses it to carry out new research. Some of my table calculation are the follow: RED FIELD Tableau Name of First Math Course= IF [Tableau Period of First Math Course]== [Academic Period] AND ( [Subject Desc]=='Mathematics' OR [Subject. I am confused, as I am not even trying to blend Data from both Data Sources. Change the default sort order of the field using the various options, and then click OK. Change the default sort order of the field using the various options, and then click OK. I noticed that when the spatial file is the secondary data source, I cannot area plot it by double clicking the geometry variable. This happens regardless if I drag it on the rows or on the Marks space as a 'text'. 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. I am trying to use the measures name filter functionality with two data sources. Currently, it's not working, the filter I try to add in the dashboard appears red in my spreadsheet and tells me that : "Data sources containing logical tables cannot be used as a secondary data source for data blending". 2) Use data source filters instead of the Filters Shelf. Why are values from the secondary data source not appearing in a blended data source view? They did not exist in the primary data source. Secondary data sources cannot have logical tables (except when they satisfy specific conditions). ×Sorry to interrupt. - Dataset 1, records the amount spent on ads as "Cost". Data blending works only as a left join. 4. I am trying to determine the Average Revenue per User by country for which my calculation is total revenue/unique subscribers. When blending in Tableau, there is always a primary source and a secondary data source. Using Tableau; Upvote; Answer. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. 3. 1. Think of this layer as the Relationships canvas in the Data Source page. Non-additive aggregates are generally not usable when a secondary dimension appears on any Shelf or there’s a linking dimension that is not in the view. When blending in Tableau, there is always a primary source and a secondary data source. month([date])=month(Parameter. Seemingly simple task is getting complicated in Tableau . Blending takes place in the 6th step of the order of operation after the data table for the individual worksheet is set and the filters applied - data from the secondary source are aggregated at the level of the link and brought to the primary as. For example, COUNTD(). unsupported aggregation. " Is there a way to circumvent this issue? Or perhaps a different method entirely. LOD expressions are used when running complex queries with multiple dimensions at the data source level. So if you drag Category from the Orders data source, it will automatically mark Orders as the primary data source. 1) Duplicate the field in primary datasource. Instead, we need to publish the two data sources separately on the same server and then. Hello Jim, Thank You for your reply. Tableau v8 added a new style of data blending (DB2) where the linking field does not have to be in the view. Beginning with Tableau Desktop 2020. I have a calculated field in the Excel data source that returns a binary 1 if the username matches the list in Excel for the facility ID and a 0. Option 2: Join tables that are in the same data source, instead of blending them. How ever # no of changes and # of Problems are calculating entire database values. Then, after data blending, the final graph cannot show the data related to the South and East. Select Analysis > Create Calculated Field. Resolution. Thanks. Reference line -----> in this approach able to show sub-category items measures like sales and quantity totals as reference lines shown in below figure . Tableau will throw an error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 3) Select the now grey link next to the original field in. Remove all dimensions from the secondary data source and ensure that the primary data source’s linking field is in view. Hello Tableau world!! Am running into the strangest problem when data blending with V8. Here is the sample. Identify your data sources for common data types: both data sources must have a string or date field for linking data sources. Dominic Laird(Member) 5 years ago. Data coming from a secondary source is ALWAYS aggregated at the level of the link - even if there is 'no need to add anything' that's just the way blending works - it happens after the data table dimensions are set and you are loading values into the data table for the individual worksheet additionally, data coming from the secondary source are always aggregated at the level of the link when brought to the primary source - the individual records are no longer available and you are not able to filter across the various data sources at that point - that is the long way of saying you will have to join or use a relationship - not. * Blend in the summary of a large dataset to reduce query time. T or F: Blends, unlike relationships or joins, never truly combine the data. CSS ErrorAfter Blending, Now it is showing this error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Show moreA workbook or mock data would be a sure thing to comment and try upon it. Solution in the image 📌 Non-additive aggregates from the primary data source 📌 Non-additive aggregates from the secondary data source 📌 Non-additive aggregates from a multi-connection. Functional cookies enhance functions, performance, and services on the website. "cannot blend the secondary data source because one or more fields use an unsupported aggregation" Attached is the workbook that could provide more clarity on my question. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I've blended on user ID. In the past, I've just changed my primary table to the one with the calculation. In order to create the waffle chart I am blending it with another datasource using the calculated field defined as [Week 5 (Week5Bond)]. Please attach. Give the action a sensible name and configure the action. Some of the function doesn't work properly when we use blending like COUNTD(), LOD{} expression. I want to display all values for all different data sources, and use them as filters, and filter the relevant records from both datasources at the same time. the branch field I'm using from the primary data source. If you want to filter data across secondary data sources, consider the following alternatives: Join tables that are in the same data source, instead of blending them. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. E make table 2 the primary. Some examples include: cookies used to. id = B. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . Error: "data sources that contain logical tables cannot be used as secondary data sources for blending" I have two fact based data marts that I want to blend on a combination of dimensions (product, month, currency). Think of this layer as the Relationships canvas in the Data Source page. This functionality was available in versions 8. I am confused, as I am not even trying to blend Data from both Data Sources. Before I check Date filters, I got this results. Select Default Properties > Sort. The secondary data source consists of 1 Fact table (Agg_ActualVsExpected) and 4 Dim tables, one of the Dim tables is Dim_Service, whose primary key is Service_Id, which appears also in the Fact table. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. In blending data source, I try to slove problem but I can't. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. Upvote Upvoted Remove Upvote Reply. Hi everyone, my first attempt to blend 2 data sets was not successful (Sheet called 1st attempt - attached), because its appears the following message "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". [Cash PTM]) Else [Null] ENDIn your example, this doesn't work, because your primary data source needs to be Master Store List, because you want to list all the store IDs. 3 and I have created aggregates AGG for fields from data extract and excel file. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. If you make sheet 1 as the primary data source and do the data blending with sheet 2. This would be a great time saver, with all of the calculations and linking changing as well. In a blend, the secondary data source can only contribute aggregated values using the level of detail defined by the linking fields that appear in the view, so when you remove them, the. "Cannot blend the secondary data source because one or more fields use the / function, which cannot be computed locally. Next, create a table calc using the [Start KM] to calculate the total KMs: from Primary data source from Secondary data source. Which version of Desktop are you using? See attached the superstore workbook (. Your secondary data source does not have the blend activated, you'll need to click on the link and turn it red to activate:. The version I am working with 10. From Primary Data Source drag the measure names and measure values . e. I want to do a basic data listing showing customer, order no, postcode & vat exempt. From my primary data source I have a dimension in columns say 'Customer Segment'. 2) DB2 blending doesn't support non-additive aggregates like COUNTD() from secondary sources. If there is another. [amount] into the view, it gives less than. IF ATTR([Offer Status]) = "Hired" Then AVG([Comp_File]. We use three kinds of cookies on our websites: required, functional, and advertising. CSS ErrorHi Mavis Liu. Aside from consulting the primary origin or source, data can also be collected through a third party, a process common with secondary data. So yes, in [Actual Hrs] you can only use the value from the secondary as an aggregate, and that's why you see: SUM([Networkdays (Test blend data calculation)]. The problem is when I try to calculate the median of that same measure. Best solution. Data of any sort coming from a secondary source must come as an aggregate of some sort. In the Relationships dialog box, under Secondary data source select Custom, and then click Add. Data blending brings in additional information from a secondary data source and. 1 Connected to Tableau Server as Main DS and Live Connection to an excel file as secundary DSStep 2: Bring summary data from the secondary data source into the primary data source. Expand Post. 3. The secondary data source will have an orange checkmark on it. Loading. Hello Ritish, You could use Size() and a Las() function as a filter and get the same output. In the Data pane, select the State data source (secondary). It also means you cannot create a workbook using the. ×Sorry to interrupt. Cannot Blend Secondary Data Source - Unsupported Aggregation. I am trying using { FIXED : SUM[(portfolioValue)]}. Whichever data source is used first in the view, becomes the primary data source and the second one to be used in the view is the secondary data source. I have a primary data source coming from a published data extract blending with a secondary data source coming from an Oracle Database. Place Organisation Identifier on the level of detail shelf (from the primary source, or both sources) and the blend should work. Status, Stage, etc). In this source create a calculated field to pull out the KMs on the date of oil change. Hello Everyone, I am using one data source which is a LIVE connection and I have duplicated same data source , the reason behind duplication is i want to have total of category which will be constant and it will not. the branch field I'm using from the primary data source. Error: "data sources that contain logical tables cannot be used as secondary data sources for blending" I have two fact based data marts that I want to blend on a combination of dimensions (product, month, currency). Answer. I can get all the fields into the view apart from the 'is vat exempt'. I am using blending and created Relationship but i am having problem in terms of getting distinct count from one of the data sources. . CustomOverall (Primary) 2. It is important to understand which is the primary source, it can impact. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. FIXED requires that you have row-level access to the rows in the secondary source. You combine data in the logical layer using relationships (or noodles). According to Tableau, this error can also appear when using a LOD expression in a blended view. mdb which will be used to illustrate data blending. This is interesting. First data source looks like below. In versions prior to 2020. Loading. Loading. Instead, publish. The concept of data blending is, for every match in the primary table there should be exactly one row item in your secondary table, in the view of this concept any aggregation on the secondary table will always be distinct by default. . Data blending: Cube data sources can only be used as the primary data source for blending data in Tableau. Resolution. Secondary data source has Order Date represented as separate Year and Month fields. Blended data sources. I've tried using COUNTD() ID First Last 1 Jim Carrey 1 Jim Carrey 2 Liam Neeson 3 Wynona Ryder COUNT([ID]) = 4 COUNTD([ID]). We would like to show you a description here but the site won’t allow us. We use three kinds of cookies on our websites: required, functional, and advertising. Thank you . Step 2: Make it a context filter. This feature would be really useful to ensure we can. However, some days will have entries for "Cost" but not for "Proj. Data blending have some limitations regarding non-additive total such like COUNTD, MEDIAN, and RAWSQLAGG. When trying to use COUNTD() it gives this error: cannot blend secondary data source because one or more fields use an unsupported aggregation when hovering over the Measures because it is now red. In the Data window, switch to the [data name2] data source. with blends, we are only able to support aggregates (like SUM, MIN, MAX. In this case the cross database join will effectively act like the. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. You combine data in the logical layer using relationships (or noodles). Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 1. Instead, the. FIXED requires that you have row-level access to the rows in the secondary source. If you create a quick filter on a field from data source 1 and apply this. You can create a federated database using linked tables/worksheets. Use the geographic role in the primary data source on detail instead of the dimension from the secondary data source. Data blending is particularly useful when the blend relationship—the linking fields—need to vary on a sheet-by-sheet. All customer IDs are under a dimension called "Global ID". You can choose whether functional and advertising cookies apply. Non-additive aggregates are generally not usable when a secondary dimension appears on any Shelf or there’s a linking dimension that is not in the view. Build whatever calculated fields from the secondary that need to be used in in the primary. That's probably your problem. Error “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. {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. [% age]>=SUM([Percentage]) . Assuming that's what's going on, there's the question of how to work around this. ) So the issue is really the introduction of the group on the sheet. Also, after I get the total per PO Number, I want to get a remaining value that subtracts the Total Cost (from the secondary data source) from the Total per PO Number. the count of claims I'm getting from the secondary data source, by counting distinctly a measure called claimid. Fee". while data blending is a great feature for exploratory analytics and data validation and incredibly useful to have as an extra tool when nothing else will meet the requirements I find that there's a tradeoff with added. CSS ErrorIF user chooses month X and parameters/filters like gender/age/etc, THEN count all distinct users from data set #2 where the date of data set #2 is from 2017-08-01 through today's date. If that does not help,. Just aggregates (like SUM, MIN, MAX. We've adjusted our data strategy accordingly so using joins in all of our workbooks that need to leverage this functionality is not a sustainable solution. The condition is offer status = hired, but offer status can contain my different response types. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Resolution. When you blend, you can only have aggregate access to the rows in the secondary source. One of the Dimension which is part of the Relationship between Primary and Secondary Data Source is being used in Filter and the same field cannot be displayed in Report as it changes the Level of grain of the reportIm using two data source to develop the workbook. COUNTD - Blended data. 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. data source. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 3 and I have created aggregates AGG for fields from data extract and excel file. They must be in the same format. I have the total number of headcounts on one data set, and the number of attritions on the other so I am trying to write number of records (datasource1)/total headcounts (datasource2) and i get the red pill telling me "cannot blend the secondary datasource because one or more fields use an unsupported aggregation". Notice that Calc1 gives you an asterisk if there are multiple values returned from the secondary source. ODBC is a pretty universal technology for doing this, you can find more by doing a web search on "linked tables" or "linked worksheets" for your specific data sources. Trying to do a COUNTD() from a secondary data source and got this dreaded error: Cannot blend the secondary data source because one or more fields use an unsupported aggregation Did some research on this and found plenty of "workarounds" with no success, because apparently blending sucks and I shouldn't be using it. gov which displays certain regions in the US (a geometry field is auto created in tableau which allows me to create this map easily), the second data source is a data pull from a data warehouse holding lat/long coordinates of specific points (able to create a point via calculated tableau field using the make point function). You can create a federated database using linked tables/worksheets. This. 0, but I imagine someone has been able to identify what is causing the issue. " inner cross database join on BU Code with a data source filter set up on UPPER([ID])=UPPER(USERNAME()) on the DS2 source. A datetime field may be converted to a date field using a calculation to remove the time portion. Make sure that you are blending on dimensions present in the view or on. Common Issue #1: Cannot blend the secondary data source because one or more fields use an unsupported aggregation The aggregation methods of COUNTD,. So, basically, I am having issues with 2 calculations - the FIXED LOD and Remaining Value. Community Manager update. Data blending is a method for combining data from multiple sources. Consider joining the two data sources together using Tableau Prep, and then you can use that data as a. The reason your blend breaks is that you're blending with Location as a linking field, so when you remove that from your view, Tableau can't blend any longer. i will try to build some moke up data in excel and reproduce the same but before that could you please explain me in detail what calculation i need to perform in secondary source. Someone in the Community told me the following: "MAX isn't supported in. Data & Connectivity. It throws me cannot blend secondary data source one or more becuase one or more fields use unsupported aggregation . I've tried using COUNTD() ID First Last 1 Jim Carrey 1 Jim Carrey 2 Liam Neeson 3 Wynona Ryder COUNT([ID]) = 4 COUNTD([ID]) results in error I can add to filters from the data extracts. If attempting to use COUNTD in a secondary data source when blending, see the following additional workarounds: If Tableau Prep cannot be used, see: Getting. Here are the 7 major steps for putting this together: Set up your primary (main) and secondary (parameter) data sources. (It is a field that contains account names (company) in the sample data. - Go to Data > Edit Relationships to create the define primary and secondary data sources and the links - Drag and drop the linked field from the primary data source to use this field on the visualisation. duplicate the date field. Secondary Data Source: Extract W. A datetime field in the primary data source, for example, will not blend with a date field in the secondary data source. since i want only offername from secondary source to the view and the measures are produced from primary datasource is pos_trn. Option 2: Create a calculation for a more dynamic sort. You can also define the relationship manually by right-clicking on the data source name in the Data pane, and selecting Relationships. So make sure you're not using such function while blending. I have two data sources to be used but need the count distinct of users from both the data sources. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . To fix this, we had to add the fields being used in the blending relationship onto the view: If attempting to use COUNTD in a secondary data source when blending, see the following additional workarounds: If Tableau Prep cannot be used, see: Getting around Count Distinct in a secondary data source (third party website) Creating a primary group: Bring a Field into the Primary Data Source in Tableau Help Sorted by: 2. "cannot blend the secondary data source because one or more fields use an unsupported aggregation" Attached is the workbook that could provide more clarity on my question. I have just realised why the blending was not working. The default view that you first see in the Data Source page canvas is the logical layer of the data source. This can restrict many values from the secondary data source. Make the data source that contains the field that you want to use in the URL action the primary data source in. The relationship is on the facility ID. No long-term contract. Also, data blending is useful for combining data from published. I'm using a data blending method, where: Primary data source: Contains the ID I'm trying to count. I tried to recreate the data as close as possible. Also, in the attached I have added both Calc1 and Calc2 to the tooltip in Sheet 9. You cannot filter data across secondary data sources. Aggregate the date fields at the MY. I didn't realize this until now, but it appears you cannot use blending when one of your data sources uses the new(ish) relationship model. Russell Christopher (Member) 10 years ago. I'm blending student data (primary) and staff data (second). Blending requires primary and secondary data sources. Loading. As it is right now (version 8) if you add filters from a secondary data source, you can not cascade the filters based on what the user selects from one filter to the other - this is only. Hi Justin, Thanks for your quick reply. I can add to filters from the data extracts. Does anyone have any Ideas how I can apply a universal filter. LoadingWhen you try to add URL actions to dashboards, fields from secondary data sources cannot be added to the URL. LOD (exclude) - Filtering using a different data source I've used LOD (exclude) to create a % of total calc field (and then created a moving average off that). Here's the data blend view with the secondary data source selected so we can see what blend fields are used:. If we are working with one data source that is not relatable or joinable (such as Google Analytics) you are not able to blend a secondary data source with logical tables to it. the blend relationship is defined on driver Code, and working fine when adding both basicSalary (from main data source) and fuel (from secondary) to the sheet. In this example, Superstore Sales is the primary data source and Coffee Chain is the secondary data source. Yes - you can't bring COUNTD in data blending. But I cant add filter Month from the Budget Excel file. However, if you do a full outer join on [Dimension] = [Dimension] then we can know which records match up, and do a calculation like:I like to have the ability to swap a primary data source with a secondary data source for data blending in a workbook. Better collaboration. It sounds like there might be some complications with a blend? Can’t speak to what’s happening there Are you blending on [Endtimestamp]? By using the formula DAY([Endtimestamp]), you're changing the dimensionality a little bit.