search

tableau / connector-plugin-sdk

SDK for Developing Tableau Connector Plugins
https://tableau.github.io/connector-plugin-sdk/
MIT License
105 stars 107 forks source link

Unable to fetch continuous year and month by using dialect file. #1199

Closed akash-singh478 closed 7 months ago

akash-singh478 commented 8 months ago

Name: Akash Singh

I am unable to get continuous year, month, day, week number on the tableau worksheet having issue while using the formulae -

CAST(TRUNCATE(%1(%2),1) AS INTEGER) (1 + CAST(DAYOFWEEK(%2) AS INTEGER)) CAST(FLOOR((7 + (DAYOFYEAR(%2)) - 1 + (DAYOFWEEK(%2))) / 7) AS INTEGER) TO_DATE(TO_CHAR(%2, 'IYYY-') || (LEAST(CAST((EXTRACT(WEEK FROM %2) - 1) AS BIGINT) / 13, 3) * 13 + 1), 'IYYY-IW') CAST(TRUNC(EXTRACT(WEEK FROM %2)) AS INTEGER) CAST(TRUNC(EXTRACT(ISODOW FROM %2)) AS INTEGER) CAST(TRUNCATE(YEAR(%2)) AS INTEGER)

 

Could you please help!

lukewrites commented 8 months ago

Internal tracking: W-14480389

tabsdavis commented 7 months ago

@akash-singh478 Not sure what we are looking at here and need more context. Is this part of a certain function definition in a particular connector plugin’s dialect? I don't see correct syntax for an initial sql excerpt or calculated field. Can you provide the scenario you were using this formulae with?

tabsdavis commented 7 months ago

Closing issue. Can be re-opened with more information.