假设有“单击”表,其中包含用户的单击。现在我要选择每个社交网络的总点击量:
UPD: refererHost列包含任何参考主机,而不仅仅是社交网络主机。
SELECT
c.refererHost as referer,
COUNT(c.id) as clicks
FROM clicks c
WHERE c.referrerHost REGEXP 'facebook|google|linkedin'
GROUP BY referer
ORDER BY clicks desc
但是问题是,referer字段将包
当我使用格式函数时,默认情况下,值(12.1234)舍入为2个小数点(12.12)
下面是我的表达式
=Format(Fields!FEEPERUNIT.Value, "C") & " Rate Per Member "
它给了我$12.12 Rate Per Member
我希望我的数据像这样
My Data | Expected Data
12.1234 | $12.1234 Rate Per Member
45.6700 | $45.67 Rate Per Member
78.00 | $78 Rate Per Member
901.