我试图在BigQuery中创建一个生成计算字段的视图，并将其传递给DataStudio . 我使用以下SQL查询：

SELECT
    Rowdate AS Date,
    ProductName as Product,
    CustomerName as Customer,
    SUM(Revenue),
    SUM(Purchases),
    IEEE_DIVIDE(SUM(Revenue), SUM(Purchases)) as RevenuePerPurchase
  FROM
    `project.dataset.table`
  GROUP BY
    1,
    2,
    3

视图正确保存BigQuery，但Data Studio在字段中显示“无数据” . 我应该将此字段作为查询中的特定数据类型进行投射吗？

任何帮助非常感谢 .

谢谢

sql google-bigquery google-data-studio