An error occurred while communicating with the PostgreSQL data source 'New_View (Sales_BSCH.New_View) (default)'
Bad Connection: Tableau could not connect to the data source.
Error Code: 88889F6A
ERROR: Unsupported feature:[" New_ View"" AMOUNT_ SOLD"," New_ View"" COST_ OF_ GOODS"] must appear in GROUP BY[ Unsupported Operation Exception: Unsupported feature:[" New_ View"" AMOUNT_ SOLD"," New_ View"" COST_ OF_ GOODS"] must appear in GROUP BY].
Unsupported feature:[" New_ View"" AMOUNT_ SOLD"," New_ View"" COST_ OF_ GOODS"] must appear in GROUP BY
Detail: java.sql.SQLException: Unsupported feature: ["New_View"."AMOUNT_SOLD", "New_View"."COST_OF_GOODS"] must appear in GROUP BY [java.lang.UnsupportedOperationException: Unsupported feature: ["New_View"."AMOUNT_SOLD", "New_View"."COST_OF_GOODS"] must appear in GROUP BY]
at com.incorta.sqlinterface.exception.ErrorCode.toSQLException(ErrorCode.java:63)
at com.incorta.sqlinterface.exception.BridgeException.get(BridgeException.java:58)
at com.incorta.sqlinterface.exception.BridgeException.convert(BridgeException.java:135)
at com.incorta.sqlinterface.exception.BridgeException.toSQLException(BridgeException.java:108)
at com.incorta.sqlinterface.net.tra
SELECT SUM("New_View"."AMOUNT_SOLD") AS "sum:AMOUNT_SOLD:ok",
SUM("New_View"."COST_OF_GOODS") AS "sum:COST_OF_GOODS:ok",
CORR("New_View"."AMOUNT_SOLD", "New_View"."COST_OF_GOODS") AS "usr:Calculation_140456073647910928:ok",
COVAR_SAMP("New_View"."COST_OF_GOODS", "New_View"."AMOUNT_SOLD") AS "usr:Calculation_140456073654411282:ok",
COVAR_POP("New_View"."AMOUNT_SOLD", "New_View"."COST_OF_GOODS") AS "usr:Calculation_140456073655603219:ok",
CAST(TRUNC(EXTRACT(YEAR FROM "New_View"."TIME_ID")) AS INTEGER) AS "yr:TIME_ID:ok"
FROM "Sales_BSCH"."New_View" "New_View"
GROUP BY 6