Skip to Main Content
Spotfire Ideas Portal
Status Already exists
Product Spotfire
Categories Custom Expressions
Created by Guest
Created on Oct 2, 2017

Adding Fiscal date hierarchy

Hi,

All our analysis is based on Fiscal calendar. To get this filter I need to create three separate columns (one each for year, quarter, month) and combine them as hierarchy hence creating unnecessary data columns and too much of work as we have many dates to consider. Like Calendar year, if we have hierarchy creating option and have Fiscal Week option would be great. Thank you!  

  • Attach files
  • Guest
    Reply
    |
    Jun 21, 2018

    Fiscal data hierarchy is available in addition to a normal date hierarchy.

    In preferences>Application>Fiscal Year enter the offset for your company in months so that Quarters align with the months.