**New to Tableau
I am trying to create a new column for that changes a cell to say 'Open' when it is equal to 0.
Currently I have this, but I can't compare an int and a string.
IF... more**New to Tableau
I am trying to create a new column for that changes a cell to say 'Open' when it is equal to 0.
Currently I have this, but I can't compare an int and a string.
IF = 0
THEN = 'Open'
ELSE
END
Any way to possibly do this without changing the SQL?
I just have a bunch of dimensions in rows, so its just a table of information and I need to hide a column of data because its confidential, but I need the data there because it... moreI just have a bunch of dimensions in rows, so its just a table of information and I need to hide a column of data because its confidential, but I need the data there because it affects the layout of the rest of the table.
I'm kicking tires on BI tools, including, of course, Tableau. Part of my evaluation includes correlating the SQL generated by the BI tool with my actions in the tool.
Tableau has... moreI'm kicking tires on BI tools, including, of course, Tableau. Part of my evaluation includes correlating the SQL generated by the BI tool with my actions in the tool.
Tableau has me mystified. My database has 2 billion things; however, no matter what I do in Tableau, the query Redshift reports as having been run is "Fetch 10000 in SQL_CURxyz", i.e. a cursor operation. In the screenshot below, you can see the cursor ids change, indicating new queries are being run -- but you don't see the original queries.
Is this a Redshift or Tableau quirk? Any idea how to see what's actually running under the hood? And why is Tableau always operating on 10000 records at a time? less
I'm getting the below error while trying to run the javascript code in attempt to render a view from my tableau server which has trusted authentication.While trying to run the JS... moreI'm getting the below error while trying to run the javascript code in attempt to render a view from my tableau server which has trusted authentication.While trying to run the JS code, the view is not getting rendered in the browser, however, if I log in to my tableau server on one tab and run the JS in another tab, the view is getting rendered as its taking the authentication from the browser cache.Error says:Refused to display < url> in a frame because it set 'X-Frame-Options' to 'SAMEORIGIN'.Code:
<script type="text/javascript"
src="http://<tableau server URL of the view>"></script>
<script type="text/javascript">
function initViz() {
var containerDiv = document.getElementById("vizContainer"),
url = "<Tableau server URL of the view>",
options = {
hideTabs: true,
onFirstInteractive: function () {
console.log("Run this code when the viz has finished loading.");
}
};
var viz... less
Situation now: I have a data warehouse job profile that publishes .txt file in Data folder every day in the morning. I open Tableau workbook which automatically updates data... moreSituation now: I have a data warehouse job profile that publishes .txt file in Data folder every day in the morning. I open Tableau workbook which automatically updates data visualisations because of union I made. I save this workbook as extract and collages without Tableau Desktop can view it via Tableau Reader.
What I need: This reporting format is heavily dependent on me and I need to automate this.
Is this even possible without Tableau Server?
I have a field such... moreI have a field such that
Color
Pink
Blue
Pink
Blue
Pink
Pink
Pink
Pink
Pink
Blue
Blue
Pink
Pink
Pink
Blue
Pink
Blue
Pink
Blue
How to create calculated field to count number of times Pink appears?
Total numbers of Blue?
I'm trying to achieve a viz in Tableau in which If I click on a paramteer value called sales then sales viz should be selected and if I click on parameter value Profit, then... moreI'm trying to achieve a viz in Tableau in which If I click on a paramteer value called sales then sales viz should be selected and if I click on parameter value Profit, then profit viz should be displayed.
Can this be done using parameters in the first place? Or Action filter is the only option?If action filter is the option can I make sure that If I select one parameter say Sales then the other Viz should be hidden automatically.
I'm using Simba's ODBC driver for connecting Tableau to MongoDB. I connected my workbook to MongoDB, developed my dashboard and everything went pretty smooth. However, after I... moreI'm using Simba's ODBC driver for connecting Tableau to MongoDB. I connected my workbook to MongoDB, developed my dashboard and everything went pretty smooth. However, after I publish my workbook to Tableau server and try to open it, I get an error message:
"An unexpected error occurred. If you continue to receive this error please contact your Tableau Server Administrator. Tableau Server encountered an error. Contact your Tableau Server Administrator. Would you like to reset the view?"
Why can't I view this dashboard in Tableau Server? less
Oftentimes I need to troubleshoot a workbook that another person at my company has created and published to our server. To troubleshoot, I need to see their connection details,... moreOftentimes I need to troubleshoot a workbook that another person at my company has created and published to our server. To troubleshoot, I need to see their connection details, specifically their Custom SQL, to understand what data they are using in their extract.
Is there any way to view this connection info (specifically their SQL code) when viewing the published workbook on the server (web) version?
I am an admin and I am able to download their workbook to my desktop version of tableau, then open it, then reconnect to the data, then look through the data connections they created, to see their SQL. But it's a really cumbersome process.
All I'm looking to do is, when looking at a published workbook, see the data connection details so that I can see the Custom SQL, without going through the process of downloading I described above. less
If you download a Tableau Public dashboard, you'll get access to the datasets that where use to make it.
I believe it is the same for Tableau Desktop dashboards.
Which leads me to... moreIf you download a Tableau Public dashboard, you'll get access to the datasets that where use to make it.
I believe it is the same for Tableau Desktop dashboards.
Which leads me to : are Tableau Desktop documents, stored on a Tableau Server, downloadable by anyone with access to that link ?
I would like to publish a Tableau Desktop dashboard on a Tableau Server so I can put it on a website yet I don't want the viewers to be able to download the dashboard. Knowing this will likely determine whether or not I buy Tableau Server. less
I have purchased Tableau Online to share my workbooks with a specific group of people without providing an option to download the actual data I used to create them. But I figured... moreI have purchased Tableau Online to share my workbooks with a specific group of people without providing an option to download the actual data I used to create them. But I figured that other users would also need a license to view/edit my workbooks..
My initial plan was to share my published workbooks and put them on my website so that others (that I specify) can VIEW the workbook without offering them a privilege of downloading the data. Any suggestion will be greatly appreciated...
Need help with tableau .tdsx usage.
Current Process: - We publish and refresh data sources (packaged .tdsx) to the tableau server. Our customers download the data sources and... moreNeed help with tableau .tdsx usage.
Current Process: - We publish and refresh data sources (packaged .tdsx) to the tableau server. Our customers download the data sources and build ad hoc reports for their business needs.
Problem: - If the customer already build some views last month, is there a way to download the latest ‘.tdsx’ file and use it in the existing workbook were they created the views.Today, customer is re-creating the views using each month updated ‘.tdsx’ files.
Can you suggest a better way to achieve this? I can provide more details if it is needed.
Note: - Publishing a packaged workbook (.twbx) with views in it is not feasible as the report requirement varies most of the months. less
I have Tableau Online. I have a few dashboards that I want to share without password access and embed in my public website. When I embed it ask for the password. I have tried... moreI have Tableau Online. I have a few dashboards that I want to share without password access and embed in my public website. When I embed it ask for the password. I have tried various tableau authentication but its only available in Tableau Server.
When you connect a data source, Tableau automatically infers the type of each column of your data. Whether it's Number (decimal), Number (whole), String, Boolean, etc. A few... moreWhen you connect a data source, Tableau automatically infers the type of each column of your data. Whether it's Number (decimal), Number (whole), String, Boolean, etc. A few questions about this:
1) Has Tableau ever misclassified one (or more) columns of your data with their automatic labeling? If so, would you please give details?
2) Do you feel that these data type options can be improved? For example, Tableau doesn't seem to be distinguishing between unordered categorical data and ordinal data.
Thanks!
