So my current formula is this: DATEDIFF('day', MIN([Date]),MAX([Date])).
How do I exclude sundays? and holidays.
Asked
Active
Viewed 607 times
0
-
Deduct `datediff('week'...)`? Not sure how Tableau works but I think that would count the number of week transitions (where week starts on Sunday anyway.) – shawnt00 Aug 02 '21 at 02:51
-
Offset by week transitions. In case first day is Sunday start range one day earlier: `- DATEDIFF('week', MIN([Date]-1),MAX([Date]), 'sunday')` – shawnt00 Aug 02 '21 at 02:57
-
Hi! @shawnt00. Additional question though. What if I want the complete days in a month to appear since in my raw data for some categories has no date entry for example: Agent A January 1 Agent A January 1 Agent A January 3 So it only count 2 days (jan 1 & 3). I will be using this as a divisor to get the average that's why I needed the complete days. – COCO Aug 02 '21 at 06:42
-
I don't know enough about your problem or Tableau to answer. Often this is a join against a calendar table. Try searching for "densification". – shawnt00 Aug 02 '21 at 07:13