Bar chart after pivot- unexpected

Looker Q&A Looker
,
1

Hello, I have a look that is a bar chart, this look is supposed to show 3 values, lets call them A, B, and C, to get the results I want, I pivoted the data/results by value A, so now value C will have up to 3 different columns for values, when value C has at least 2 columns, the bar chart works the way I want it to work, but when value C only has 1 column, it doesnt work the same way anymore

so what is supposed to happen is, the y-axis should show value C, the x-axis should show value B, and the legend should be value A.

what i noticed happening was when value C only has 1 column in the results then the legend disappears and the y-axis name becomes value C while the actual values shown on the graph are of value C, but when value C has 2 or more columns, the legend comes back and everything goes back to normal.

2 Likes
2

Hi Ankit!

I created a similar test I got the same behavior.

I think you can customize the label name of this axis:

(For instance):

Hope it helps!

Best regards,

Leo

3

Hi Leo,

Thanks for giving time and answering my question. Actually in my chart, the y-axis should show value C, the x-axis should show value B, and the legend should be value A and if I rename it how will it work ? Could you please help me over here ?

Thanks and regards,

Ankit