You can use a quick Table calc, Running Sum, to see the net staffing level. Now all you have to do is, just concatenate the results you have found in above steps as below. sum(hour of Start and End) + days in between * business hours/day weekends in between * business hour/day, 7.Call it [Total Min], calculate the total minutes. Action. Tableau Tips: Datetime difference in the format DD:HH:MM:SS If you like the work we do and would like to work with us, drop us an email on our Contacts page and well reach out! Tableau Count Records Between Date Ranges - Stack Overflow Content Discovery initiative April 13 update: Related questions using a Review our technical responses for the 2023 Developer Survey, How to calculate number of days between two given dates. In the formula field, create a calculation similar to the following: Create a calculated field with a name like "End (shift to closing)" with a calculation similar to the following: Create a calculated field with a name like "Business Minutes" with a calculation similar to the following: Create a calculated field with a name like "Business Hours" with a calculation similar to the following: These calculated fields can be combined. In Tableau, how to calculate business hours/mins between two dates, excluding weekends? Hold down the Ctrl key (Option key on the Mac) and drag the Week(Order Date) field from the Columns shelf to the Filter shelf. In the post 10 Data Viz Tips I Learned from Google Analytics, I shared that before I started using Tableau, I began my career in digital analytics using Google Analytics. How to find difference between two dates | Tableau scenarios Lets discuss your data challenges! Using parameters can easily change between two or more date fields . Formulas - how to return all days between two dates - PowerApps Guide Tableau Date Functions and How to Use Them for Your Analysis Table functions can be computed differently to allow the calculation to be further customized. The basic building blocks for a gantt chart are as follows: For more information about the Gantt bar mark type, see Gantt Bar mark. We will use this value to extract the day, hour,mins and remainder seconds. DATEDIFF Tableau: How to use it for Analysis? - Hevo Data SeeFill Gaps in Sequential Data for instructions. This problem will be simpler if you reshape your data to have the following three columns. Now your view shows you all sorts of information about the lag between order times and ship times. To do this, create a calculated field to capture that interval. Tableau Desktop Answer CLICK TO EXPAND SOLUTION Option 1: Count number of weekdays between two date fields in the data source Step 1: Create Calculated Fields Select Analysis > Create Calculated Field In the Calculated Field dialog box that opens, do the following, and then click OK: Name the calculated field.