topic Re: Change Label for Missing in Tabluate in Discussions

Change Label for Missing in Tabluate

HansD — Fri, 09 Jun 2023 19:50:48 GMT

I'm using Tabulate with the 'include missing for grouping column' - I would like to change the label for the word Missing in the table

Re: Change Label for Missing in Tabluate

Thierry_S — Fri, 25 Jun 2021 14:36:24 GMT

Hi,
A quick workaround would be to save the Tabulate output as a table (Main Platform Menu: Red Triangle Top Left > Make Into a Table) and change the column header there. However, if you need to work with the output itself, you will need to look deep into the Tree Structure of the output to figure out if the Column labels can me edited (from a quick check, it does not seem to be editable but I'll leave other to comment)
Best,
TS

Re: Change Label for Missing in Tabluate

txnelson — Fri, 25 Jun 2021 16:53:25 GMT

The work around that I would do, is to replace the missing cells with the value you want to be displayed, thus changing the missing value to a specified value.

for each row(
     If(:sex ==  "", :sex = "my new group" 
);

Re: Change Label for Missing in Tabluate

HansD — Fri, 25 Jun 2021 19:12:13 GMT

Hi Jim,

Most probably the easiest solution - I hoped there was a feature in JMP I didn't see.

Thanks for your response

Hans

Re: Change Label for Missing in Tabluate

HansD — Fri, 25 Jun 2021 19:17:21 GMT

Hi Thierry,

Thanks for your response - your solution will give an solution. I would not like to take this route for this specific application

Hans