Issue#35: Tableau - Turn Time into Bins

  • I am trying to create bins for a time dimension. Tableau currently is not letting me, is there a way to solve this? I want to separate the bins by hour.

    0 Answers

    Sorry, your answer is too short !

  • Issue#193735: Tableau - Running Average Turn Around Time

    Hi All, I'm trying to get the running average on a calculated field (Turn Around Time) as I'm not getting the quick table calculation option. Could you please let me know how i can get the running average?  ThanksJag

  • Issue#20: Tableau - Aggregation issue

        Hello all, I just want to begin by saying how much this forum has saved my job! Thanks everyone! I am having an issue getting my values to aggregate properly. I have attached two pictures below to help explain:BEFOREAFTERThe problem is that when I remove a dimension, the values are not aggregating properly. Each Facility and Cost Center should have 1 App attached to it and taking away Summary Pay type should not aggregate those Apps. Once I take away Cost Center, then they should begin to aggregate. I can use MAX() but then it keeps the same value when I get rid of cost center and I would want that to be Summed. The end goal of this is to track Dollars/App By facility and able to drilldown to cost center, then summary pay type and another layer of fidelity that I may add in. Thanks!

  • 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]

  • Issue#511: Asus - GL551JM Random Turn On Issue

    I'm having an issue with my ASUS ROG laptop where it will turn on by itself without being touched. When it does it says the last wake state was due to the Power Button. I found a thread here that says an update to the BIOS fixed it however the latest for the GL551JM is 204 and that was a GL551JW which has a newer BIOS update. Any help would be appreciated, it's annoying to have a dead laptop because it turned itself on over and over again in my backpack.

  • 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#2470: Unity - Random Editor issue.. | seems VS 2016 is causing editor to turn all warnings into err

    It happens in all my projects, and it only happens after I open VS (double click on script), make a script change, hit save..I can fix 'one' of the errors(warnings), unity re compiles...and Editor comes back to normal..for awhile..then back to that behavior,,, This is blocking my development chi....(I could fix every single warning)... here is the thing..under 'preferences', attach to editor...I can not Turn that Off...EVER.... I unchecked it, restart is active again...(that is... Random Editor issue.. | seems VS 2016 is causing editor to turn all warnings into errors..

  • Issue#4578: Tableau - Queries for all sheet are not executing at same time

    Hi Team, While checking the query execution timing (Start time,Elapsed time) from 'Tableau Performance Recording' dashboard,we are seeing that all the query are not being started at same time. Some queries are executed with some delay.Is there any feasibility to execute all the query at same time ? PFB the screenshot of the  'Tableau Performance Recording' dashboard.  In "Timeline" first bar is for filter, 2nd and 3rd bars are for two different queries.Tableau 9.1.1 is used with live connection.

  • Issue#5969: Playstation - I have solved my issue now I just have a general question for long time ps vita users

    I just have a simple qustion for ps vita users. In your experience have all yiour ps vita card always broken or caused issues with age? Just trying to get general information on this.

  • Issue#6003: Tableau - Difference between two time period on a table

    Hi all -  I have a simple table like this - DateDepartmentCost1/1/2015Dept 1101/2/2015Dept 2201/3/2015Dept 2202/1/2015Dept 1302/2/2015Dept 2102/3/2015Dept 1103/1/2015Dept 1103/2/2015Dept 2203/3/2015Dept 110 and I want to turn it to the following table visualization in Tableau:DepartmentJan-15Feb-15DifferenceDept 11040-30Dept 2401030  I would like the two months that are being compared to be selected by the user, probably with a parameter.  Should be very simple.  I had used the difference table calculation but for some reason I keep getting a blank column right before the Difference column, which I cannot get rid of.  Is there an easier way to do this? Much thanks! H.

  • Issue#17624: TestStand 4.2 Continuous Testing issue - same Time reporting for every UUT

    hi,   i have this issue on my TestStand 4.2, everytime I do continuous testing (Execute >> Test UUTs), each UUT has the same Time in reporting. What I need is how to modify the process model in such a way each UUT should have different Time in reporting. Please see image below for reference.   thanks, val87  

  • Issue#19163: Tableau - Calculating Customer Status Over Time

    Hi All, I have one that is fairly complex for me and really need some help.  Everything I have tried so far has not given me what I want. My goal is to be able to see a customer status over time when customer buying patterns are not consistent (buy month 1 and not month 2, but buy again in month 3).  In the example below I want Tableau to calculate the Status column.  I am interested in determining 'New for Product X' and 'Repeat for Product X' where repeat means they purchased that product sometime in the past  CustomerProductMonthSalesStatusABC123Jan 2015 $-  ABC123Feb 2015 $10.00New for Product 123ABC999Jan 2015 $15.00New for Product 999ABC999May 2015 $20.00Repeat for Product 999XYZ123Jan 2015 $10.00New for Product 123XYZ123Feb 2015 $15.00Repeat for Product 123XYZ123April 2015 $15.00Repeat for Product 123  I have lots of different customers and different products.  There will be a quick filter on products so my users can look at

  • Issue#19517: Occasionally missing data from output - Issue with Elapsed Time, Sample Compression, or something el

    Hi all, Hope you can help with the following. I have: A DAQ Assistant reading from 2 thermocouples at 1 Hz Sample Compression (factor of 60) to obtain the average every minute (not rolling average) Producer/consumer setup Elapsed Time which enables Write to Measurement (xlsx) every 60 seconds I ran this from 3:50pm to 7:22am the following morning. It seems to have worked, but I noticed that about once an hour, a data point is missing. Is this an issue with timing or how I set up the VI? Please advise.   Thanks!  

  • Issue#30051: HP - Test print ( small squares and two Bird) each time i turn it on

    Each time i turn my HP 7000 Wide Format, starts printing test print ( small squares and two bird). How i can stop it. It kills my ink.

  • Issue#48790: Tableau - Calculate Task time to Completion using Working Days

    Hi All, I have looked at all the existing forums ( on excluding holidays and weekends but did not get a working solution for me. I came across a solution but then in few cases I get negative dates. Also I like to know if just blending the holiday spreadsheet is enough to filter the holidays when calculating the days to completion.  I have attached my sample workbook and really appreciate any help. ThanksJag

  • Issue#53452: IPhone 6s plus face time issue

    I have purchased an iPhone 6s plus in Saudi Arabia. I couldn't find face time app installed in my phone. Could someone help how to install the face time in my phone for ios 9.1 OS. Is there any way to install the face time app without any jailbreak.

  • Issue#59963: Tableau - Reduce Loading Time

    How do I speed up loading up the views within a workbook in Tableau Server and speed up when I'm working on the worksheets that require loading / updating the data sources within Tableau Workbook?

  • Issue#59965: Tableau - View level rendering time

    Hi I am trying to create view level rendering time i.e how much time each view render over period of time.To get this i am using vizql session then create and complete times difference to arrive at render times along with request type as render.But i see that vizql session is at site level i.e the same session i see associated with two views of different workbooks. Can you please help to get render times for each view over period of time. Tableau version we are using 9.1 Thanks,Gokul.

  • Issue#64890: Tableau - Count of Companies by Revenue Bins

    Hello All, I apologize in advance if this is simple. I have looked at Jonathan Drummey and other people's solutions to this but I don't know how or why I am missing this. Anyhow:  I have attached a Tableau Packaged Workbook.  BackgroundThis data set contains a list of companies broken out by date, ID, and user_ids. 7 days worth of data. I am having difficulty setting up aggregate bins. I created an IF FORMULA to create bins, but for some reason only "1000+" shows up even though I have more bins.  What I am trying to AccomplishI would like to set up "Bins" and count the number of companies that spent in each bin, broken out PER day. Ideally, this could be a visual PIE chart or something but a simple text table is fine as well.  What my end goal would look like: (a graph per day) there would be seven pie charts showing the breakdown of spenders by revenue bin. Am I missing something obvious?       Thank you all in advance for your help.

  • Issue#69037: Notebook - ==Serious response time issue of Dell XPS15 9550 FHD

    guys, I got a serious issue of my xps15 9550, 1080FHD Terrible response time issue! ghosting! I play PES2016 (I played this game on PC and notebook since 2008, and never has this problem) on xps15, and everything showing dragging shadows! when player moving and ball moving, It hurts my eyes really bad. I set my game right, using Nvidia setting, this has been done million times, can not go wrong! updated latest driver no problem!... ==Serious response time issue of Dell XPS15 9550 FHD

  • Issue#76001: Ubnt - Wifi time schedule issue

    I would like to follow up this topic. Obviously, the Wifi shedule does not work with my AP. I just updated the fimrware. It has no effect on the WiFi time shedule.I have a small problem with the wifi time schedule of my AP LR. I set the times when it should be turned off in the night. For some reason, it does not switch off. Time zone is set correctly, new firmware is installed. Is it correct that, even if this feature works, only the SSID is hidden, but the radio still works?I would like to switch off the radiation completely in the night.What about installing a simple clock timer for the POE supply? Does the AP keep the configuration until the next morning? Is there any negative longterm effect if the AP is switched on/off daily?

  • Issue#77898: Tableau - Tasks are not getting pushed for refresh in its scheduled time . Not seen in Pending statu

    Hi All, I am using Tableau Server 9.2 version. I see sometimes the tasks scheduled for refresh at some specific time don't get pushed in queue.Hours after the scheduled time also can't see them in Pending status as well. At almost end of the day, I can see the next update datetime  showsthe next day's schedule although the extract haven't got refreshed. It has happened several times from the time I installed Server 9.2.Not seen this in previous version I would really appreciate  if anyone can throw some light into this.Really need help  Thanks in advance,Oin

  • Issue#78085: Tableau - Why does the Backgrounder fail though there seems no memory issue ?

    Hi All, I have Tableau Server version 9.2. Data sources are extracts and MySql data connection. I have 3 backgrounders. The system is of very high configuration (64bit, 32 Gb RAM, 7.5 TB memory). MySql Db is on different server than Tableau (which is also with good config) Sometimes there seems error as Lost Connection-com.tableausoftware.nativeapi.dll.TableauException: [MySQL][ODBC 5.3(w) Driver][mysqld-5.5.39]Lost connection to MySQL server during queryin background status of extracts although the refresh extract query is not heavy and executes in seconds. When I look at show processlist there was no memory issue/lock or anything during the execution. Also the system memory on both the servers seem fine too during the error time. I have seen in some threads where it is mentioned that the backgrounder restart itself in some interval.Is that true?  I am getting this issue in this version only. Din't get in previous version. Also, not every time same extract gets fai

  • Issue#89543: Tableau - How to filter out and count records within two specific datetime (using time)?

    Hi, I have been using tableau for some time now and I am stuck in creating a calculated field that would enable me to filter out between two specific datetime (ex: Count(number of records) if the datetime is > "8:30:00 PM" and < "7:30:00 AM". How do I proceed to obtain the result of records within these two specific times? Please be informed that the datetime field (I named the field "call_dateBegin) is of type VARCHAR. Thanks in advance.

  • Issue#91285: Tableau - How to Plot Value Over Time When Data Set Has Only 'Start' and 'End' Dates

    Hey Everyone, I have a seemingly simple problem that has stumped me and many Tableau "Doctors", and I'm hoping you can help me out.  I have a data set with a 'start month', an 'end month', and a 'monthly value', and I'm looking for a way to plot monthly value over time.  Here is a simplified version of the data set I'm using:   Customer NameMonthly Invoice AmountInvoice Start MonthInvoice End MonthCompany A$200January 2015July 2015 I've tried all sorts of calculations and techniques to allow me to plot 'total invoice amount' by month, but the only way I have been able to accomplish this successfully is by cross joining my data set with a table containing all months present in my data set, so that I have a row for each company and month.  So, for "Company A" in my data above, the new data set resulting from the cross join would look like this (7 rows instead of 1).   Customer NameMonthMonthly Invoice AmountCompany AJanuary 2015$200Company AFe

  • Issue#92328: Tableau - Revenue Bins Formula - not counting correct values

    Hi All, let me start off by saying this is the wierdest scenario that I have ever been in.  Procedure: Created a revenue bins formula (IF STATEMENT) to create bins that count companies based on their total sum for each quarter of the year. i.e. if sum > 100 THEN 100 - 500 etc... Problem: For the most part, the bins formula works by counting companies that spent greater or in between what the formula dictates. Pretty straightforward, thank you Pooja Gandhi for helping me on this.  But there are about 5 - 10 values that are not being counted correctly. See images below. The first three rows are obviously incorrect.Notice, it is giving a value of 1 (count distinct) even though parent 1685 HAS not spent more than 10K. It is counting 87 companies that spent at least 10K in Q1 - the correct answer should be 84, not 87.  Now here's where the weirdness begins.I set up a packaged workbook through an extract so that you can directly access my problem. I extracted on t

  • Issue#94630: Tableau - Sizing issue

    HiNeed help with server sizing issue.30~ datasourcesAll datasources are liveDB is Hive/Hadoop100~ users – means 10~ concurrent usersA lot of data – 500~ Tara

  • Issue#94934: EA - Returning Player - One time password issue.

    Hi there, I am a returning player to swtor, display name "SinisterMatt" and every time I try to log in I get the message telling me to enter the one time password I have been emailed.The problem is the password never gets emailed... Would love a bit of help and clarity on this as if I can't get access to my old account and progress then I can't play, I am not really interested in starting over. Thanks.

  • Issue#105773: Sony - STR-DN1060 & STR-DH130 turn on at same time.

    I have both a STR-DN1060 & STR-DH130 sitting next to each other, with the STR-DN1060 sending Zone 2 through the STR-DH130. I do this to provide smart features to the 2 channel unit, which powers a pair of patio speakers. My problem is that whenever I turn on the 1060 by remote, the 130 turns on, too. This is super annoying. I tried separating the signal by programming a Logitech Harmony remote, but that also fails turning both on. Any ideas of how to change one of the receivers to respond to a different program code or how to set one to respond only to it's own original remote?

  • Issue#107494: Tableau - Showing both count and percentage in a crosstab at the same time

    Hi, After getting the numbers for a cross tab ( 2 dimensions in the column and 1 in the row), how can I get the percentage to row total of each number alongside the actual count?i.e. Showing both actual count and percentage at the same time in the table.Thanks.    This is something we would like to see