首页 > 解决方案 > Google Data Studio - 使 COUNT_DISTINCT 作用于整个数据而不是饼图中的特定类别

问题描述

标签: google-bigquerydata-visualizationpie-chartgoogle-data-studio

解决方案


Blend the data to itself, and set it up like this:

enter image description here

Then create the pie chart with this formula:

sum(distance)/userId

Here's the output:

enter image description here


推荐阅读