You need to sign in to do that
Don't have an account?

[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?
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?
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,
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!