Issue#86: Tableau - Additional date time number formats

  • I calculate time variances in some of my KPI dashboards that result in negative time values (e.g. if a procedure starts early it will be a negative variance from the planned time). Extending the custom number formats to allow for things like this would be great: "h:mm:ss;(h:mm:ss)". I currently have to color encode the values to be able to tell the difference between positive and negative values.


    It would also be great if this format worked like it does in Excel: "[h]:mm:ss". The brackets allow the hours to extend beyond a base 24 hour period. Currently 25 hours renders as "1:00:00". With my proposed format it would render as "25:00:00".


    [A related feature request is to support an actual TIME data type, that idea is at]


    [Edited 20150810 to add the TIME data type reference - Jonathan Drummey]

    0 Answers

    Sorry, your answer is too short !

  • Issue#1265: iPhone 5c: Can someone explain this date & time issue one iOS 8.3?

    This device has a very strange date & time issue (maybe multiple issues). Auto time/date will not automatically detect the timezonewill not automatically adjust to the correct time Maintain time/date the time will count upwards as normal until the screen is locked for roughly 10 minutes (sleep)once the device resumes from sleep (unlock) it will display the time that was registered immediately prior to sleeping - and will continue to count upwards as normal from there Manually setting time/date when manually setting the date & time, the day/month scroll will sporadically change - for example: above the selector bar will show 9 May, below the bar will show 11 May but inside the bar will show 26 Oct (all just example dates).when scrolling through the dates, the day/month will magically meld into the incorrect sequence of day/monthoften the 'set date & time' will jump forward or backward by as much as 30 years or more (sometimes also resetting to Unix Epoch)often the scro

  • Issue#78423: Giffgaff - Can a agent tell me the last time (date) i text a certain number?

    Was just wondering if i could find the date i last text a certain number a date is all i need?

  • Issue#195306: Tableau - Year and Month Number Fields into Date?

    I'm new to Tableau and I have two number number fields that contain Year and Month (i.e. 2015 and 12) and I want to combine them into a single date field (ie. Dec 2015). Not sure how to do this. Thinking that I would concatenate them and Dateparse them? Thanks.

  • Issue#322862: Tableau - For a given Date, Display UUser-defined number of Past and Future Dates

    Hi guys,  We need to display forecast numbers on a line chart with data updated until yesterday's values (refreshed automatically) We want to provide the user the ability to select the number of days to display in the past and in the future. For example, given the date 3/20, if the user selects '20' on the past date parameter and 10 on the future date parameter the line chart should display values from 3/1 to 3/30 Is there a way we could go about doing this using parameters?   Thanks!

  • Issue#335067: Tableau - How to aggregate data into a number using calculated fields and date filtering to compare

    Hello, Thanks in advance for taking the time to read/answer this post! Essentially I have 2 numbers, where both numbers are calculated using the same calculated field. The only extra step that changes these numbers would be a date filter to alters the period. The first number looks at the previous 12 months from today; whereas, the second number looks at the 12 months before that. (extra detail: the filter is a calculated field that will filter automatically based on the current day). Currently, I need to create two sheet in order to show these two numbers because the date filter needs to be pulled into the filter shelf to restrict the period of each sheet. I'd like to create another sheet to be able to get the % change and a sheet to get the difference between these two numbers but I'm not able to do anything that does this. Any thoughts? Cheers,Aiden

  • Issue#351681: Tableau - Help in changing a number format to date

    I have a field called as date which is in number(whole) format. I need to change it to date. Date(whole)-990401 i want it to 1899/04/01

  • Issue#407361: Set date/time issue on BT 7610

    My parents are having a problem setting the date and time on their BT 7610 handset system - since the clocks changed for DST. Using the menu to get to date/time allows them to change the time, and then when trying to change the date it displays as 126/00/201 and then changes to 12/00/0000.  When they try to enter a new date - for example 04 / 04 / 2016 it does not allow the second '4' digit to be entered. After this neither the date nor time is changed. Any help would be appreciated.

  • Issue#421015: Tableau - Splitting metrics by time chunks when only start/end date are in data source

    Hi all, I am trying to do something that might not be possible using only Tableau. I have a dataset containing 5 columns: - Rental Order ID- Rental Product Name- Rental Order Start Date- Rental Order End Date- Rental Order Revenue  Orders usually span over 50-90 days (so 1.5 to 3 months). I would like to display the revenue generated by months, knowing that the 'daily revenue of an order' (or 'rate') is  [ Revenue Rental Order ] / DATEDIFF('day', [ Rental Order Start Date ], [ Rental Order End Date ])  Changing the data source is not an option . I attached a sample. Ideally I would like to end up with something like, with, if possible, dynamic dates that can be grouped by days/months/quarter/year. Thanks a lot for any ideas.

  • Issue#462940: Tableau - another open/close date issue: overdue tickets, aka count # of tickets open more than X da

    Hi all, I've spent the last few days working on trouble ticket data, using the excellent FAQ on open/close dates.  But, I've got a twist on the issue that I can't figure out.  I can count the number of open tickets, but I also need to count the number of tickets that are open, and have been open more than X days (where X will likely be 14 and 90, but which is 2 in the attached for simplicity). I've attached a simplified workbook to show what I want.  the basic open tracking sheet is working for open ticket.  If it was working, I would want another page that would show 1 overdue at the end of 1/2, 2 at the end of 1/3, 1 on 1/4, 1 on 1/5, and 0 on 1/6.  the actual data source will be an SQL database, but I'm using excel for this example. Since i have to track this at the individual ticket level, I'm not sure how to track that over time, or how to handle dates that don't exist in the data, like 1/5.  Any help would be REALLY helpful. I've been

  • Issue#531416: Tableau - Date formats within calculated fields

    How do you set date formats within a calculated field for use a by a parameter with 'Day', 'Week' and 'Month'? I currently have these set as Datename. I require my axis to show these formats: 'dd/mm/yyyy' for day, 'yyyy/ww' for week and 'mmm-yy' for month.

  • Issue#569194: Tableau - Average Number Of Records Over Time

    I've created a couple of filters to show me active employees over a date range, but now I'm wondering if I can get this to show me an average over the selected period of time instead of a total count. Whenever I change it to aggregate as an average I always just get 1 - which is not correct. I think it's because the system doesn't have enough data to look at. I believe I need to first get it to give me a total active headcount per day and then average off of that. The only problem is figuring out how to get it to give me an average headcount by day! My filter to pull only active team members looks like this:IF[Hire Date]<=[End Date]ANDISNULL([Termination Date])THEN 'Active'ELSEIF [Hire Date]>[End Date]OR [Termination Date]>=[Start Date]THEN 'Termed'END I just want to get it to show me actual headcount for every single day so I can average over spans of time. Hope this makes sense!

  • Issue#600067: Tableau - Is it possible to use parameters to control multiple number formats within a sheet of meas

    I have an attached workbook where I'd like to use a parameter to adjust whether a # or % is shown. Unfortunately it seems that when inputting a "when" statement, the formatting is not flexible for a % vs a #. Are there any workarounds to doing this? Thanks in advance! 

  • Issue#609113: Tableau - Number of Current Customers over Time

    Hello All - I'm trying to get a handle on how to report customer Account Status over time. In my business, we count Current Customers as any customer that has ordered in the past 4 weeks. I have a couple of calculated fields to help me determine Account Status. The first calculated field, called Weeks Since Last Delivery, determines how many weeks it's been since a customer has ordered. It looks like this: ([Week Last Delivery]-[Current Week])/7*-1 I then have a calculated field called Account Status that categorizes the customer based on how long it's been since that last delivery. It looks like this: if [weeks since last delivery]<=8and [weeks since last delivery]>=4then "Trouble"ELSEIF [weeks since last delivery]>8then "Lost"else "Current" END This works as a snapshot view of account status as of the current date. My issue is that I can't figure out how to track Account Status over time. So, I have 268 Current Customers today but I can't figure out

  • Issue#710526: Tableau - How to handle multiple number formats in one field?

    Hi everyone, this is my first post, so please bear with me.... I have a need to create a simple data table to accompany visualizations. I'm having multiple problems, but the first one is this: I have multiple fields with two different number formats. The data contains records with names, denominators, numerators (either # or $, depending on the record), targets (either % or %), and actuals (% or $)  This is the way the data comes in, so it's not too practical to reformat the source data. In the past, I've made simple tables in excel organized thusly: --------------numerator------denominator--------actual-------target--------achievementname1---------###--------------####-----------------%------------%-----------------%name2---------$$$--------------####-----------------$$-----------$$-----------------%name3---------###--------------####-----------------%------------%-----------------% as well as charts with more than one y axis, so the money gets plotted against

  • Issue#744162: Tableau - convert number to date in live connection

    Hii am connecting live to AS/400.i have number field with the structure yyyymmdd.i want to convert it to date and reduce 7 days.what ever i do - i get errors from the AS/!!!!!!!!!!!!!!!!

  • Issue#781087: Tableau - Summing Revenue for a Month Based on a Point in Time Date

    I am trying to sum transaction revenue based on a minimum start date for each respective Company among their divisions.  Below is the data set and desired outcome.     Dates TableSupplierBuyerDivisionStart DateSupplier A         Company 1       Division 1          1/15/2016Supplier A        Company 1       Division 2          1/25/2016Supplier B         Company 1       Division 3          3/15/2016Supplier A         Company 2       Division 1          2/7/2016Supplier A       

  • Issue#838221: Tableau - 15-minute time increments, ignoring the Date

    I need to show the total number of calls received by our call center by time of day, in 15-minute increments, and I need the numbers to reflect the entire year, not each date.   I have created bins for the time in 15 minute increments --- DATETIME(INT(FLOAT([Start Date]) * (1440 / 15)) / (1440 / 15)) --- but I get a separate column for each date: I only need one column for the total number of calls received in that 15-minute interval over the entire year. This is what I want it to look like:  Time#Calls7:1520457:3012307:459128:003218:153228:3022348:4520129:001719 Appreciate any help!

  • Issue#846345: Sony - W-950D Series - Date And Time Setting Issue with Andriod TVs - Know Issue but dont see any ef

    Dear Sony ,  I bought a new Sony W-950D 50" Andriod TV and from day one i am hating sony for this bug .  I an using TV connected with Wifi Router - NETGEAR .  Problem : When ever i switch off TV and On it again - Data and time resetting to default time 5:30AM 1-1-2015 and its panicing when ever i open you tube i need to set it to right one manually . And it doesnt fix once i dot ..for every power off and power on same problem i face . Given my wifi route is ON all the time 24/7 .. It is a Clear Bug from Sony Side nothing to do with anything else . You people not able to maintina a proper clock setting by it own once it is configured ??? i see this problem is not new and over the portal it is running across the world . Why Sony is so silent in fixing simple problem ?? 

  • Issue#849828: Tableau - Formatting Time and Date for a forecast

    Good Afternoon, I am attempting a forecast in Tableau 9.3 and I am having trouble formatting the date to provide an accurate forecast. I convert the date from discrete to continuous, but all my forecasts end up being horizontal lines, as seen in the below.  My date formatting mirrors what I see in the my superstore dataset, with the exception of the x-axis; my data in the image below appears to be broken out by month (on the x-axis), while the superstore data appears to be broken out be year.  I ultimately want my data to reflect change and forecast from month-to-month, but is there something I need to do with the axes?   I have also attached an excel doc with the date formatting included and stripped-down data.  Thank you 

  • Issue#858838: Tableau - Create a calculated field for date & time

    HI,  There is a dimension called system time in the dataset.The data format is like "29/06/2016  06:14:08" which the time is in US timezone.I would like to create a calculated field called local time to show the corresponding UK time of the system time.i.e. US time + 5 hours ahead.In the example, the tme of local time would be "29/06/2016  11:14:08".I tried the MAKEDATETIME function but it didn't work well.Would you please let me know what the best solution would be?Thanks.

  • Issue#870825: Tableau - Date question: The day name changes to number when moving to live connection, I use Datena

    Hi, I use the below calculated field to create weekday name out of date field. As long as I use an extract it shows weekday name as Monday, Tuesday...upto Sunday. The moment I change the connection to live (from extract) the format changes to 1,2,3,4,5,6,7 with 1 representing (Sunday), 2 Monday etc. DATENAME('weekday',[Date],'MONDAY') Please advise how can I fix this. Thanks,Adnan

  • Issue#890417: Tableau - can we see a project level information who accessed project ( in time, number of count a v

    can we see a project level information who accessed project ( in time, number of count a viewer accessed a project ) unlike we get in status bar traffic to views is only for worksheet views information but want project level traffic to views please answer

  • Issue#943148: Tableau - Filtering on total number by segment for a given time period

    I have a stacked area chart showing number of products bought per type. Now I want to break this out by promocode. The issue is we have 100s of promocodes and most of them have barely any data. How would I filter it down so I only show promo codes that have a significant number of sales (say 100 or more) for the time period? I don't want to filter out data points, I want to filter out the promocode completely if it doesn't have a total of a 100 or more sales for the period. This is just an example, but I often find myself looking to do this and I'm not sure how to go about it.  So here any row (promocode) with less than 100 sales would be filtered out completely. A big bonus would be to be able to sort this by total sales in the time period, so the rows with the most data show up on top

  • Issue#1008229: DAX formula to create a New Measure (number of hours between starting date time and end date time)

    Hi all!I need to create a New Measure DAX formula to sum up the number of hours between "starting date time" and "end date time" of two columns. The formula needs to exclude the end date time cells that do not have any value. What I really want is to get the average number of total hours between dates for a given month.e.g.  15 Hours for the month of february. Can someone help me with this?Thanks in advance. 

  • Issue#1041510: Tableau - Combine time, day, month, year variables into single calculated date field

    Hello all, I have several fields that I'd like to combine into a single calculated date field: a four-digit year (e.g., 2016), a two-digit month (e.g., 11 = November), a maximum two-digit day, and a GMT time stamp. Can anyone advise on how best to combine these into a single calculated date field? Thanks,  - John

  • Issue#1128153: Tableau - Convert Date & Time to Time only and having the ability to sum/create calculations from ti

    Hi all, I'm relatively new to Tableau so please forgive me if this question has been answered or is 'an easy one'. My data contains a number of different phone/call lines which our customers call us on. My aim is to display call stats per line but also the total time on each phone line, the total/average waiting times, etc... I have connected to my data fine. The data in the time columns (lets say duration of call for instance (Active Time column), displays the time in the following format: DD/MM/YYYY hh:mm:ss - the time part of the field is correct and displaying what I expect. My issue is stripping the date from this field and then having the ability to sum/average/create calculations using the time. I have attached a screen shot below:   Taking row 1 for example, what I'd like to achieve is the below:  So far, I've been able to display and sum the number of calls per Service by date fine - but my problem is now displaying time/duration for each ser

  • Issue#1142009: Tableau - Date and Time Fields

    Hi Tableau Community, I am facing an issue with my data for the date and time fields. When I import my data source, Tableau doesn't recognizes the fields "Sys Created On" and "Sys Updated On" as date and time fields. I chose them as date and time from the "Choose data Type" option and it still shows up as null. Can someone please tell me what am I doing wrong ? I have attached the workbook(Version 9.0) and I have also attached the data source. Thanks and Best Regards, Jesse

  • Issue#1148893: Tableau - Convert a date (number) into a day of the week

    Hello All, I have date field as a number. I want to convert a date to a specific day of the week. Please advise. I would appreciate the help. Thanks GGoraya

  • Issue#1164342: Tableau - VIZABLE issue in a getting column to be recognized as Category, not Number

    Vizable for the iPad in iOS 9.5 is not recognizing a file import correcting for columns marked as category type with "ID." I am unable to find any instrunction about how to reliably mark a column which has numbers as category vs number. Any suggestions?