Tips & Tricks: Tableau

 FUNCTIONS

• Transform TIME to Minutes (Example: 01:23 to 83)
    int(MID([Runtime], 1, 2)) * 60
  + int(MID([Runtime], FIND([Runtime],":") +1 , 2))

• Regular Expressions [02] always in brackets (!!)
  REGEXP_EXTRACT([Forces], '(pf|pf[0-9]h|Piano)')
  
• Path Function[03] Data prep
  node.start                   as LOCATION  (Long & Latitude!) 
  node.start + ' - ' node_end  as PATH_ID 
  1                            as PATH_ORDER
  UNION   
  node.end                     as LOCATION  (Long & Latitude!) 
  node.start + ' - ' node_end  as PATH_ID 
  2                            as PATH_ORDER

FORMATTING

[01] Using Tableau for your next PowerPoint Deck, The Vizioneer, December 9, 2013, URL: http://thevizioneer.blogspot.com/2013/12/using-tableau-for-your-next-powerpoint.html

[02] RegexOne, Learn Regular Expressions with simple, interactive exercises. URL: https://regexone.com/

[03] Taking Off with the Path Function, Sophie Sparkeson July 31, 2015 , URL: 
https://public.tableau.com/en-us/s/blog/2015/07/taking-path-function

[04]  Data + Science curated Tableau links, URL: http://www.tableaureferenceguide.com