function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Charles TeeCharles Tee 

[Tableau CRM] Dataset XMD Date fields : Unrecognized field "fiscalWeek"

I encountered error while setting my dataset JSON XMD with date fields for fiscal year.
Below is JSON XMD i add in:
"dates":[
    {
        "alias" : "accounting_date",
        "label" : "Accounting date", 
        "firstDayOfWeek" : 0,
        "fiscalMonthOffset": 3,
        "fields" : {
          "day" : "accounting_date_Day",
          "epochDay" : "accounting_date_day_epoch",
          "epochSecond" : "accounting_date_sec_epoch",
          "fullField" : "accounting_date",
          "hour" : "accounting_date_Hour",
          "minute" : "accounting_date_Minute",
          "month" : "accounting_date_Month",
          "quarter" : "accounting_date_Quarter",
          "second" : "accounting_date_Second",
          "week" : "accounting_date_Week",
          "year" : "accounting_date_Year",
          "fiscal​Week" : "accounting_date_Week_Fiscal",
          "fiscal​Month" : "accounting_date_Month_Fiscal",
          "fiscal​Quarter" : "accounting_date_Quarter_Fiscal",
          "fiscal​Year" : "accounting_date_Year_Fiscal"
 
        }
    }
],

When i tried to replace the JSON file into my dataset, it keep give me error below:
Unrecognized field "fiscal​Week"

It works well if remove all define fiscal year fields. But i need to set fiscal year to my dataset for visualization better.
 
Anyone can advise?
VinayVinay (Salesforce Developers) 
Hi Charles,

Check Fiscal Dates in tableau below.

https://help.tableau.com/current/pro/desktop/en-us/dates_fiscal.htm

Also,  You can reach out to Tableau CRM group on
https://trailhead.salesforce.com/trailblazer-community/groups/0F9300000009MBPCA2?tab=discussion for inputs on your ask.

Please mark as Best Answer if above information was helpful.

Thanks,
Charles TeeCharles Tee
Hi Vynay,

Thanks for your Fiscal Dates in tableau reference, but it is for the Tableau Desktop but the Tableau CRM solution.

Thanks share me the Tableau CRM group, i will go there to post my ask!

Thanks!
simply buzzes 9simply buzzes 9
You always welcome charles Tee, Many thanks for your kind information could you please have a look on my site (https://northell.design/blog/how-to-develop-a-school-management-system-software)  and recommend me a best way to join this group many thanks again.