Issue#69: Tableau - Circular Reference Error

  • I'm trying to re-create what is done on an excel spreadsheet in Tableau.  In Excel one of the formula's reference a field in the prior row and add a value to it.  When I try to create a calculated field in the same manner, I get a circular reference error.  The one error effects 4 calculations I'm trying to do.  I'm attaching the excel spreadsheet and the .twbx where I have tried to work through it.  After pulling my last hair out and stomping on my last nerve, Tableau has won, I give up an wave the white flag.


    The field I believe is the culprit is Total Trucks PO and Carryover - I've tried Previous_Value([Cap Resched]) and also Lookup([Cap Resched],-1).  I can't get either one to work. 


    Any help will be greatly appreciated.

    0 Answers

    Sorry, your answer is too short !

  • Issue#180108: Tableau - Issue of Adding Reference Line...

    Is anyone aware of an issue when using Adding Reference Line...(and selecting Line, Per Cell, Total, Value)? I would like to show the totals, but it turned out it only displayed the "$" -- only when you hover over it, it will show the total values. Does anyone know why the values were cut and how to resolve it? Many thanks!!

  • Issue#636390: Tableau - Database error 0x80004005: Syntax error in JOIN operation issue

    I have been trying to run a custom SQL query on a 2 excel tabs from the same sheet but I am getting this error. I am not sure where this is going wrong, would be really nice if some one can help me  with this . I have attached the excel sheet and the image of the issue. ThanksAnkit

  • Issue#783863: Tableau - Circular reference

    Does anyone know how I could code Beginning Amount and Ending Amount in calculated fields in Tableau? The way I'm doing it is causing a circular reference error for the two.Here's how I am currently doing it.  Ending Amount:if ISNULL ( attr([Actual Ending Amount])) then [Beginning Amount] + attr([Amount Received]) - attr([Amount Spent])else attr(Actual Ending Amount)end Beginning Amount:if ISNULL (attr([Actual Beginning Amount])) then lookup([Ending Amount],-1)else attr([Actual Beginning Amount])end I'm new to calculated fields so I'd appreciate any advice       DateBeginning AmountAmount ReceivedAmount SpentEnding AmountActual Beginning AmountActual Ending AmountMar-1630102383038Apr-1638715303830May-1630412223022Jun-16221813922Jul-163961035Aug-16354831Sep-163151521Oct-16218722

  • Issue#1052559: Error Circular Reference

    Hi people. I need convert my object Microsoft.AnalysisServices.AdomdClient.CubeDef to json file... this is my code: Microsoft.AnalysisServices.AdomdClient.CubeDef xs = c; var jso = new JavaScriptSerializer().Serialize(c); When i try do that, show error menssage. Somenone know any workaround for i do this??? Tks!

  • 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#36: Tableau - Has any one seen this error retrieving records from SQL Server

    There is about 50000 record in this table I am trying to get information from... If I narrow down the range it fine... but if I request all of it I get this error... Thanks.  CARLOS TRIVINO | Director, Information Technology905-875-0708 ext.332   Fax: 905-875-55191-375 Wheelabrator Way, Milton, ON, L9T3C1 "This email and any attachments may be confidential or legally privileged. If you received this message in error or are not the intended recipient, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained herein. Please inform us of the erroneous delivery by return e-mail.  

  • Issue#74: Tableau - Tableau Data Engine Error: 8 with all published views on server 9.1.1

    Recently we encountered issue with below error for all views. This impacted all business users in QA instance. We were not able to figure out what was the root cause. We have open case with Tableau as well. Even though, we were able to resolve issue but still would like to hear from anyone who had similar issue and know the root cause so that we can avoid going forward. "An unexpected error occurred. If youcontinue to receive this error please contact your Tableau ServerAdministrator. DataSourceException: Tableau Data Engine Error: 8: An error has occurred inIPC_Socket::Recv(buffer length=16) An existing connection was forcibly closedby the remote host 2016-01-20 00:25:41.372 (Vp7UBawQOk0AAAho0GQAAAJO,1,1) Would you like to reset the view?' Resolution: On two node architecture 1. Stop Services2. Move all services from Worker Node to Primary Node except Data Engine; File Store; Repository3. Save and start services; After start check if all views are working as expected, i

  • Issue#5004: Android - Unknown issue with Google Play Services Error

    I am getting a "Unknown issue with Google Play Services Error" when i open Google Apps like Gmail. I recently Unlocked the Bootloader and Rooted my Turbo. I dont see Google Play Services in Play Store to Update. Does anyone have any suggestions for the issue? Thanks in advance.

  • Issue#5194: Android - [SOLVED] Unknown issue with Google Play Services Error

    I am getting a "Unknown issue with Google Play Services Error" when i open Google Apps like Gmail. I recently Unlocked the Bootloader and Rooted my Turbo. I dont see Google Play Services in Play Store to Update. Does anyone have any suggestions for the issue? Thanks in advance.

  • Issue#7236: Tableau - How to scale y-axis of reference bar to same scale as the other bars

    I would like to create a bar chart where the bars are for 2 months of counts for a selected ca rmaker.  Additionally, I would like a third reference bar to the right of those which is the sum of all the counts for selected competitors.  I can't figure out how to get these on the same y-axis scale.  As I have it now, these come form two separate sheets and so the relative heights of the target company and competitors is inaccurate. Please see attached package workbook.  I've also experimented with parameters as the basis for the competitors selection criteria, but I need to select multiple companies, so it doesn't seem  parameters will do.  Thanks.

  • Issue#16185: Tableau - Syntax Error- If

    I'm getting a syntax error when I create the calculated field. Please assist.  If {[Report Submitted Date] - [START_EXPENSE_DATE]} > "45" AND [Org Id] <> "83" OR "115"THEN 'Show'ELSE 'Hide' END+IF  {[Report Submitted Date] - [START_EXPENSE_DATE]} > "60" AND [Org Id] = "83" OR "115"THEN 'Show'ELSE 'Hide' ENDEND

  • Issue#21456: Playstation - FIFA 16 - Error CE-34878-0: Fix for This Issue?

    So so disappointed in the technical support provided by Playstation.  Issue has been with Playstation for 2 months and each time I have to call for an update.   They have provided troubleshooting steps several times but it does not fix the error.   I purchased the Fifa 16 game of disc and each time you score a goal the system crashes and blue screens.  There are many internet sites where it says that Playstation know about this error however they do not have a fix.  Totally disappointed.  They can not guarantee that if I purchase the game online and the same error occurs they will replace my money.  I definately won't be buying a playstation again should the console die.      Mod Edit: Moved thread to support area, updated title. --GrainneNessa

  • Issue#42243: Tableau - SQL server authentication error on tableau server

    Hi folks, I need a small help regarding tableau server connection to a SQL Server database. In short, I've developed a tableau workbook with live connection to a SQL database and published to our tableau server. But when I login to tableau server and try to browse the report, I get the below error. It doesn't let me in even when I enter the login credentials. FYI...I'm using windows authentication for connecting to SQL Server authentication and the user id through which I've logged into tableau server has access to the database. I've also configured my tableau server to use Active directory, however I've not created a service account yet (it's using NT AUTHORITY\NetworkService which is a dummy one). Let me know if I'm missing anything pls?  Thanks in advance!

  • Issue#44026: Tableau - error in YEAR(DATE)

    Hi, i have a timestamp field in mysql table. when i tried to add filter with year(date_field) i get this error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTEGER my query is  SELECT CAST(CAST({fn TRUNCATE(EXTRACT(YEAR FROM CAST(`Custom SQL Query`.`data` AS DATE)),0)} AS INTEGER) AS FLOAT) AS `data`FROM (..... the problem is cast to integer. If i try to cast to char it works. Please help. thanks

  • Issue#45042: Ubuntu Software Update Error/Issue

    I installed 14.04.3 on a new laptop at the weekend and when trying to run updates I'm getting an error "Error:Broken Count>0" I've hunted around looking for some guidance but come up empty. I did run 2 commands in Terminal (sudo apt-get update and sudo apt-get upgrade) following a suggestion on another thread. Results below: Code:                         [email protected]:~$ sudo apt-get update   Ign trusty InRelease   Hit trusty-updates InRelease   Hit trusty-backports InRelease   Hit trusty-security InRelease   Hit trusty Release.gpg   Hit trusty-updates/main Sources   Hit trusty-updates/restricted Sources   Hit http://archive.ubuntu.

  • Issue#47026: Tableau - How Can I get rid of This Error??

    Hi All, I have connected 5 data tables into tableau like this After then, I created a calculated field called Bed obse/patient location like thisTableau allow me to create this as a valid field, but when I drag this variable in to filter then it just shows the following error message...Can anyone please help me sort this out  Best regards,Sithum

  • Issue#47844: Unity - App in debug mode error, keystore set, still issue

    I'm a Unity developer but today I was going to publish my first app to the Google Playstore. My app runs fine on the testing device, I have set the keystore and not checked 'developement' withing the publish settings. However, every time I try to publish it and upload the app to the playstore, I get the error: 'App is in debug mode'. I've searched hours to find this issue, updated my JDK, Android SDK and such, but nothing changes. I'm using Unity3D 5.3.0f4. Does anyone has an idea what I'm... App in debug mode error, keystore set, still issue

  • Issue#60521: NetApp - Object reference not set to an instance of an object error

    I have been using the PSTK4.1.0, the title of the error came out.The error did not come out when I was using the PSTK4.0.0.(During the execution of the New-NcVserver.) Why get an error in the new Version?After POST an error, there is only waiting for a correction?

  • Issue#60590: Tableau - Table name changed after extracting data - Error - Invalid table name valueT

    Hello! I'm getting below error as the name of a table I'm using in custom SQL has changed (after I extracted data into the workbook). I'm using Tableau Desktop 9.2. When I click on Data Source, I get prompted to enter connection details (Cloudera Hadoop). When I hit OK, then I get above message. However, the screen where I set up custom SQL is not coming up. How do I modify my sql to reflect new table name and resolve above error? Thanks for your attention! Ravi.

  • Issue#62908: Tableau - Struggling to add reference line with secondary data source.

    I have been working through an example (2-39) in the book "Tableau your data!"  I am struggling to make a black reference line appear on the bar-chart on Sheet1 for the "Budget Sales 2015" measure in the second data source (blend), in the attached example.  Anybody see what I am doing wrong. Thanks,Brian Marsh

  • Issue#66804: Tableau - Error with DATE formula

    Hello All,I'm running into the following error when opening my workbook: [DataDirect][ODBC Greenplum Wire Protocol driver][Greenplum]ERROR: date/time field value out of range: "3/31/2014"  (seg2 slice1 sdw1:40002 pid=14997)(File cdbdisp.c;Line 1525;Routine cdbdisp_finishCommand;)  prepare.xmlclass DataSourceException The only thing I can think out that is causing this problem is I had to convert my FISCAL YEAR  and FISCAL QUARTER fields (discrete dimension) using the DATE formula, which reads:  date(IF [Fiscal Quarter] = 1 THEN "3/31/" + str([Fiscal Year])ELSEIF [Fiscal Quarter] = 2 THEN "6/30/" + str([Fiscal Year])ELSEIF [Fiscal Quarter] = 3 THEN "9/30/" + str([Fiscal Year])ELSEIF [Fiscal Quarter] = 4 THEN "12/31/" + str([Fiscal Year])END) Any ideas on why I'm getting this error.All help is much appreciated! Regards,Mikey

  • Issue#66890: installation issue with lightroom. error : change modules, required folder issue?

    installation issue with lightroom.  error : change modules,  required folder issue?

  • Issue#70134: How to fix .NET Reference error in TLA5201 logic analyzer using Macbook OS X10

    Dear Labview users,I am trying to use the TLA5201-Logic Analyzer with Labview 14.0.1 on Macbook with OSx.10.11.2 operating system. After installing the labview drivers from the link posted above, the example VIs are not compiled successfully. It seems to have problems with .NET reference. I have been searching thorugh lots of Ni forums but they didn't seem to help at all as they were all based on Windows based operating system. Any help or suggestion on solving this issues would be very helpful. I am even wondering if anyone outhtere was able to even compile any of the example VIs given for TLA5201 logic analyzer? Please let me know. Thanks! 

  • Issue#72249: HP - Quick Restoration issue with Error no 3 Not enough Memory

    Hello, I am having a problem with a restoration for a Compaq Presario 5304 back to it's original Windows 98. When using the Quickrestore, It gives me an error # 3 and Not Enough Memory. It has 384MB of Ram and a 20GB Hard Drive. That is enough for Windows 98. Any reasons why I am getting that error. I enjoy collecting vintage computers and restoring them. Any Compaq experts?? Thanks.

  • Issue#72474: HP - wifi error issue

    While I was in a Skype call my screen went blue and said Windows is having errors restarting PC, something along those lines. When it restarted it wouldn't find any Wi-Fi connections at all. When I click Wi-Fi, it says nothing, but has the airplane mode button.

  • 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#82392: I have an issue starting up Illustrator. I get an error telling me to uninstall and reinstall error

    I have an issue starting up Illustrator. I get an error telling me to uninstall and reinstall error code:1. Once I do that it works fine but when I start PC up again I get the same error. Suggestions?

  • Issue#86048: Tableau - Axis Range wont Zoom/Change with Slider Filter when adding reference lines

    Hello, I have a dashboard that displays the number of records per day over the course of 3 years. On certain dates, I have added reference lines to examine a correlation with daily volume to certain important dates. Before I add a reference line, when I adjust the date slider filter, it will only show me the relevant dates on the x-axis. For example, if I adjust the filter to just see Oct - Dec 2015, the axis will begin at 10/1/2015 and end at 12/31/2015. This allows for a kind of "zoom" effect. However, When I add 1 or more reference lines, the slider filter behaves as shown in the picture attached. It effectively cuts the data of the graph without zooming in. Are there any ways around this? I want to preserve the zoom effect while keeping reference lines on the x axis. Thanks, Andrew

  • Issue#88944: Tableau - Getting Error while Connecting to Hortonworks Hive

    Hi , I am trying to connect to Hortonworks Hive database. I installed 32 bit Hortonworks Hive ODBC driver in 32 bit windows 7 system. when i tried to connect with tableau i am getting below error.Please let me know the reason why i am getting this error: [Hortonworks][HiveODBC] (34) Error from server: connect() failed: errno = 10061. If anyone already worked on this please let me know steps to setup connection between Hortonworks Hive and Tableau. Regards,Suresh.N