0 votes

My current formula is : DATEDIFF('day', MIN([Date]),MAX([Date])).

How do I exclude sundays and holidays from this?

Apr 7, 2022 in Tableau 748 views

## 1 answer to this question.

0 votes

To exclude Sundays from the DATEDIFF calculation in Tableau, you can modify the formula by using the WEEKDAY function:

DATEDIFF('day', MIN([Date]), MAX([Date])) - SUM(INT(WEEKDAY([Date])) = 1)

This formula subtracts the count of Sundays (where the WEEKDAY function returns 1 for Sunday) from the total DATEDIFF result, effectively excluding Sundays from the calculation.

Elevate your data visualization skills with our Tableau Course and unleash the power of insightful analytics.

answered Jul 3, 2023 by anonymous
• 1,380 points

0 votes
1 answer

## How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

0 votes
1 answer

## How to group bins in a tableau histogram?

One of the simple way is by ...READ MORE

0 votes
1 answer

## How to use a IFF statement in Tableau

Use this syntax -  IIF(([Avg_sale] > [Today]),STR([Avg_sal ...READ MORE

0 votes
1 answer

## How to get Tableau results in python?

Well even I was looking for the ...READ MORE

0 votes
1 answer

## How to dynamically determine and categorize duplicate value in Tableau?

Apparently you define a duplicate records as ...READ MORE

0 votes
0 answers

## Tableau report sharing

We have a number of historical tableau ...READ MORE

0 votes
1 answer

## How to create a funnel visual/bar chart in Tableau by creating a calculated field using an existing column in the data source?

Please find a possible solution in fiddling. You ...READ MORE

0 votes
1 answer

## Tableau Public Background Images Not Working

The functionality you're talking about (Map -> ...READ MORE

0 votes
1 answer

## Error while connecting tableau to snowflake using username and password

"Couldn't resolve host name," says the error ...READ MORE

0 votes
1 answer

## Dynamically set the value of a filter based on a parameter selection in use to swap sheets

Here's a simplified example of the calculated ...READ MORE