topic Re: Problem with adjusting number of levels for group Y in graph builder in Discussions

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

ahartung — Wed, 19 Oct 2016 02:39:58 GMT

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!

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

Jeff_Perkinson — Fri, 28 Oct 2016 13:26:41 GMT

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.

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.
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.

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

ahartung — Tue, 17 May 2016 01:06:52 GMT

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!