最近在写tableau页面,做饼图的时候数据库里面的数据是
两个字段并不能做成饼图
需要用sql清洗一遍
SELECT
'量' as `名字`,
CONCAT(part_dt,'-01') AS `时间`,
sum(sell_counts) AS `值`,
sum(sell_counts)/max(total_counts) AS `率`
FROM
DMR.DMR_IDS_TABLEAU_INDUSTRY_INSURANCE_RATIO
WHERE
manufacturer_cn='****'
GROUP BY part_dt
UNION ALL
SELECT
'总量' as `名字`,
CONCAT(part_dt,'-01') AS `时间`
max(total_counts)-sum(sell_counts) AS `值`,-- 为什么要用总量减去量。因为tableau里面的饼图是(量+总量)/量. 数据库里面的值是 量/总量。所以需要想减。
sum(sell_counts)/max(total_counts) AS `率`
FROM
DMR.DMR_IDS_TABLEAU_INDUSTRY_INSURANCE_RATIO
WHERE
manufacturer_cn='****'
GROUP BY part_dt
最后通过sql的到的数据
这样就可以得到做饼图的数据了