topic Re: Make Vertical bar chart showing only Top 10 in Discussions

Make Vertical bar chart showing only Top 10

Benjamin_Fuerst — Sun, 11 Jun 2023 11:31:01 GMT

Hello JMP community,

I would like to have vertical graph like on the left side. This graph is based on a data set far bigger. See on the right.

Now I would only like to show the top 10 or top 5.

Does anybody have a good idea for that?

Ben

What I tried so far, somehow works but not as I would intend it to:

Generally that is possible by:

Limiting with a local data filter for x so that the graph on the right becomes more readable.

Since I use very dynamic filtering option I tediously have to readjust the x-filter every time I Change some other filterings.

I also tried using col rank and sorting by that. With this I can directly choose how many TOPs to select-->Cool. But this won't work if I adjust the filter with some other options because the rank column is ranking totally (even if I subgroup within the formula by an other attribute).

Re: Make Vertical bar chart showing only Top 10

yuichi_katsumur — Wed, 12 Apr 2023 00:06:16 GMT

Hello Ben,

How about Packed bar? Packed bar is slightly different what you want, but it is easier way to do.

Re: Make Vertical bar chart showing only Top 10

Benjamin_Fuerst — Tue, 11 Apr 2023 12:59:59 GMT

Hi Yuichi,

thanks for pointing out this option. I was not aware of the packed bar chart.

It is a kind of workaround, but as you mentioned, it is slightly different as I need it.

Still the other values appear as the secondary bars in gray (depending on the local data filter one has set).
But you can separate them via "Packed ordering" to the bottom and just readjust the y axis so their are not visible any more.

Thanks!