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?