2D Scatter Plot with pivot/category and Count for dotsize

  • 31 May 2022
  • 0 replies


I have 2 numerical dimensions which I want to plot as x and y, and a categorical dimension as pivot and count as dot-size. 

I have converted one dimension to a table calculation to make them as X and Y and it works. I’m also able to use grid layout to make multiple smaller plots for each category.

However when I try to make the same plot without any grid layout, I get an incompatible data error:

“Unable to chart pivoted data when dimension has repeated values. This commonly happens when you create a query with a second dimension and hide that dimension from the chart.”

What is the suggested solution here?

I have seen this plot in looker documentation which is exactly what I need. What should be the data format to make such plot work?


This topic has been closed for comments