Salesforce Developer Community

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
1

Questions
1

Replies

[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",
"fiscalWeek" : "accounting_date_Week_Fiscal",
"fiscalMonth" : "accounting_date_Month_Fiscal",
"fiscalQuarter" : "accounting_date_Quarter_Fiscal",
"fiscalYear" : "accounting_date_Year_Fiscal"

}
}
],

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

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?

Charles Tee
March 17, 2022
Like
0

3 replies

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

Charles Tee
March 17, 2022
Like
0