Calculate the number of working days between two Control dates

[Jabez]

Hi, I’m new to using Quicksight and I’m hoping someone can point me in the right direction.

I’m trying to create something that shows me the total number of working days between two dates (inputted via controls).

I have been trying to achieve this using netWorkDays, but getting some strange results.

netWorkDays(${StartDate}, ${EndDate})

I have created this table to illustrate the result I’m getting.

Is it possible to use netWorkDays with a date range provided via controls?
If not, is there another way I can achieve this?

[Brett]

Hi @Jabez and welcome to the QuickSight community!
From my understanding, and according to the linked page, you should be able to use parameters with the netWorkDays function.
Would you be able to share screenshots of the 2 parameters you’ve setup for start and end date (preferably the view when you hit ‘edit parameter’).

Additionally, have you tried changing the aggregation in the field well to see if that changes your results?

[Jabez]

Hi @Brett, thank you so much for your response.

Your suggestion to change the Aggregate, appears to have resolved the issue.

Setting this to Average now gives me the correct number of working days.