Hi team I need help to how to calculate in Quicksight the number of days for each date, ensuring it meets the rule of having 6 consecutive days excluding weekends. The goal is to calculate the count between dates that meet the criterion of being consecutive based on vacation days taken and the mos…

Hi @Michelle , welcome to the Quick Sight Community. Let’s dive into the process of calculating the number of vacation days, ensuring that it meets the rule of having 6 consecutive days excluding weekends. Step-by-Step Process in Amazon Quick Sight Step 1: Data Preparation Before proceeding, ensure …

Calculate the number of consecutive days

Q&A

Xclipse June 26, 2024, 5:00am 7

Hi @Michelle – also, try this post - Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

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	208	January 20, 2024
How to calculate work days? Q&A calculations	7	4880	September 4, 2025
Calculating length of time without a break Q&A analysis , date , calculations	2	330	November 15, 2022
[Help] - Number of custom days Q&A date , filters-controls-and-parameters	4	302	August 17, 2023
Issue with calculated field in Quicksight Q&A calculations , Business-Intelligence-Engineer	7	623	November 27, 2023

Calculate the number of consecutive days

Related topics