∞(無窮)騎樂(yuè)

上帝不響。如歌單車......
Never too late for a happy childhood (young at heart is so easy — pedaling a revolution from within)...

首頁文章列表博文目錄

個人資料

stillthere (熱門博主)

給我悄悄話

博客訪問：

小試 tableau

(2010-03-15 20:43:05) 下一個

今以微軟SQL Server 2005的AdventureWorks數據為源，試用 tableau大約十分鍾搞定下圖以示三年自行車不同生產線不同車架尺寸及不同顏色的定貨量、單元削價、例價（年總計）(把鼠標懸停在條圖上可顯示詳細數據）:
</p> </div> <script type="text/javascript"> function forumSelected() { var forumId = $("#forumId").val(); if(forumId == null || '' == forumId) { alert('請選擇論壇.'); } else { } } </script> <div id="postManageBar" class="post_manage_bar"> <div class="manage_option"> [ <a href="/blog/frontend.php?act=articlePrint&blogId=1547&date=201003&postId=19745" target="_blank">打印</a> ] </div> <div class="manage_option"> [ <a href="//www.wenxuecity.com/bookmark/script/add.php?title=%5B%E5%8D%9A%E5%AE%A2%5Dstillthere%3A%E5%B0%8F%E8%AF%95%20tableau&link=http%3A%2F%2Fzh.wenxuecity.com%2Fblog%2Ffrontend.php%3Fact%3Darticle%26blogId%3D1547%26date%3D201003%26postId%3D19745&category=blog&itemType=201003&itemID=19745" target="_blank">加入書簽</a> ] </div> <style> #wechatshare{background:#000;position:fixed;z-index:0;width:100%;height:100%;left:0;top:0;filter:alpha(opacity=60);-moz-opacity:0.6;opacity:0.6} #panelbox{position:relative;text-align:center;background:#fff;width:580px;height:320px;padding-top:40px;left:35%;top:25%;position:fixed;z-index:2;border-radius:15px} #panelbox h3{font-size:15px;color:#44753c} #panelbox h3 img{width:21px;vertical-align:middle;padding:0 3px} #panelbox center{padding-top:10px} #panelbox center img{width:200px} </style> <script type="text/javascript"> function showQRCode(imgurl){ if(!document.getElementById('qrbox')){ var layer = document.createElement("DIV"); layer.id="qrbox"; var html=""; html+='<div id="wechatshare" onclick="hideQRCode();">'; html+='</div>'; html+='<div id="panelbox">'; html+=' <h3>打開微信<img src="/news/images/icon_qrcode.gif" />掃一掃[Scan QR Code]，打開網頁後點擊屏幕右上角分享按鈕</h3>'; html+=' <center><img alt="右鍵另存為下載到本地" src="'+imgurl+'"></center>'; html+='</div>'; layer.innerHTML = html; var body = document.getElementById("wxc_blog").parentNode; body.appendChild(layer); }else{ $("#qrbox").css("display","inline"); } } function hideQRCode(){ $("#qrbox").css("display","none"); } </script> <div class="manage_option"> <a target="_self" href="#" onclick="showQRCode('https://api.qrserver.com/v1/create-qr-code/?size=200x200&data=https%3A%2F%2Fm.wenxuecity.com%2Fmyblog%2F1547%2F201003%2F19745.html%3Famp%3D1');return false;"><img src="/news/images/btn_sharewechat.gif" style="width:auto;height:auto"></a> </div> </div> <div class="tagMore"> <div class="tag BLK_txtc"> <a id="" target="_blank" href="/myblog/1547/201003/19745.html"> 閱讀 </a> <em>(<script language="JavaScript" type="text/javascript" src="//count.wenxuecity.com/service/count/script/do.php?clear=1&type=1547&id=19745&refresh=true"></script>)</em> ┆ <a id="" href="/myblog/1547/201003/19745.html?#comments" target="_blank">評論</a> </div> </div>  <div id="comments" class="comments"> <div class="commentsTitle"> <div class="commentsLabel"> <strong>評論</strong> </div> </div> <div class="non-comments">目前還沒有任何評論</div>    <div id="addComment" class="addComment"> <div class="non-comments"> <a href="">登錄</a>後才可評論. </div> </div>   </div>  </div> <div class="BLK_containerFoot"></div> </div> </div> </div> </div>  <img src="//pixel.wenxuecity.com/images/pixel.gif?refe=none" style="display: none" height="1" width="1"/> </div>    </body> </html>