在Reporting /Reporting中的百分比

Question

报表查看器控件中有一个图表：

​

系列数据是一项总和：

​

问题如何使赎回轴成一个百分比？上午5点占当天总赎回额的45%。

Answer 1

在没有看到您的数据的情况下，我猜您可能需要对每一天的Redemtpions进行汇总，然后将其加入到每个时间段中。

因此，在不了解您的数据或任何东西的情况下，下面是一个示例：

 ;with dayavg as
(
    select day, count(*) as NumberRedemptionsDay
    from dbo.Redepmtions
    group by day
),
houravg as
(
    select day, hour, count(*) as NumberRedeptionsHour
    from dbo.Redemptions
    group by day, hour
)
select
    houravg.hour,
    houravg.NumberRedeptionsHour,
    (houravg.NumberRedeptionsHour/NumberRedemptionsDay)*100 as Perc
from houravg
    inner join dayavg
        on houravg.day=dayavg.day