Subscribe Bookmark RSS Feed

Problem with adjusting number of levels for group Y in graph builder

ahartung

Community Trekker

Joined:

May 16, 2016

I have a problem with adjusting number of levels for group Y in graph builder. I have 70 levels and would like to display all of them in the y group on the right side. I choose to show all levels and "number of levels" as 7 because I would like it to display it in sets of 10 (1-10, 11-20, 21-30, etc. up to 61-70) It always gives me some odd arrangement of the levels: 1-9, 9-18, 18-26, 26-32, 32-39, 39-45, 45-70. I would need this in a symmetrical arrangement. How can I achieve this? Thank you!

11565_pastedImage_1.png

2 REPLIES
Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

The Graph Builder X and Y Group levels for a continuous column are based on quantiles to get an even distribution of rows in each group.

If you want to define the groups yourself, you've got a couple of options.

  1. You can create a column that defines the groups. You can use the Formula Editor and an If conditional to define them. Or you can download the Interactive Binning​ add-in and use that to create the column for you.
  2. You can change the Modeling Type of the column to Nominal or Ordinal and then use a Value Label property with ranges to define the groups.

There are probably some other ways to tackle this too, but maybe this will get you started.

-Jeff
ahartung

Community Trekker

Joined:

May 16, 2016

Thank you, Jeff. I made a new column with the labels and displayed this column instead. It shows now what I wanted to see!

Thanks a lot!