FAQ: Open & Close Dates
kettan Jun 30, 2019 6:34 AMRecommended for Running Total
Show Records That Fall Within a Period of Time | Tableau Software
Headcount, when given the Arrival & Departure Dates
Recommended for Cross Join
Split Periods Into Rows Dynamically
CROSS JOIN with Tableau's join dialog
Blogs
2019-01-02 Scaffold data with Tableau Prep to fill gaps in your data set | Tableau Software
2017-03-09 Cross Data Source Joins + Join on Calcs = UNION Almost Anything in Tableau v10.2
2015-09-21 Vizible Difference: Taking Stock with Start and End Dates
2015-08-05 RHSD: Lookup vs. Transactional Data
Data Reshaping
Installing the Tableau Add-In for Reshaping Data in Excel | Tableau Software
Is it possible to incorporate data reshaping into the Tableau Extract Engine?
CROSS JOIN with Tableau's join dialog
Questions
Meaning of Formatting
2014-05-22 Ignored
2014-05-22 Answered
2014-05-22 Correctly Answered
The list below is sorted by date, that is, not by relevance or quality.
2017-09-07 Display all the Dates between the date range in the Report column
2017-08-11 Date Range List
2017-08-02 How to get names of months between two dates?
2017-08-02 Running Total of a Field per month between defined Start & End Dates
2017-07-31 how many employees are working by the hour of the day.
2017-07-30 Revenue daily equal distribution by using start and end date of contract
2017-07-27 Count unique active organizations by month
2017-07-27 In/Out Inventory Activity
2017-07-25 How to fix custom month numbers from Min date to Max Date
2017-07-20 Trend Line Chart for Cases with only Start and End Date
2017-07-20 Week of filter from Start & End Date Columns
2017-07-19 Show count occurrences of when a date falls between a start and end time
2017-07-14 Calculation depending on a Start Date and a End Date and represent it on a time axis
2017-07-13 Calculate Monthly Opened Tickets
2017-07-11 Number of Active At A Specific Time
2017-07-11 # of Products at a specific point in time
2017-07-11 Status analysis start and end date overlap month
2017-07-10 Create an average of the last 52 weeks, based on a custom date range length
2017-07-10 Filling in the missing dates - "This works perfectly!"
2017-07-07 How to get the dates from a date filter
2017-07-06 Block Time analysis
2017-07-05 get the count of living person on particular date
2017-06-29 Find number of days between status change
2017-06-28 How to display a daily number of guests based on the start and end dates of their stays ... ?
2017-06-26 Line chart with line from start date to end date
2017-06-19 How to synchronize 2 date fields and filter independently?
2017-06-19 Counting concurrent appointments per hour with start and end dates
2017-06-12 Tableau 10.0- Period between Start date and End date to be added under Each month
2017-06-06 Equal Split Over Period
2017-05-15 Calculation of days from start date and end date within quarters
2017-05-01 How to calculate an exact date with period # and start/end dates?
2017-05-01 I have a start and an end date how do I get my data to appear in between
2017-04-18 Amount of tickets every day
2017-04-17 How to create calculated field for aggregated dates in a date range
2017-04-14 How to create calculated field for each date in a date range
2017-04-11 Mapping start and end dates from two data sets
2017-04-10 Plotting date field using Start/End dates with data from Tableau Server (no joining)
2017-04-03 Turning a Flag on if the date is between a start date and an end date
2017-03-27 Combining 2 date columns to show respective count
2017-03-15 Distribute Measure Value over 12 Months
2017-03-07 Manipulating single field with stacked dates
2017-02-23 Summing over time with variable interval length data
2017-02-09 Counting Helpdesk ticket stats.......Version 10.1.1
2017-01-13 Distinct Head Counts Between 2 Dates without Running Totals (V.10)
2016-12-12 Need help tracking daily project funding over time (Open & Close Dates)
2016-12-06 Pivot from Detail data with different start end dates to create a viz with result filtered data set
2016-11-28 Start Date/End Date calculations
2016-11-23 Managing "Average Days Open" for tickets across a 12-month period
2016-11-18 How to aggregate ticket/inventory management in tableau ?
2016-09-19 Problems with Scaffold date blending
2016-09-18 Challenge with dates and calculated field
2016-09-18 Separate Date Driven Values, Same Table, Show on One Time Range
2016-09-16 Active data Between selected dates
2016-09-01 Number of records across criteria
2016-08-10 Timeline - showing a bar for start, end and today's date
2016-07-23 Running Total with Start and End Dates
2016-06-08 Spread value between start date and end date
2016-06-06 Combine two date fields on one axis date
2016-04-14 another open/close date issue: overdue tickets, aka count # of tickets open more than X days
2016-04-11 Need help with School Calendar that have start/end dates
2016-04-07 Splitting metrics by time chunks when only start/end date are in data source
2016-04-05 Employee Heat Map from Start Time and Duration
2016-03-31 Help with a count
2016-03-30 Items Active between Start and End Date
2016-03-28 Count number of customers given start and end dates
2016-03-07 Help/guidance on a transactional data challenge - Open/Close Bar Chart
2016-03-07 display service desk pending tieckets at any given time
2016-03-03 Chart for Monthly closure rate
2016-02-25 Complicated data join/blend on dates
2016-02-09 How to Plot Value Over Time When Data Set Has Only 'Start' and 'End' Dates
2016-02-08 How to combine 2 different charts?
2016-02-04 Associated Values during certain times in a day
2016-01-21 Calendar date parameter
2015-12-03 Calendar with Events Spanning Dates
2015-11-30 Create Time-Series Chart for resource utilization
2015-11-29 Classify average of duration per group
2015-11-28 Blending Actives, Terms and Hires Data
2015-11-25 Calculate Difference between Running-Sums
2015-11-24 Inventory Levels - Issues With Timeline.
2015-11-17 Use time parameter in time series?
2015-11-12 Line graph showing headcount using two dates
2015-11-05 Time difference on a set start/end time
2015-11-05 Identifying Overlapping Dates
2015-11-03 How to create a table calculation to understand the evolution of a workforce in a career?
2015-11-03 Determining the number of days (gaps) between multiple date ranges
2015-11-03 calculated field count within date range
2015-11-03 DATEDIFF with condition - tracking working time
2015-11-02 how to create a burn down chart?
2015-10-28 Summing Data by Date
2015-10-09 Displaying Counts Based on Age Over Time
2015-10-08 plotting cases opened/closed over time
2015-10-07 Business Retention
2015-10-06 Want to create Workload/Capacity Chart
2015-10-05 Employees/Patients Time Issue
2015-09-30 Date - Time difference between activity type appearing multiple times
2015-08-28 2 side-by-side bars for number of records per month with start date and end date
2015-08-26 Monthly count of employees based on start and end date
2015-08-20 Display all dates between two dates even if date has no data
2015-08-18 Help getting a value for every day (date) of the month.
2015-08-18 How do I count cases matching a calculation over time?
2015-08-13 Reporting of dates within dates - i'm confused..
2015-07-30 Another question about Open/Close dates (with a TWIST!)
2015-07-29 Trying to replicate Excel Countif statements and having a hard time.
2015-07-28 How to calculate net new using open and closed dates?
2015-07-19 Headcount, when given the Arrival & Departure Dates
2015-07-16 How to draw trend and moving average on Created(Order Date), Closed/Resolved(Ship Date) …
2015-07-10 累積時間の差分計算について
2015-06-30 Two different time dimension databases including one date range
2015-06-29 How do I show estimated revenue over time with only a campaign start date and end date?
2015-06-29 Series chart with only start and stop date.
2015-06-26 Trend active records between start and end dates
2015-06-25 Custom date dimension from min date to max date
2015-06-25 How to reference a column's value in a calculated field?
2015-06-21 Alarm data with open/close timestamp. Need duration running per day
2015-06-11 Date / Time stamp data dump every cut off
2015-05-28 Proportional Brushing with Open/Close Dates
2015-05-25 Displaying crowd density by hours with data in start and end time format
2015-05-11 Time between clinical events - Healthcare
2015-05-10 Sum time intervals on a date placed over multiple rows i data?
2015-05-07 Trending Hospital Census based on Admission and Discharge dates
2015-05-04 date columns independent of data
2015-05-04 Any Workaround to Bring Date Bins to a Calculation Field
2015-05-03 Global Date
2015-04-30 Is it possible to create psedo months and divide value between them ?
2015-04-29 Create Date to divide data across
2015-04-28 Historical Trending of Open Items
2015-04-20 Count days in Date Range
2015-04-20 how to calculate number of days in a month dynamically
2015-04-17 master calendar (how to show status of tickets over a time period)
2015-04-16 Date Range as Parameter/Filter
2015-04-16 how to display the data in Range of Dates
2015-04-14 How do I show two date ranges in one Viz?
2015-04-09 Date Issue
2015-04-03 Table issues
2015-03-31 Cross Join Collection with just one table
2015-03-30 Different dates in one filter
2015-03-30 how to get month names between two dates in tableau
2015-03-27 aggregate timedifferences between timestamps of datarecords by type
2015-03-26 Healthcare - how to filter/calculate by date range
2015-03-26 Tableau - Monthwise Data Distribution
2015-03-25 Mapping events between two dates
2015-03-24 count based on 2 date parameters and one more parameter
2015-03-24 Dynamically charting status change based on dates
2015-03-19 Measure activity between dates
2015-03-17 Bar Chart with only one time line ( but flow should be from start date and end date)
2015-03-17 How to get counts of active enrollments (active between two dates)
2015-03-15 Visitors at a Given Time
2015-03-12 Start and End date calculations
2015-03-09 Calendar Date as Field Within a Table
2015-02-27 Select a date but used in two different purposes
2015-02-19 Calculate time difference between 2 sequential records
2015-02-19 Instance of Value Relative to Date + Date of Event on Other Row
2015-02-19 Maximum occupancy of departure lounge/calculation from Gantt chart
2015-02-13 calculating time intervals with time stamps in the same column
2015-02-11 date question
2015-02-03 Divide a value between months
2015-01-21 Calculate monthly payment and display over time
2015-01-19 Calculate difference in value based on two date parameters
2015-01-15 Calculate the date time difference between two rows
2015-01-15 How to get the dates between a startDate and an endDate
2015-01-14 Tickets Open and Closed
2015-01-09 Duration between tasks?
2015-01-08 Calculated filed questions and Date question
2015-01-07 Date Time Difference from different rows
2015-01-05 Calculating Headcount and Attrition - Day/Week/Month/Year
2014-12-31 Historical Data, Total Open Projects at Any One Time
2014-12-30 How can I create a calculated field that will count rows where a date is missing?
2014-12-29 Trending Age Of Workforce
2014-12-10 Backlog History Data
2014-12-02 Charting motor runtimes from timestamps?
2014-11-27 Tableau Date Challange
2014-11-18 Tracking team members based upon date ranges
2014-11-17 Carried details
2014-11-14 Comparing value of a field in two different dates
2014-11-13 How do I create hourly time buckets to graph two different time-related fields on the same axis?
2014-11-12 Tableau Challange
2014-11-11 Using varied start and end dates for contracts
2014-11-07 How to filter a "change history" data source by date
2014-10-19 Creating a view showing most recent status
2014-10-06 Last Status by Date and Counting Statuses
2014-09-30 QoQ trend
2014-09-29 calculate the frequency of active records from a date range
2014-09-19 Aggregation
2014-09-18 Data blending to tag specific instances in time
2014-09-05 calculate the frequency from a date range
2014-08-22 Rolling backlog calculation
2014-08-09 Model tickets open vs closed
2014-07-31 Create line on chart based on date duration
2014-07-25 Group based on two dimensions: start time & end time, and Plot
2014-07-21 Re: The Advertising Campaigns Dashboard Conundrum
2014-07-14 Make 2 different date ranges form one based on one measure
2014-07-03 Line to show how many days the item is been pending
2014-06-30 How do I make a "trailing date range" calculated field?
2014-06-27 Date Bin Using Start Date and Date Count
2014-06-17 How to create 2 lines (or columns) from same measure and different filters
2014-06-17 Plotting the Planned vs Actual $ Shipped by date
2014-06-11 Using start & end dates to determine number of clients over time with one file
2014-06-06 time series on items between a start and end date
2014-06-05 How to get daily count from beginning and ending dates
2014-05-22 Number of Open Cases
2014-05-15 Histogram of concurrent activities
2014-04-30 Stuck building a line chart with start and end date fields
2014-04-30 Rolling Backlog Calculations
2014-04-28 multi-dimensional data
2014-04-21 Weekend Calculation ** Urgent**
2014-04-18 IF Statement to Filter
2014-04-07 Custom filter with multiple conditions including list?
2014-03-25 Conditional Data Relationship
2014-03-20 Formula that gives True or False when a dimension has no value
2014-03-20 How can I link Date subtotals from the same table?
2014-03-11 Filter by minimum date
2014-03-06 I need to calculate Idle time of a case
2014-03-05 Open Cases Chart
2014-03-04 How can I link idenical matters in snap shot data?
2014-02-13 calculated date x axis
2014-02-11 Generating more than one date with DATEADD function
2014-02-06 How do I generate multiple values from a single data point?
2014-01-17 Sum of Business Hours/Minutes?
2014-01-14 Custom SQL query using a parameter to define a column name
2014-01-10 Date Filter - 2 columns
2013-12-26 Side by Side Open/Closed by Month
2013-12-12 Count 'active' people in a Gantt chart?
2013-11-22 Calculations based on two columns in a row
2013-11-19 Create a date range between date start and date end fields
2013-11-12 Calculations with multiple date fields
2013-11-05 Multiple Measures on an Independent Date?
2013-11-01 Count distinct records that fit multiple date criteria
2013-10-16 How do you create a cumulative employee turnover trend chart using only a start-date and end-date?
2013-10-16 Calculate Date Difference for each ID
2013-10-15 Identify dates between a range
2013-10-14 Number of active issues using open and close dates
2013-10-09 Using a date parameter as a column?
2013-09-27 Why can't I convert my date dimension to a measure?
2013-09-16 Maximum calls overlapped in a day
2013-08-28 The specified item was not found.
2013-07-27 Count In-flight Events
2013-07-24 combine two date fields on same axis
2013-07-07 Date Differnce - only working hours - only working days
2013-07-02 Hi, I am looking to track open and closed cases across a period of time.
2013-07-01 measure open and closed cases for week
2013-06-13 Plotting a Date on Chart
2013-06-10 Using Parameters to filter a Boolean Dimension
2013-06-06 Calculate datediff with only one date field
2013-05-30 Dashboard to track progress of actions
2013-05-23 Custom Date Range
2013-05-22 Historic view of Open Cases
2013-05-13 Finding data points between two date demensions
2013-05-11 Turnover Rate (Hiring Date and Terms Date)
2013-04-30 Create a date to filter vacation calendar
2013-03-12 Calculating on two date fields
2013-03-04 Hourly/Daily instrument utilization using status dates.
2013-03-04 Start and End Date
2013-02-17 How do I create a Date field to show a timeline of events?
2013-02-14 Creating a Rollforward
2013-02-07 Split Date Range from Source Data Into Days
2013-02-01 How to display a graph of "active events" over time
2013-02-01 How to count occurences by date
2012-12-20 DATEDIFF not giving correct number of days difference
2012-12-19 Trend with the number of employees per month
2012-10-19 Finding entries that were not present in a previous period?
2012-09-14 net number of outstanding calls
2012-09-04 Side by Side Month over month opened and closed
2012-08-29 Table structure with open date and close date columns
2012-08-23 Trying to get a total of all items between two dates using two date measures.
2012-07-27 extract sign up date from list of events
2012-06-18 Total by date range and end date filters
2012-05-15 DateDiff for Working days only
2012-03-19 Create net change by period line chart
2012-03-18 Calculation - Urgent
2012-02-23 How to count ID #'s within a date range by date?
2012-01-26 Manual sort not working
Stampless
2011-10-18 calculating concurrent users based off of login time and logout time
2011-08-05 How to Filter out records with Dates which are greater than the Report End Date Filter
2011-08-05 How to Filter out records with Dates which are greater than the Report End Date Filter
2011-06-21 Open and closed ticket per month
2011-06-14 calculating employee turnover
2011-04-11 Using a date to select a data point
2011-02-28 How to create a partial measure calculated field
2011-01-14 Is there a way to re-order the columns in a set?
2010-09-04 Comparing volumes in and out by month
2010-06-04 Gantt chart
2010-06-01 Trending Point in Time Data
2010-05-26 Headcount based on State/End Dates
2010-04-27 Count number of open cases
2010-01-07 Display dual bar on one Gantt Chart
2009-09-16 Reporting on two independent data fields
2008-08-23 Syntax for co-ordinates in a table?
Ideas
2015-07-20 Date period as multiple marks
2015-03-28 Pivot on calculated record-level fields
2015-01-18 Date period dimension type with built-in row split
2014-07-17 allow group by (or raw sql) to define dynamic sets with more general conditions
2014-05-16 Support cross product / cross join / Cartesian join / Cartesian product in new connection interface
2014-05-16 Support custom WHERE clause in new connection interface
2014-01-21 Super Sets and Subsets - Creating a Series of Sets with Single Calculation
2013-03-01 Parameter (or custom range) as axis
Purpose
1. The primary aim of this question collection is to show that issues with open and close dates (and alike) is an almost overwhelmingly frequently asked question. Why so would be interesting to know, but not something I will try to answer, at least not now, although I hope to hear some opinions on why it is so and what to do about it.
2. A secondary aim is to encourage production of well-written teaching materials, videos, and a workbook with all the examples which self-learners can study on their own.
3. A third aim is to encourage Tableau to improve their handling of date intervals:
Date period dimension type with built-in row split
-oOo-
Other FAQ collections: FAQ Hub