ä¹ ã ã®æçš¿ã®ãããã©ã€ããªèšäºãæžããŸããã¿ãªãã倧奜ãã»ããã«ã€ããŠã®èšäºã§ãã
ã¡ãªã¿ã«Tableau 2020.2ã§Set Actionã®åŒ·åãå ¥ããŸããã
Tableauã®æ°æ©èœã«ã¯ãã€ãããããããã®ã§ãããçŸå®åé¡ãšããŠå®ã¯ãŸã 2018.3以åã®ããŒãžã§ã³ãã䜿ãã®æ¹ãããã£ãããã®ã§ã¯ãšæããŸãããTableau Serverã®ã¢ããã°ã¬ãŒãã£ãŠå€§å€ãããã§ããïŒäœæ¥ããèªäœããããŸãããã¢ããã°ã¬ãŒãæ¿èªãé¢ä¿åæãšã®èª¿æŽãªã©ïŒã
ãããã£ãŠãä»åã¯Set ActionsãèŠè¿ããŠã¿ãŠããããããã©ã¡ãŒã¿ã§äŒŒããããªããšã¯å®è£ åºæ¥ããªããšããã¢ã€ãã¢ãæžãçããŸãã
ä»åã®èšäºã«äœ¿çšããããã·ã¥ããŒãã¯ä»¥äžããããŠã³ããŒãã§ããŸãã
泚ææžãïŒä»åã®èšäºã®å 容ã¯ãæ©èœã ãèŠãã°Setã§å®è£ ããå¿ èŠã¯ãããŸããã
å 容ãèŠãã°åãããŸãããããŒãªã¢ã³ã®ãã£ã¡ã³ã·ã§ã³äœæ/䜿çšãšåçã§ãã
ãããŠSetã§å®è£ ããŠããçç±ã¯ãSet Action䜿çšå¯èœãªããŒãžã§ã³ã«ç§»è¡ããéã«ãSet Actionã®å®è£ ãç°¡åã«ããããã§ãã2018.3ã倢èŠãŸãããã
ã¯ããã«ïŒSetãšSet Actionã«ã€ããŠ
åºç€ããå ¥ããŸããSetãšã¯ãã£ã¡ã³ã·ã§ã³ããäœããããã®ãã£ã¡ã³ã·ã§ã³ã®å€ãäœããã®æ¡ä»¶ïŒéžæãŸãã¯èšç®åŒïŒã«åºã¥ããŠIN/OUTã«åé¡ãããã®ã§ãã
äžéšã®ã¿ããèŠããšãGeneral, Condition, TopããããããããŸãã
ãŸãGeneralã«ã€ããŠãããã§ã¯ãã£ã¡ã³ã·ã§ã³ã®é ç®ãéžæããããšãã§ããŸãã
次ã«Conditionã§ãããããã§ã¯æåéããSetã«å«ããæ¡ä»¶ããæå®ã§ããŸãã
èšç®åŒãå€ã®ç¯å²ãªã©ã䜿çšããæ¡ä»¶åŒãèšè¿°ããŸãã
æåŸã«Topã§ããããã¡ãã¯åºæ¬çã«ã¯éèšå€ã䜿çšãããããïŒã¯ãŒã¹ãNãåºããŸãã
Set Action / Set ControlãšSetã®é¢ä¿
ãšããã§2018.3ã®Set Actionããã³2020.2ã®Set Controlã¯ããã®ãéžæãã«å¯Ÿããæ©èœã§ããããã§ã¯è©³çŽ°ã¯å²æããŸãããèŠã¯ã€ã³ã¿ã©ã¯ãã£ãã«äœãSetã«å«ããããšãããéžæããåºæ¥ãæ©èœã§ãã
äžæ¹ã§ãäžèšã®Conditionã¿ãã«ãã©ã¡ãŒã¿ã䜿çšããæ¡ä»¶åŒãå ¥ããã°ãç°¡åã«ããã©ã¡ãŒã¿ã®éžæã«ããSetã«å«ãŸããé ç®ãæäœã§ãããã®ã§ã¯ãªããããšããã®ãä»åã®ã¢ã€ãã¢ã§ãã
å ·äœçã«ã¯ãããšãã°åäžéžæã®å Žåã¯ä»¥äžã®ãããªåœ¢ã§ãã
äŸãã°Categoryã®ã»ããã«ãããConditionã¿ãå ã§ãCategoryããäœæãããã©ã¡ãŒã¿ã䜿çšããæ¡ä»¶åŒãèšå®ããã°ããã®ã»ããã¯ãã©ã¡ãŒã¿ã§æå®ãããCategoryã®å€ã®ã¿INã«å«ããŸãã
ãããŠã»ããããäœã£ãŠããŸãã°ãããšã¯Set Actionã®äºäŸãåŒçšã§ããŸãã
詳ããäœãæ¹ã¯WorkbookãèŠãŠé ããšããŠã以äžã®ãããªæåã2018.3æªæºã®ããŒãžã§ã³ã§å®çŸå¯èœã§ãã
ã¡ãªã¿ã«è€æ°é ç®ãã»ããã«å ¥ãããå Žåã¯ãããå ¥åãç ©éã«ãªããŸãããREGEXP_MATCH()ã䜿çšããå®è£ ã«ãªãããªãšæããŸãã詳ããã¯æ£èŠè¡šçŸãåç §ãã ããã
ãã©ã¡ãŒã¿ã®å€ã®äŸïŒLabels|Storage|Art
ãªããæŽããŠ2018.3以éã䜿ããããã«ãªã£ãã®ã§ããã°ããã®ã»ããããConditionã®æ¡ä»¶ãå€ããé©åãªSet Actionãå®è£ ããã°OKã§ãã
ãšããã§/æåŸã«
ãããŸã§ã§ãæ°ã¥ãããšæããŸãããSet Actionãžã®ç§»è¡ãããã®èããç¡èŠããã°ãæ©èœçã«ã¯åã«By Formulaå ã®èšç®åŒãæžãããã£ã¡ã³ã·ã§ã³èšç®ãã£ãŒã«ããäœæããã°ãåäžã®ãã®ã¯å®è£ ã§ããŸãã
ãããã£ãŠã»ããã®å©çšãè¥å¹²ç ©éã§ããããããŸã§ããSet Actionã®äœ¿çšãèŠæ®ããéçºãã®ããã®ç¥èãšããŠãäºæ¿ãã ããã
ã質åçã¯TwitterãLinkedinãžãããããé¡ãããŸããããã§ã¯ã