I have single view with 10 columns . When I try to make a visualization by taking one string( category) and number(SalesValue) columns, looker is not summarizing data. Its pulling all the records as a table with duplicate category values and same is appearing in visual.
Ideally. If I have 5 categoires, the visual also should show 5 columns with respective sales value.
Thanks in Advance