Showing posts with label Tableau Technical Support. Show all posts
Showing posts with label Tableau Technical Support. Show all posts

Monday, 6 June 2016

Asterisks Display in Tooltips - Tableau Desktop




http://kb.tableau.com/articles/Issue/asterisks-display-in-tooltip?userSource=1

https://community.tableau.com/thread/153244?start=30&tstart=0

Problem:  I was able to display the multiples time in a single row, but as tooltip it is duplicating the values
Feeder (Table across)  used:

IF first()==0 THEN
    STR(min([Start Timestamp]))
ELSE
    PREVIOUS_VALUE("") + ", " + STR(min([Start Timestamp]))
END

Date tooltip (Table across) used:

IF FIRST()==0 THEN
    LOOKUP([Feeder],LAST())
END

 Listed below are articles for reference on Addressing and Partitioning, the Table Calculation Functions used in the solution, and information on Dashboard Action Filters:

 Addressing and Partitioning



Table Calculation Functions


 
Filter Actions

Connecting Active Directory as Tableau data source

The ability to connect with Active Directory as a data source is not currently built into Tableau desktop.
 
 The best practice to get around this issue is to mirror the unsupported data source onto a support data source, so you can place the data you want to analyze in a form that Tableau Desktop can properly connect with. The article below goes into more detail on this issue and using an ODBC connection:
 

'Connections to Unsupported Data Sources'


 
'Ideas'


 

LDAP (OLE DB/ADO) data connector for analytics


 

Tuesday, 31 May 2016

Swapping views by categories (parameters) - Filtering a view according to a category selection (filter)

filtering a view according to a category selection:

 

Option 1- Using Filter Shelf Selection

 

1. Locate the field that the view would be filtered by, in this case it would be Category 2. Drag this field, Category, onto the Filter Shelf 3. Right-click the field in the Filter Shelf and select "Show Filter"

4. Select the number of Categories that will affect the view 5. If desired the selection box can be formatted to show different selection methods by right-clicking the box

 

Option 2- Using a Parameter

 

1. Create a new Parameter

2. Select String for Data type

3. Select List

4. From 'Add from Field'  select the desired field, in this case Category 5. Select Ok 5. Drag the field selected above, Category, onto the Filter Shelf 6. Select Use all on the General Tab 7. Move to the Condition Tab 8. Select 'By formula' and type the following

 

[Category]=[Parameter Created Above]

 

9. Click ok

10. Right-click the parameter from the left hand pane and select 'Show Parameter'

 

Using any of the two options above will allow for the selection of a category to filter the current view. Please see the following articles for further information on filtering a view:

 

Show Filters in the View


 

Changing Views Using Parameters


 

Filters Shelf


 


 
 

Tuesday, 24 May 2016

Removing "Abc" Placeholder Text

http://kb.tableau.com/articles/knowledgebase/removing-abc-placeholders




Sometimes the ABC from the right of the view annoying me.  Tableau Techinical Support sent me the workaround. There are actually two potential ways to get rid of the ABC from the right side of the view, I prefer to use the "Blank"
 
Create a calculated field
Create a calculation that will act as an invisible placeholder field.
 
Step 1 
 Create Calculated Field.
 
Step 2 
In the Create Calculated Field dialog box, type the following:
  1. Give the calculated field a name as Blank.
  2. In the Formula text box, type two quotation (" ") marks with a space in between the quotation marks.
  3. When finished, click OK.
Step 3 
Place the calculated field on the Text shelf, and place another instance of the calculated field in the Columns shelf.

http://kb.tableau.com/articles/knowledgebase/removing-abc-placeholders