Customer question - How can I calculate work days in Quick Sight? (ie - exclude weekends and other specific holidays)

You can do work day calculations using a combination of existing calcs. I have posted a sample at https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Calculation-Work-Days Calculation used is min( //Get the days between start and end dates. //If this is 0 or negative, the…

How to calculate work days?

Q&A

Aishwar July 6, 2023, 12:48pm 4

@ArunSanthosh Can this be made dynamic based on the list of Holidays for a given year?

祝日を除いた稼働日の計算方法

Topic		Replies	Views
In calculated feild on Quicksight want to get week days diffrence ( netwaok days )and exclude few specific dates dates Q&A analysis , calculations , Business-Intelligence-Engineer	1	203	January 20, 2024
How to calculate Working Hours between 2 dates Q&A formulas , calculations , Business-Intelligence-Engineer	3	366	November 13, 2023
How to exclude the weekend days from network formula? Q&A developer , qls-dev-resources	7	256	February 16, 2024
[Help] - Number of custom days Q&A date , filters-controls-and-parameters	4	298	August 17, 2023
Workdays question Q&A qls-reinvent2022	1	319	January 18, 2023

How to calculate work days?

Related topics