topic Entering a difference column in jmp tabulate in Discussions

Entering a difference column in jmp tabulate

vharibal — Fri, 27 Oct 2023 11:23:49 GMT

Hi,

In above graph I looking to add a 3 columns "Delta1, Delta2, Delta3" to the right which evaluates difference between values rxAnt 1,2,3 for Kestrel and rxAnt 1,2,3 for Owl resp i.e

Delta1 = -97 - (-98) = 1

Delta2 = -97 - (-98) = 1

Delta3 = -100 - (-100) = 0

Can we do this?

Re: Entering a difference column in jmp tabulate

jthi — Fri, 27 Oct 2023 11:31:32 GMT

Easiest option might be to create them first into the data table as formula or use Summary table instead of Tabulate. Col Min() and Col Max() are useful functions if you create them into your original data table (you could also use Transform column in tabulate but I think creating them into the data table is easier).

Re: Entering a difference column in jmp tabulate

vharibal — Sun, 29 Oct 2023 13:16:37 GMT

Hi,

Thank you the reply. It helps. I created the diff columns by creating data table from tabulate. It looks like this below:

Now I would like to color values >1 in columns ANT1, ANT2, ANT3 in green, <=1 in red.

I want it to be displayed in tabulate itself

How can I do this?

Thank you

Re: Entering a difference column in jmp tabulate

jthi — Sun, 29 Oct 2023 15:27:54 GMT

I don't think you can color the rows in Tabulate. You can make it into a data table and then color the rows there (it will look a bit different though), but in that case it might be better to just create Summary table and color that.

Few wish list items regarding color tabulate: ,

Edit: And here is one more

Re: Entering a difference column in jmp tabulate

Mandy_Chambers — Mon, 30 Oct 2023 14:18:18 GMT

Jarmo - Thank you for pointing them to the wish list. This has been an item for a while and we are hoping to take a bigger look at tabulate and add some of these features in the future. Your suggestions to color in the table or use Summary are also good options for right now.

- Mandy

Re: Entering a difference column in jmp tabulate

jthi — Mon, 30 Oct 2023 14:25:18 GMT

You most likely already internally do this, but collecting all similar ideas together might be a good idea (too bad we cannot do it in community, at least not yet?). I think even my idea fits this more or less (the difference part) but it might be written in a bit unclear way.