google-bigquery - Google Data Studio：显示单个值而不是总和

Question

我在大数据中写过这样的查询来显示平均会话。

select  dd, mm, SUM(total_sessions) AS Total_Sessions, AVG(sess_length_seconds) AS Average_Session_Duration from (
  SELECT dd, mm, user_pseudo_id, sess_id, MIN(min_time) sess_start, MAX(max_time) sess_end, COUNT(*) records, 
    MAX(sess_id) OVER(PARTITION BY user_pseudo_id) total_sessions,
    (ROUND((MAX(max_time)-MIN(min_time))/(1000*1000),1)) sess_length_seconds
  FROM (
    SELECT *, SUM(session_start) OVER(PARTITION BY user_pseudo_id ORDER BY min_time) sess_id
    FROM (
      SELECT *, IF(previous IS null OR (min_time-previous) > (20*60*1000*1000), 1, 0) session_start 
      FROM (
        SELECT *, LAG(max_time, 1) OVER(PARTITION BY user_pseudo_id ORDER BY max_time) previous
        FROM (SELECT  EXTRACT(MONTH FROM TIMESTAMP_MICROS(event_timestamp)) as mm, EXTRACT(DAY FROM TIMESTAMP_MICROS(event_timestamp)) as dd, user_pseudo_id, MIN(event_timestamp) AS min_time, MAX(event_timestamp) AS max_time
          FROM `alive-ios.analytics_160092165.events_201810*` 
          GROUP BY mm, dd, user_pseudo_id)
      )
    )
  )
  GROUP BY 1, 2,3, 4
  ORDER BY 1, 2 

)

GROUP BY dd, mm
ORDER BY dd, mm desc
LIMIT 10

问题出在数据工作室中，它只有“总和”或平均值等选项。结果，它总是显示组合结果，而不是显示单独的行。我该怎么做才能显示单独的行？

标签： google-bigquerygoogle-data-studio

Answer 1

在数据工作室中，您应该将其作为维度而不是指标包含在内。