Oracle Analytics and AI

User_BCACP

Hello,

I would like to create a column with a moving number of working days. The working days will be calculated based on the selected period time from the Dashboard Prompt. For example from 2025week03 to 2025week40 or from 2025/01/01 to 2025/03/14. It is possible?

Number of working days will be part of the formula.

Best regards

Gianni Ceresa

Hi,

Do you have a fully defined business meaning of "working day"? Because out of the box, in the product, there isn't something for that because a working day is different in each region, country or even just from a company to another. Because the "business day" is a business definition, you need to have a definition of it first. Then you can look at the best way to implement it.

Usually for this kind of requirements, a time dimension is what you use to solve it: you can add an attribute to each date to say if it's a working day or not, and then you can simply count the rows having that attribute in the period you are interested in.