Non-working days in Harvest data

Hi,

Is there a way to specify non-working days for the whole team (e.g., Bank Holidays) for data imported from Harvest?

Harvest itself doesn’t store this data, but it would be great if EazyBI allowed us to manage it.

Cheers,
Freddie

Hi @freedo50

Welcome to the eazyBI community.

Unfortunately, the option to specify non-working days is not available for the Harvest data source. We do have a feature request regarding that in our backlog, and I added your vote to it. However, it is still in the phase of gathering user interest. Thus I don’t have any estimates.

There could be cases where the lack of this feature can be overcome with calculated members in the Time dimension or calculated measures. Please share more details on your requirement, and I will try to help you.

Best,
Roberts // support@eazybi.com

Hi Roberts,

Thanks for the response.

The use case is as follows:

I have an existing report that I have built to calculate what % of their contracted hours my team members have logged in Harvest each week (weekly contracted hours = daily contracted hours * number of days). Currently both the daily contracted hours and number of days are hard-coded, however I’d like the number of days parameter to be decreased if there is a Bank Holiday in a given week.

If this can be achieved with an adjustment to the calculated measure, that would suffice until the full solution is built.

Cheers,
Freddie