雷達(dá)圖分析三國超一流謀士、統(tǒng)帥數(shù)據(jù)，獻(xiàn)給廣大的三國愛好者們，希望喜歡三國的朋友一起討論，加深對傳奇三國時代的了解

建立數(shù)據(jù)環(huán)境：

-- 抽取三國超一流謀士TOP 10數(shù)據(jù)DECLARE @t1 TABLE    (      [姓名] NVARCHAR(255) ,      [統(tǒng)率] FLOAT ,      [武力] FLOAT ,      [智力] FLOAT ,      [政治] FLOAT ,      [魅力] FLOAT    )            INSERT  INTO @t1        SELECT TOP 10                [姓名] ,                [統(tǒng)率] ,                [武力] ,                [智力] ,                [政治] ,                [魅力]        FROM    FactSanguo11        WHERE   ( [智力] + [政治] > 160 )                AND ( [智力] >= 90 )                AND 姓名 <> N'曹操'        ORDER BY [智力] + [政治] DESCSELECT  *FROM    @t1 -- 列轉(zhuǎn)行處理SELECT  [姓名] ,        [指標(biāo)項(xiàng)] = attribute ,        [指標(biāo)值] = valueFROM    @t1 UNPIVOT  ( value FOR attribute IN ( [統(tǒng)率], [武力], [智力], [政治], [魅力] ) ) AS UPV

執(zhí)行結(jié)果：

-- 抽取三國超一流統(tǒng)帥TOP 10數(shù)據(jù)DECLARE @t2 TABLE    (      [姓名] NVARCHAR(255) ,      [統(tǒng)率] FLOAT ,      [武力] FLOAT ,      [智力] FLOAT ,      [政治] FLOAT ,      [魅力] FLOAT    )    INSERT  INTO @t2        SELECT TOP 10                [姓名] ,                [統(tǒng)率] ,                [武力] ,                [智力] ,                [政治] ,                [魅力]        FROM    FactSanguo11        WHERE   [統(tǒng)率] + [武力] > 150        ORDER BY [統(tǒng)率] + [武力] DESCSELECT  *FROM    @t2 -- 列轉(zhuǎn)行處理SELECT  [姓名] ,        [指標(biāo)項(xiàng)] = attribute ,        [指標(biāo)值] = valueFROM    @t2 UNPIVOT  ( value FOR attribute IN ( [統(tǒng)率], [武力], [智力], [政治], [魅力] ) ) AS UPV

執(zhí)行結(jié)果：三國超一流謀士、統(tǒng)帥配圖：雷達(dá)圖分析三國超一流謀士、統(tǒng)帥數(shù)據(jù)（最終客戶端效果）：