The . Right click the vDS, then Settings > Export configuration to back up the existing configuration of the vDS. Use a Join instead of Blending: If blending is not necessary for your analysis, you can try joining the data sources instead. Assuming Sales is configured to use Count aggregation: Query. Ditto: { FIXED [Patient ID] : COUNTD([Patient ID]) } Yet there it is in your workbook, very happy and functional. AnalysisException: select list expression not produced by aggregation output (missing from GROUP BY clause?) 4. Atlas Build on a developer data platform Database Deploy a multi-cloud database Search Deliver engaging search experiences Vector Search (Preview) Design intelligent apps with GenAI Stream Processing (Preview) Unify data in motion and data at restunsupported aggregation from blended data problem. 5. This page was last edited on 14 March 2019, at 05:24. Expand Post. Norbert, I'm baffled. For example, Sales becomes SUM (Sales). General Information. I want Active Resistance (the first Textual Answer) to appear to the left of the Passive Resistance column, even. elastic-stack-machine-learning. When you add a measure to the view, Tableau automatically aggregates its values. In other words: Column-references must either be part of the grouping keys, or they must be part of the aggregation. One of the ways I have fixed issues like this in the past is to add the filter I need as a data source filter on the secondary data source, rather than as a quick filter. We are blending two data sources. Aggregations are created by. api. To make data processing easier and faster in your application, you might push manipulations such as joining two strings together, down to the database level. You can use aggregations in the analysis level calculated field. Sub-path [interactions-c] points to non single-bucket aggregation" } } ] }, "status" : 500 } this is my index mapping:I created a calculated field that checks to see if Subsidized Price is not null, and added that to the filters shelf, but doing so turns my median calculation into an unsupported aggregation. For example, the calculation: IF [Row ID] = 1 THEN SUM( [Sales] ) END could become: SUM(IF [Row ID] = 1 THEN [Sales] END ) Option 4 (Use Level of Detail to De-aggregate a Field) Use a Level of Detail (LOD) Expression to make an aggregation non-aggregate. Reload to refresh your session. Sep 26, 2014 at 15:16. Calculates the number of distinct values of a field within a partition. Upgrade: open it with the 2020. e. Step 2: Setting the Default Aggregation for a Measure in Tableau. CSS ErrorIn aggregation, following a stage that outputs a field with the text score value, you can specify a query condition or operate on the field in subsequent stages. Unsupported Aggregation means that the action requested at one of the sources or the act of bringing them together can not be done - in your case you have used a table calculation to determine a performance score - Table calculations are performed on the underlying table for a specific worksheet and can not be carried or transferred from one sheet to another Add a comment. really need to see your twbx file to be of further help. ×Sorry to interrupt. 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. Supported Aggregation Pipeline Operators Atlas Data Federation supports all the aggregation pipeline operators. I get "unsupported aggregation type [multi_terms]" @Val – Orkun. benwtrent Jul 29, 2019. Drill down to the leaf level to enter data. Blending with CountD and LODs. The requests in the InfoProvider have not been activated yet. An aggregation pipeline is a series of stages that are used to transform a document. It is now possible in Amazon QuickSight. 0CALDAY (YYYY-MM-DD) 0CALMONTHThis guide will help you check for common problems that cause the log ” Unsupported aggregation type [{}] ” to appear. Hi @Ajay Velupula (Member) , I think Mahfooj's suggestion makes sense, if you have a common field between the two, in theory it sounds like a join should work and would give a better result than blending. Mean of gradesWe have an enterprise data source that is an SSAS Tabular model. NET/C# Driver automatically translates LINQ queries into aggregation operations. 3 and I have created aggregates AGG for fields from data extract and excel file. This is because Calculation1 is an aggregate but the rest of the fields you're using are not aggregates. Specifies that the aggregation type is unknown. Supported Aggregation Stages. Applications using explicit encryption may use this page as guidance for issuing read and write operations against encrypted fields. getType() + "]"); Copy link Member Author. Maven coordinatesOne solution is to count unique users on client side using the composite aggregation. Measures of type: number or type: yesno act as placeholders so other measures or combinations of measures can be referenced within them. Connect and share knowledge within a single location that is structured and easy to search. I want to split this into 3 rows, which should show as following: [Custom Product] [Product 1] [Product 3] In POWER BI, this is easily accomplished by splitting to rows. This aggregation is unsupported: Year . Hi. 2 Vivado Implementation - Logic Opt not auto-inserting BUFGs on unbuffered cmt CLKOUTx outputs. Good morning - see the attached. Data blending is a way to combine data in Tableau. 0 and later. I have an LOD expression that works fine when the data source is the primary, but when I switch it to a secondary data source and then add the LOD expression to a view I get the annoying, "Unsupported aggregation" issue. " For more information on this aggregation method, please see the following link for further support. You'll need to. Sorted by: 2. 55135 - Vivado Synthesis - Unsupported SystemVerilog Constructs. You can. Databricks matches expressions on best effort : For example it will recognize: SELECT c1 + 5 FROM T GROUP BY 5 + c1 as mathing expressions. Unsupported Aggregation means that the action requested at one of the sources or the act of bringing them together can not be done - in your case you have used a table calculation to determine a performance score - Table calculations are performed on the underlying table for a specific worksheet and can not be carried or transferred from one. For example, here are the. I am trying to use the below formula instead of countd function because my data comes from Impala. 0. Filter each of the data sources independently on the more granular dimensions. automatic. When I try to add COUNTD([DistrictId]) from my primary to text table. 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. For more information, see Compatibility Changes in MongoDB 7. Move the aggregation so the calculation is aggregated. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". 0. The data source with the KMs is the primary source. I thought the problems with Median and CountD being unsupported by DB2 blending were over as of version 9 (i am using. unknown. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. 0 and later. For more information on aggregation types, refer to Disaggregation of Values During Data Entry. Rather than return incorrect results, Tableau turns the pill red, greys out the view, and generates the unsupported aggregation message. Suppose you want to create a pipeline that performs the following operations: Matches all documents with "spring" in the Season fieldNo matter how hard I try I cannot get the Order Count to display correctly. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. It’s common to store strings in documents such as first name, last name, or location. is there any way to rewrite below function and get the same result?JVM since 2. hi Jay, So this should do the trick. Depending on the type of data item, applies. movieIdResolution. dataCategory: #CUBE. I would like to visualize number of distinct hardware. The examples in this guide use the restaurants collection in the sample_restaurants database provided in the Atlas sample datasets . udaf (MyTypedUDAF) ) and call it for aggregate over your window. I’ve found a couple examples in the forums. Chicken + Choice of DrinkBurger + Choice of DrinkSpaghetti + Choice of Drink . The number is a factor by which the grade value will be multiplied before it is added to the sum of all grades, but the item itself will not be. java. Etcd v3 component, URI syntax: etcd3:path. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. See Join Your Data for more information. Keep asking questions as you progress on your journey with MongoDB, and soon you’ll be helping those who are new on the path. Many Tableau developers find data blending frustrating. This is a bug and support for IntervalValueCount should be added. An aggregate_metric_double field is an object containing one or more of the following metric sub-fields: min, max, sum, and value_count. For example, see Text Search in the Aggregation Pipeline. NET, we hope to speed up your development cycle and increase your productivity in three ways: 1) by making it easier for you to see how your idiomatic queries map to the MongoDB Query API, 2) by helping you spot unsupported expressions and invalid queries faster (at compile time, baby), and 3). Returns true if the second parameter string value is a substring of the first parameter string value, otherwise it returns false. calculated. For example, consider the following document:When I use a terms aggregation, it works fine and returns buckets as expected. Supported MongoDB APIs, Operations, and Data Types. 58K. Loading. If the user select May 2018. aggregations. 0 or later using Automatic Encryption with Queryable Encryption parse read and write operations for operators or expressions that do not support BinData values or that have abnormal behavior when issued against BinData values. There are a few DataFrame/Dataset operations that are not. @Filip: No, the question was "generalize this" and not "generalize operations like this". Get 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. g. date, t. contains. If a function, must either work when passed a DataFrame or when passed to DataFrame. What the message is basically saying is that you can’t reference a value in one row and also have aggregations. Blend ID (transaction datasource) =. For more information on exception aggregations, refer to Disaggregation of Values During Data Entry. data,c. Tommy Sims (Member) 7 years ago. movieId GROUP BY a. Correlated subquery patterns that are not supported. Hello I am having a problem with the relationship between two data sources. Atlas Data Federation supports all the aggregation pipeline stages except the following: For the following stages in Atlas Data Federation queries, Atlas Data Federation introduces an alternate syntax, includes a caveat, or deviates from server. A value greater than 0 treats a grade item's grades as extra credit during aggregation. Drivers configured for automatic Client-Side Field Level Encryption pass these commands directly to the mongod: getMore [ 1] authenticate. In the primary data source I have some calculations that work off of group membership too--some true false that feed into the measures via INT function for a Max aggregation. Multiple instances of same dimension. LINQ allows you to construct queries against strongly typed collections of objects by using language keywords and operators. Answer. Try to use this calculation:. Teams. The Queryable Encryption Public Preview, released in version 6. Unsupported aggregations in data blending Hello, I have a distributor dataset with product ships and returns (one report covering six months), and a retailer dataset with product retail sales and stock (covering the same six months but composed of. ” Causes and Workarounds for a Blending Limitation Errors 1. Aggregate using one or more operations over the specified axis. I used a parameter. Upgrading ESXi to 7. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies. Drivers configured for automatic Client-Side Field Level Encryption pass these commands directly to the mongod: getMore [ 1] authenticate. Wrong aggregation type for query. 0, is no longer supported. NET/C# Driver automatically translates LINQ queries into aggregation operations. @Point Partner BI Team (Member) hi there,. It does not make sense to have different exception aggregation types for the same account in different models. Don Wise (Member) 3 years ago. So the only way, it was possible was to connect one of the data sources with a calendar table joined with previous year and then blend it against the same data to get the Current Year and Same Period Last Year. NoDays >> * <<root. Using Tableau; Upvote; Answer. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. For example, a min aggregation on an aggregate_metric_double field returns. For more information, see Compatibility Changes in MongoDB 7. Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). Hot Network QuestionsOfficial drivers compatible with Queryable Encryption parse read and write operations for operators or expressions that do not support BinData values or that have abnormal behavior when issued against BinData values. Level of Detail Expression is Finer Than View Level of Detail. you are applying string values . So the reason why the build-in function won't work is that's it takes an iterable as an argument where as here the name of the column passed is a string and the built-in function can't be applied on a string. Average is not supported as Default Aggregation in CDS when claiming @Analytics. Wherever possible, the value of calculated is used, then sum. Learn more about TeamsSupported and Unsupported Aggregation Pipeline Stages. Upvote Upvoted. Hi, Thanks for your reply. You can't use a measure when it's configured to use an unsupported aggregation type. M. Add the ’ [‘ open-square-brackets to the beginning and ‘]’ close-square-brackets to the end. I've tried that in the past, and I was always blocked by the unsupported aggregation message. Cut out the three explanatory lines at the top (can be done with regex) Run a regex replace on the file (I’ve used . Drill down to the leaf level to enter data. average. This aggregation is unsupported: Month . Elasticsearch Version 8. I tried suggestions from this link, but no luck. The examples in this guide use the restaurants collection in the sample_restaurants database provided in the Atlas sample datasets . Chapter Title. 0 and later. id = totals1. Possible Reason How to resolve this issue; There's a dimension combination rule that defines this data cell as an invalid member combination for data entry. aggregate(func=None, *args, engine=None, engine_kwargs=None, **kwargs) [source] #. The manual process is: Read the data into a text editor. Use a Data Extract: Creating a data extract can sometimes help resolve unsupported aggregation errors by creating a static, aggregated view of the data that is more compatible for blending. You signed in with another tab or window. The following aggregation operation on the orders collection converts the order_date to date before sorting by the date value: // Define stage to add convertedDate field with the converted order_date valueLocal variable usage in aggregations - A local variable cannot be used in an aggregation function if the variable is declared outside of the aggregation function. Official drivers compatible with MongoDB version 6. Nothing found. As for transform: date_histogram is supported as part of group_by, I wonder why you try to use it in the aggregation part. © 2003-2023 Tableau Software, LLC, a Salesforce Company. From my understanding of the ATTR function is that it's for aggregation purposes. What I have understood. With the release of the MongoDB Analyzer for . You are getting the message because the data source can't support the the way you created the groups - it happens with some specific live data source when you try to do calculations that cross records (like counts(), Median() for example)You are not using the correct sum function but the built-in function sum (by default). Hi All, I would appreciate a little help as I am fairly new to Tableau In short, I am trying to sum the distinct count from two separate data sources however while doing so i receive. 0, and 5. The Queryable Encryption Public Preview, released in version 6. Ditto: { FIXED [Patient ID] : COUNTD([Patient ID]) } Yet there it is in your workbook, very happy and functional. Supported Aggregation Expressions. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. All I need from the grouping is sorting and organizing the output. When I run the above code, I receive the following error: Validation Failed: 1: Unsupported aggregation type [nested]. Hi everyone, I'm trying to blend two data sources on a single field, say 'Program Description'. The aggregation type (summation, minimum & maximum) specifies how key figures are updated if the primary keys are the same. 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. Just aggregates (like SUM, MIN, MAX. Hi Chris. Good day Kapil. There's a set of views/calcs that show a metric, (metric C) counting distinct number of accounts contacted per person per week (e. Buckets can only be sorted on a sub-aggregator path that is built out of zero or more single-bucket aggregations within the path and a final single-bucket or a metrics aggregation at the path end. unsupported. In first calculation , aggregation should be applied on Measure(Numeric) Value . What I'd really like to do though is define. However I only managed to make it work for abap cds queries (@Analytics. Aggregation is not supported for this object. Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly-available, and fully managed document database service that supports MongoDB workloads. Specifies that the aggregation type is unknown. 5 and have 2 data sources RPT and AD in the workbook which are currently extracts. Sum, average, and median are common aggregations; for a complete list, see List of Predefined Aggregations in Tableau. unsupported. It supports pre-built data integrations from 100+ data sources. Also, what's the intention of the formula? Doing a COUNTD on DAY() will count the different calendar days that it happened, ignoring the month. the SELECT statement has aggregates WHERE gpa in (SELECT max(gpa). FIXED ID, WEEK: CountD (accounts)). In the Value field, enter the amount of time (in minutes) you want the old password to still be active after a password reset. Local variables declared inside curly braces are allowed. Alternate names:. This aggregation is unsupported: Year . Local variable usage in aggregations - A local variable cannot be used in an aggregation function, if the variable is declared outside of the aggregation function. When you run certain metric aggregations on an aggregate_metric_double field, the aggregation uses the related sub-field’s values. 1. Move the aggregation so the calculation is aggregated. The Queryable Encryption Public Preview, released in version 6. 9 version and publish them as new (remove previous one). In find, you cannot specify a query condition on the text score. Did some research on this and found plenty of "workarounds" with no success (like replacing COUNTD() with a LoD using AVG(# of Records)) Here's simplified abstraction of. If I cant go the above way then is there a possibility to do the duration calculation using table calculations or some other way. Blending provides a quick and simple way to bring information from multiple data sources into a view. Ken Flerlage (Member) 5 years ago. CSS ErrorNon-aggregate measures do not perform any aggregation and thus will not perform a double or nested aggregation. A COUNTD of Order ID should be all I need to show this data but it always results in a "Cannot blend the secondary data source because one or more of the fields use an unsupported aggregation" What can I do to get around this?Aggregate metric field type. Hot Network Questions Resolution. functions as psf. The aggregation rule is determined automatically at run time. It said one or more fields use an unsupported aggregation. Canonical function. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I'm building aggregations like: AggregationBuilders. Approach #3 : An Undocumented / Unsupported Aggregation. PaulWindowed Aggregations. (Ditto the FIXED countD. Thank you,unit is corresponding to a geometric relationship to the red target node. See the Description column for details. The driver does not provide methods for all aggregation pipeline operators in the Query API. When you add a measure to the view, Tableau automatically aggregates its values. I am getting Cannot blend secondary data source because one or more fields used an unsupported aggregation. 2. Exception aggregation behavior. That's probably your problem. The version I am working with 10. My assumption and at least in my test it seems so, is that TOTAL applies the aggregation to all underlying entries in the partition whereas WINDOW_FX uses the function on the already aggregated values. Like below,. The workaround for this is that if you have to use one of the non-additive. Choose a reason for hiding this comment. Local Cumulative Computation makes the Process more Efficient. NET, we hope to speed up your development cycle and increase your productivity in three ways: 1) by making it easier for you to see how your idiomatic queries map to the MongoDB Query API, 2) by helping you spot unsupported expressions and invalid queries faster (at compile time, baby), and 3) by. udf. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Unsupported aggregation: The following aggregations cannot be inverted: <aggregations> Unsupported exception aggregation: The following exception aggregations cannot be inverted: <exception aggregations> Some exception aggregation types do not support data entry. Table arguments are used in a function where. For this reason, I applied a work-around, in which I add an aggration around the nested-field aggregation, as shown in the code below:HI Prakhar, It may happen because of actually n/w went down or deadlock in query execution or connection time exhausted . value_count on one of the group by fields. That will avoid duplicated records resulting from the join. I did that in your example too. Supported Update Operators. Drill down to the leaf level to enter data. I am trying to show an empty column on the X axis even when the aggregation value (the row) is 0. I'm sorry, I can't answer queries using measures with an unsupported aggregation type. ) I need to revisit my understanding of the limitations here!data from the second source comes over as an aggregate - look into what the aggregation is on and how does that relate to what you have in the primary data base . Supported Update Operators. I have two datasets; one is a shape file that contains regions and locations. If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. . 51327 - Design Assistant for Vivado Synthesis - SystemVerilog Data Types Support. column1. Possible Reason How to resolve this issue; There's a dimension combination rule that defines this data cell as an invalid member combination for data entry. LOD expressions are used when running complex queries with multiple dimensions at the data source level. A COUNTD calculation gives the answer as 5 since the sales for account B came through two separate units. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 3. Unsupported aggregations in data blending Hello, I have a distributor dataset with product ships and returns (one report covering six months), and a retailer dataset with product retail sales and stock (covering the same six months but composed of a number of weekly reports). From my primary data source I have a dimension in columns say 'Customer Segment'. 1 is the employee side of things that tracks their current leader, country, career level etc, and the other side which is transactional which tracks whether they have terminated or not. Supported Aggregation Stages. Applications using explicit Queryable Encryption may use this page. We should add test cases for the scripted fields we currently support to make sure we maintain support. Summary:. So in my case where CKF1 = RKF1 - RKF2, I will need to store this result in the database as a key figure. and no matter how I try to structure it - even doing all the calculations out in one field - I get a perfectly valid object that cannot be dragged into a sheet that has ANYthing else in it, citing 'Unsupported Aggregation' and turning red. This is probably the approach I've used the most in my career – it's essentially a cursor disguised as a set-based operation. The . 0. Note: The backup only stores the vDS configuration from the vCenter Server perspective. All Rights ReservedAn old, now unsupported, aggregation strategy is provided here only for backward compatibility with old activities. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. CallTime Avg (internal)>> because CallTime Avg (internal) is interpreted as being. The following commands do not require automatic encryption. coming from secondary data source; There might be non-additive aggregates from a multi-connection data source with a live connection. Cannot blend the secondary data source because one or more fields use an unsupported aggregation We are blending two data sources. Over Aggregation # Batch Streaming OVER aggregates compute an aggregated value for every input row over a range of ordered rows. Hi there. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . In your config in the screenshot you specify date_histogram twice, however the definition is group_by is all you need. category. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Support for Redis Geo commands. I don't understand why the grouping isn't allowed. throw new RuntimeException("Unsupported aggregation type [" + agg. Cannot blend the secondary data source because one or more fields use an unsupported aggregation Hi. This is the calculation in the secondary data source for January's Application Volume: DATENAME ('month', [Date Application])='January' then [Applicant ID] end )} The calculation works fine, however,. This aggregation provides a way to stream all buckets of a specific aggregation, similar to what scroll does for documents. But a filter or range gives org. For more information on aggregation types, refer to Disaggregation of Values During Data Entry. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. In your calculation you are flattening your date field so the value can not be attributed to further aggregation. 0 Native unsupported. This is a table calculation equivalent of the COUNTD() database function, which may be required either because the result needs to be used in a calculation at a different level of detail to the level at which it is calculated, or because the datasouce. NET/C# Driver automatically translates LINQ queries into aggregation operations. bucket. Q&A for work. Let us know if this helps -- COUNTD is the most likely culprit: Error "Cannot blend secondary data source. The way in which the individual activity scores are summed or averaged to give the overall score is called the aggregation. The composite buckets are built from the combinations of the values extracted/created for each document and each combination is considered as a composite bucket. Usually in this case it is recommended to upgrade the document to a newer version. If there is another aggregation type such as AGG_AVG being used, change it to one of the supported. This is because any calculation will happen before aggregation in case of a formula or a calculated key figure and it will therefore not be pushed down. If you need to use an unsupported operation in an aggregation, you must define the entire expression using the BSON Document type. Aggregate functions in S3 Select. pos_trn) (default) . Stores pre-aggregated numeric values for metric aggregations. unsupported alert type – all alert type names are in camelCase – check spelling and capitalization for all alert parameters; unsupported aggregation parameters – see the You can have other aggregation on a parallel level of top_hit but you cannot have any sub_aggregation below top_hit. This aggregation is unsupported: Week Number . Hello Jim, Thank You for your reply. I couldn’t get anything to work. Ditto: { FIXED [Patient ID] : COUNTD([Patient ID]) } Yet there it is in your workbook, very happy and functional. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN and RAWSQLAGG. Pipeline aggregations that take input from other aggregations instead of. column1 and -------^ a_s. The version I am working with 10. This section describes the summary, or aggregation, functions that are available in IBM® Cognos® Analytics - Reporting. Unfortunately can't share the data, and can't come up with a mock cause I can't figure out what's not/is working as expected. movies` a INNER JOIN `<snip>. The aggregation for the gradebook (and each subcategory, if applicable) can be one of the following options. Drivers configured for automatic Client-Side Field Level Encryption pass these commands directly to the mongod: getMore [ 1] authenticate. Unsupported exception aggregation: The following exception aggregations cannot be inverted: <exception aggregations> Some exception aggregation types do not support data entry. I’m trying to find the date when customer leave by labeling who doesn’t have transaction the next day. 2 Why does this MongoDB aggregate query return nothing? 0 Problem in using indexes in aggregation pipeline. Exception aggregation on a formula member: No data entry possible because an exception aggregation has been set on a formula member. Characteristics such as optical and catalytic activity may be lost if the dispersion of unsupported Ni NPs is not adequately modulated. Returns the numerical value of the string as an integer. At first, I made a lookup operator to link between the two collections, then I wanted to group the. I use mongodb 4. There are non-additive aggregates from a multi-connection data source with an active connection. 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 Desc]=='Mathematics. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. CompanyID =. 💥Check my Website💥 Troubleshoot Data Blending in Tableau Part 2 here SHOP values are being replicated, changing the aggregation for the relevant field in the view (for example, from AVG to SUM) will not change the result of the aggregation. I thought about using a parameter but you cant search with a parameter in a prompt, on the other charts that are like this there are hundreds on items. So the only way, it was possible was to connect one of the data sources with a calendar table joined with previous year and then blend it against the same data to get the Current Year and Same Period Last Year. The examples in this guide use the restaurants collection in the sample_restaurants database provided in the Atlas sample datasets . e when we put Sales in view it appears as SUM (Sales) or MAX (Sales).