Content in Tableau Community Forums

COUNT records where column = expression

tableaucommunity@tableau.com — Tue, 08 May 2018 14:24:34 GMT

I need to get the COUNT of all records in which ColumnX equals a certain value. I tried doing COUNT(ColumnX = "Value"), but this does not return the correct count. I do not want to filter the data where ColumnX equals this value, because I will be needing another column in the worksheet that shows the COUNT of where ColumnX = "AnotherValue".

Thanks

How to create filter in Dashboard that controls 2 different datasources?

tableaucommunity@tableau.com — Thu, 30 Aug 2012 16:56:53 GMT

I have created a Dashboard that will show data that comes from 2 different datasources, one from SQL Server and another from an Access Database.

I would like to create a YEAR filter in the dashboard that will filter the data in both datasources using the corresponding date fields in each.

I have created a Relationship between both date fields, but have not been able to get the filter to update both datasources. Is this possible?

Underlying data does not show level of detail

tableaucommunity@tableau.com — Wed, 13 Jun 2012 19:03:33 GMT

I have a map view with the value of longitude in the "Column" shelf and latitude in the "Row" shelf. I have a secondary data connection linked to the primary by a route number.

I have the Sum(Number of Records) from the secondary data connection in the "Size" shelf. When the number of records is more than 1, I would like for the underlying data to show each one of the rows corresponding to the secondary data connection. But the underlying data only shows the data for the primary data connection, not the secondary data connection. I added a field to the "Level of Detail" shelf from the secondary data connection ("Fecha entrada"), but still does not show when I click "View Data" from a point with more than 1 record.

Is there a way to go around this?

How do I enable configured actions when publishing to Tableau Server?

tableaucommunity@tableau.com — Mon, 23 Apr 2012 19:16:50 GMT

I have published several dashboards to Tableau Server and realized that an action I had configured in one dashboard does not work in the Tableau Server. When I select a certain record from one dashboard, it it supposed to jump to another dashboard with the corresponding data of the selected record.

How do I enable these actions when viewing the reports using Tableau Server?

Thank you

Count of calculated field whose result is > than a value

tableaucommunity@tableau.com — Thu, 16 Feb 2012 15:23:15 GMT

As shown in the attached packaged workbook, I have calculated the percent of total records with NTU value < 0.3. I know need to create a worksheet to show a summary of the total count of filters that have a 99% or greater. For example, I need to show the location "SergioCuevas_WFP" and the total count of filters that have a percentage of 99 and greater. In other words, I only want to show the column named "LocWinName" with the corresponding count and not the detail of all its filters (column named WFPName).

The "Filter Percent Detail" tab shows the detail of the percentages for each filter. The second tab, "Plant Summary" shows what I really need, which is the name of the plant with the MAX total count of all filters with percentages greater or equal to 99%. I have a running total, but I just need to show the MAX total of that list, not the whole list.

Any help will be appreciated!