Hi all,
I'm working on a pivot table widget that shows ticket counts and values for each performance grouped by production. I'm trying to include the date of the performance using the Days in Date field but it keeps changing the year to the fiscal year the performance is in. Does anyone have any insight on what I'm doing wrong or what I need to do to pull the actual date?
Any and all help is greatly appreciated!
Thanks,
Ashley
Hi Ashley,
I didn't see a support ticket for you on this, but am guessing it's sorted. In case it's not, or for the record, there are Sisense > Admin settings that some self-hosted sites might inadvertently alter. One such setting is a Fiscal Year Start Month setting that exists both on the site and data source levels. It is not recommended that this setting be changed anywhere it exists, and that it be left set as "January". Analytics has fiscal year reporting fields separate from this Sisense feature. And as you can see from your screenshot, it can be confusing to see 12/22/2019 represented as 12/22/2020 FY.