2 Replies Latest reply on Dec 5, 2016 1:45 PM by Chris McClellan

    Blending data - Unsupported aggregation MIN MAX

    Sebastian Cruz

      Hi everyone,

      I have some problems when I try to blend my secondary with my main data. It shows the next message: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation".

      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 Developmental') THEN [Course Number] END
      • Tableau Period of First Math Course = {fixed [Student Warehouse Entity Uid] : MIN(IF ([Subject Desc]=='Mathematics' OR [Subject Desc]=='Mathematics Developmental') THEN [Academic Period] END)}
      • RED FIELD Tableau Grade=IF [Tableau Period of Last Math Course]==[Academic Period] AND ([Subject Desc]=='Mathematics' OR [Subject Desc]=='Mathematics Developmental')  THEN [Final Grade] END

       

      The relationships is the follow:

       

       

       

      I will appreciate your support regarding this problem. I need to drag some fields from my SQL query.

      Thanks in advance,

       

      Sebastian