How to create bins for bar chart in Explore UI?

[ginandtobby]

Hi Community!

I want to draw bar chart and bin a numerical column over x-axis. Is there any fast way to do this or the bins must be configured in lookml first? 

Thanks.

[GavinW]

If you go to the field picker on the left and click on the three dot menu for the filed you are interested in, you can create bins in the front end without needing to create them in LookML:

You will open a modal that allows you to configure the bin as below:

[ginandtobby]

Thanks @GavinW for your reply. What if the field that I want to create bins with is a measure, not a dimension? It will involve a 2-step calculation. Can it be done dynamically in Explore UI?

[GavinW]

Can you give an example of what that would look like, or why you would do that, so that I can get a better understanding?

If you mean that you want the bin assignment to become a standalone dimension it would indeed be a 2-step process to turn a measure into a dimension.

[ginandtobby]

Yes, that's what I meant. So, this step (bin assignment as a standalone dimension) must be done in lookml level in advance right?

[GavinW · Accepted solution]

Yes, you are correct.