Data dimension not working on tableau

1

when i drag date on row/columns tableau it throws error saying error communicating with data source.

SELECT CAST({fn TRUNCATE(EXTRACT(YEAR FROM “HCI_Terminated_Employees”.“AS_OF_DATE”),0)} AS INTEGER) AS “yr_AS_OF_DATE_ok”
FROM “Demo”.“HCI_Terminated_Employees” “HCI_Terminated_Employees”
GROUP BY CAST({fn TRUNCATE(EXTRACT(YEAR FROM “HCI_Terminated_Employees”.“AS_OF_DATE”),0)} AS INTEGER)

2

Hi, could you uploaded a query profile?

3

dont worry about that i got that resolved its not problem with the product it was more how we defined the datatype.

1 Like