Convert tableau DATE_TRUNC to SQL query

Question

Hi Team,
Have one calculated filed in tableau like bellow i want to convert to sql query please help on

CEILING(COUNTD([RefId])/COUNTD(DATETRUNC('week',[OrderTime],'monday')))

Answer 1

Hi @balanarasimhac-1459 ,

Tableau Desktop does not support the Microsoft SQL Server TIME data type. Fields of this data type are not imported and do not appear in Tableau Desktop. If included in stored procedures, TIME data type fields will not appear in Tableau Desktop. For more information, see Use a Stored Procedure.

However I am not familiar with Tableau, you can keep this case open, and maybe others can help you.

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi @Bala Narasimha Challa ,

Is the reply helpful?

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.