Number of Days in a Fiscal quarter

[Priyank Dwivedi]

What's the easiest way to evaluate the number of days in a fiscal quarter based on a given date?

[Kirsten Smith (she/her)]

Can you clarify further what you are looking for? Do you want to select a date and then return the total number of days for the Fiscal quarter that contains that date? Or days to the end of the Fiscal quarter? Working days, or total days? With or without holidays? Once we have a better understanding of your request we can make suggestions.

[Priyank Dwivedi]

That's right, Kristen.

I wish to select a date and get the total number of days for the Fiscal quarter the selected date lies within. It would be great to get working days and total days separately.

[Kirsten Smith (she/her)]

I think you will find that this will be better accomplished in a TERR data function than using Spotfire functionality. You can read more about data functions here:

https://docs.tibco.com/pub/sfire-analyst/12.3.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=df%2Fdf_how_to_use_a_predefined_data_function.htm

Here's a link to a YouTube video about creating data functions:

Link for TERR documentation:

https://docs.tibco.com/products/tibco-enterprise-runtime-for-r

I'd recommend that you start with the R package 'bizdays', as it has a lot of the functionality you are asking for:

https://cran.r-project.org/web/packages/bizdays/bizdays.pdf

Pass the selected date into the data function, then you can use the package to identify the fiscal quarter and return the desired number of days.

[Priyank Dwivedi]

Thanks Kirsten. That's helpful.