GRC - Fiscal year reporting

[Mark P]

When building a bar chart using fiscal year, the x axis doesn't display the label (.i.e. the FY).  But if i change it back to Calendar year it does,  Is there any way to get the Fiscal Year labels  to display?  Thanks

[Mark P]

Oddly, if i change it from per year to per quarter, then the labels do appear

[Community Alums]

Hi @Mark P ,

You can look into report ranges: https://docs.servicenow.com/bundle/xanadu-now-intelligence/page/use/reporting/concept/c_ReportRanges...

[Mark P]

i @Community Alums Thanks, but i don't think its a range setting issue, they look like they've been set up correctly.  It's an issue with the bar chart x axis not pulling through the labels if configured to Fiscal Year (because they do if configured to Fiscal Quarter).  Note the 3rd chart compared (set to Fiscal Qtr) to the first chart (set to Fiscal Year)

[HaustinK]

I think I just experienced this as well... Maybe this will help someone. But I think it's tied to the Business Calendar Entry Name table (business_calendar_span_name). The fiscal period has a reference to this table in the "Name" field (span_name).

I had two problems with my Business Calendar Entry Name table I think as my BCEN records were missing their applicable "Calendar" and then the fiscal periods were missing the applicable BCEN reference.

Updating this allowed my x-axis labels to show the fiscal periods.

If I had to guess for you, your Fiscal Periods that are Fiscal Type = Quarter do have their span_name reference correctly filled out, but your Fiscal Type = Year are missing theirs.

Anyways, hope this helps!

-Haustin