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 …

Hi! @Xclipse Thank you very much for helping me with this logic. I don’t have much experience with formulas, so it’s great to have a support team. The data you provided was very helpful; in some of the formulas you gave me, the syntax did change, such as: Is Weekday Calculation ifelse(extract(“W…

Hi @Michelle , try using this function isWorkDay . Also, try using the Amazon Q Assistant on the function documentation page. [IMG_6751] Build calculations with Generative BI Another approach is using Generative BI, you can use natural language prompts to create calculated fields within Quick Sight…

Hi @Michelle , did the Amazon Q Assistant work for you? Let us know if this is resolved. And if it is, please help the community by marking this answer as a “Solution.” (click the check box under the reply)

Hi In our Quick Sight, we do not have BI capabilities, but that’s okay. Thanks for your valuable help

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

Calculate the number of consecutive days

Related topics