ä»åã®ããŒãã¯ãRadial ChartãTableauã§äœããã§ãã
以äžã®VizäœæãéããŠè§£èª¬ããŸãã
以äžã®ããã°ãåèã«ããŸããã
䜿çšããTableauã¯ãŒã¯ããã¯ã¯ä»¥äžããããŠã³ããŒãã§ããŸãã䜿çšããŒã¿ã¯Sample Super Storeã§ãã
ãã¢ãããŒã·ã§ã³ã
身ãèããªãã§ãããåºæ¬çã«ã¯Radial ChartãããBar Chartã®æ¹ãè¯ããšãããŠããŸãïŒ
ã»æ²ç·ã®æ¯èŒã¯ããããé£ãã
ã»æ°åã®ã¹ã±ãŒã«æãã€ãã¿ã«ããïŒPie Chartã3ã€ä»¥äžã®æ¯èŒã«åããªãã®ãšåãïŒ
The Big Book of Dashboardsã§ãè«ããããŠããŸãããããã¡ãã®Blogèšäºãç°¡æœã«åé¡ç¹ã瀺ããŠããŸãã
äžæ¹ã§ã¡ãªããäŸã¯ä»¥äžããããããŸãïŒ
ã»ã¡ãã£ãšãã¡ã³ã·ãŒïŒåãããããã¯å€§äºã§ãããäžæ¹ã§Impressiveãã倧äºãªãšãããããŸãããïŒ
ã»äŸãã°æéã®ãããªãäžåšãããæ°å€ãçšããå Žåã«ã¯ããã®ãããªå¯èŠåã¯ãæ°åã®æã€ã€ã¡ãŒãžããšçŽã¥ãããããªããŸãã
ãŸãšãããšãBar Chartã¯ãæ°åã®æ¯èŒãã«åªäœããããŸãã
Radial Chartã¯ãèŠèŠçãªå°è±¡ããšãæ°å€ãšã€ã¡ãŒãžã®çŽã¥ããã«åªäœãããããšãã£ããšããã§ããããã
ãRadial Chartã®äœãæ¹ã
ããããæ²ç·ç³»ã®äŸã«æŒããããŸãã¯Self-Unionããã¯ãããŸãã
ãŸãã以äžã®èšç®ãã£ãŒã«ããçšæããŸãã
Measure
[Sales]
Dimension
[Sub-Category]
PATH
IIF([Table Name] = "Orders",1,[Bin Size])
ããã§[Bin Size]ã¯æŽæ°åã®Parameterã§ããäžæŠã¯270ã«èšå®ããŸãã
ãã®[Bin Size]ããäžçªé·ãBarã®çµç¹ã§ã®è§åºŠãæå®ããŸãïŒä»åã¯270°ïŒã
ãŸããPATHã§BinãäœæããŸãã
次ã«ã以äžã®èšç®åŒãäœæããŸãã
Max Value Within Dimension
WINDOW_MAX(SUM([Measure]))
Max Value within Path
WINDOW_MAX(SUM([Measure]))
ããã§ããããã«ã€ããŠãäžå³ã®ããã«è¡šèšç®ãèšå®ããŸãã
ïŒåãããããããã«æ瀺çã«è©³çŽ°ã¬ãã«ãèšç®ãããçŽããã£ã¡ã³ã·ã§ã³ãæå®ããŠããŸãããè¡šèšç®ã«æ £ããŠããæ¹ã¯ãã®èŸºãã¯é©åœã§å€§äžå€«ã§ãïŒ
Max Value Within Dimensionã«ã€ããŠãDimensionæ¯ã®SUM([Measure])ã®ãDimensionéã§ã®æ倧å€ãè¿ããŸããä»åã®ããŒã¿ã§ã¯ãDimensionã"Phone"ã®SUM([Measure])ãšãªããŸãïŒèŠã¯åBarã®é·ãã®æ倧å€ïŒã
Max Value within Pathã«ã€ããŠãããã¯åDimensionã«ãããSUM([Measure])ã®æ倧å€ãè¿ããŸãïŒèŠã¯åBarã®é·ãïŒã
éèŠãªã®ã¯PATH(bin)ã§WINDOW_MAX()ãå®è¡ãããããDimensionã§åèšç®ãããããšã«ãããããããã®Dimensionã®ã¢ã€ãã ã®SUM([Measure])ãåºåãããŠããããšã§ãã
次ã«ã以äžã®èšç®åŒãäœæããŸãã
Step Size
[Max Value within Path] / [Max Value Within Dimension]
RANK
RANK_UNIQUE([Max Value within Path],"asc") //Dimensionã䜿çšããŠèšç®
Step Sizeã¯ãçšã¯Dimensionã®åã¢ã€ãã ã«ã€ããŠã®ãæ倧ã®Baré·ãã«å¯Ÿãããåã¢ã€ãã ã®Baré·ãã®å²åã瀺ããŠããŸãã
ä»åã®å Žåã¯Phoneã®Step Sizeã¯ã100%ãã«ãªããFastenersã®Step Sizeã¯ã1%ããããã§ãã
RANKã«ã€ããŠã¯èšç®åŒéãã§ãã
æåŸã«ã以äžã®èšç®åŒãäœæããŸãã
INDEX
INDEX() - 1 //PATH(bin)ã䜿çšããŠèšç®
X
-COS([INDEX]*PI()/180*[Step Size] + RADIANS([Rotation]))*[RANK]
Y
SIN([INDEX]*PI()/180*[Step Size] + RADIANS([Rotation]))*[RANK]
ããã§Rotationã¯æŽæ°åã®Parameterã§ããRadial Chartã®å§ç¹ã®è§åºŠã決ããŸãã
æåŸã«ãäžå³ã®ããã«é 眮ããã°å®æã§ãã
ãã®ãšããPATH(bin)ã«ãæ¬ æå€ã衚瀺ããããããšãå¿ããªãã§ãã ããã
ã¡ãªã¿ã«ãRotationã0ãBin Sizeã180ã«ãããšä»¥äžã®ããã«ãªããŸãã
Radial Chartäœæã®å€§çã¯ä»¥äžã§ãã
ãè¿œèšïŒæ°å€ã«ããããŠBarã®é·ããå€ãããå Žåã
ããã¯MakeoverMonday 2019/W7ã®ãé¡ãªã®ã§ããã8æéã§360°ã6æéã§270°ã«ããŸããã
ãã®ã±ãŒã¹ã®ããã«ã360°ãäžããåºæºå€ãçšæããããå ŽåããããšæããŸãã
ã¡ãªã¿ã«Workbookã¯ãã¡ãããã
ãã®å Žåã«ã¯ã以äžã®ïŒã¹ããããèžã¿ãŸãã
ïŒïŒãã©ã¡ãŒã¿Bin Sizeã®å€ã360ã«èšå®ãã
ãããšã以äžã®ããã«ãªããŸããæ倧å€ã®Barãããã£ãš1é±ããŸãã
ïŒïŒãã©ã¡ãŒã¿ãMax of Barããäœæãã
ä»åã®å Žåã¯ä»¥äžã®ããã«èšå®ããŸãã8æéïŒ28,800ç§ïŒã§360°ãæ³å®ããŠããŸãã
äœæããVizã«åãããŠæ°å€ãä»»æã§èšå®ããŠãã ããã
ïŒïŒèšç®ãã£ãŒã«ããStep SizeããæŽæ°ãã
以äžã®ããã«æŽæ°ããŸãã
[Max Value within Path]/[Max Value Within Dimension]
*
([Max Value Within Dimension] / [Max of Bar])
è£æ£é ã§ãã [Max Value Within Dimension] / [Max of Bar] ãæããŸããã
ãã®åŒã®æå³ã¯
[Max Value Within Dimension]ã®å€ã§360°ãäžããããã«èšå®ããã®ã§
[Max Value Within Dimension]ã[Max of Bar]ã§å²ãããšã«ããã[Max of Bar]ã«å¯Ÿããå²åãèšç®ãã
ãã®å²åã«ããã360°ã«å¯ŸããŠäœåºŠã«ãªãã¹ããããã³ã³ãããŒã«ãã
ãšãã圢ã«ãªã£ãŠããŸãã
èšãæããã°ã床æ°ã®ã³ã³ãããŒã«ããã©ã¡ãŒã¿[Bin Size]ãã[Max Value Within Dimension] / [Max of Bar] ã«ç§»ãæ¿ãããã圢ã§ãã
ãæåŸã«ã
Radial Chartäœææ¹æ³ããããã§ãããã次åã¯Radial Bar Chartã®äœææ¹æ³ã«ã€ããŠãäºå®ããŠããŸãããã®æ¬¡ã¯Radial Stacked Bar Chartã§ãã
ã質åçã¯TwitterãLinkedinãžãããããé¡ãããŸãã