JMP User Community

Latest Discussions

How to unlock Multiple Columns?

I know many of you may be dealing with big dataset with 100s of millions of rows and hundred columns. One cool feature that I just tried to see if it worked is to how to quickly unlock multiple columns without having to click the title of each column and then selecting column info for each variable you want to unlock. You can do this by either or script or by highlighting the all the selected colu...
jenkins_macedo

Discussions |
Aug 14, 2015 5:23 AM

13609 views | 1 replies
How to collect all data tables in a new window

I have a script that extracts data from a database and returns a randum number of tables. I'd like to have all tables gathered in one window where a user can scroll down to see tables instead of having the tables behind each other. I have tried an approach where i make the calls to the database and afterwards make a new window and loop through all tabels and append them to the window (see below) b...
hans

Discussions |
Aug 14, 2015 5:00 AM

8980 views | 2 replies
Transposing a Data Table

The data in this question are fictitious.I have a data table in the form of:Campaign CodePrograms# Confirmed Enrollments# First Time Enrollments$ Confirmed Enrollments$ Program Only$ Total Enrollment Amt$ Total Net Order ZZ10AF012,0002,0002,0002,000ZZ10DOM103,5003,5003,5003,500ZZ10INTL2210,00010,00010,00010,000YY15AF11250250250250YY15DOM11300300300300YY15INTL2110,00010,00010,00010,000AC10AF1110001...
jenkins_macedo

Discussions |
Aug 12, 2015 3:54 PM

9864 views | 3 replies
How to use the SQL LIKE ANY command?

Hi all.I am trying to use the input from a text box to have a SQL query that uses the LIKE command, but with multiple entries.Getting the list out of the text box is easy, the problem comes when I try a SQL query with LIKE and a list.id = {"R8D-304%","R8D-404%","R8D-515%"};Select WHERE Serial LIKE ANY (????)This is where I have problems. I've used the Concait Items when searching for a list of ex...
rleeper

Discussions |
Aug 12, 2015 5:40 AM

9658 views | 3 replies
How to remove title from Variability chart ?

Hello all,I want to remove the title coming in my variability chart "Variability Chart for CD-Value" automatically for the purpose of printing.How can i proceed to it?Please guide me. Thanks in advance.
kaushik_pushpen

Discussions |
Aug 11, 2015 5:33 AM

12739 views | 7 replies

Previous
Next

Latest Discussions

How to remove title from Variability chart ?

Hello all,I want to remove the title coming in my variability chart "Variability Chart for CD-Value" automatically for the purpose of printing.How can i proceed to it?Please guide me. Thanks in advance.
kaushik_pushpen

Discussions |
Aug 11, 2015 5:33 AM

12739 views | 7 replies
How can I retrieve a script from an already existing graph

Hello,I've been searching every where, I cannot seem to find a solution to my problem.The user opens a datatable and creates all the graphes he needs and the idea is to be able to write a script that will save the picture of each graph individually in a folder on my computer.I had difficulties first finding a way to select each graph one after another (but that seems possible by saving all the gra...
bellesabi

Discussions |
Aug 10, 2015 10:20 AM

7732 views | 5 replies
Map background image

Hi,Starting from a blueprint image (building or site) and using the map creator addins, I'm able to create the boundaries for the buildings or rooms I want to use.Once I use it with my data, I'm only getting the boundaries, not the background image that I started from.I do I manage to save the background image with the boundaries??Thanks!Agnès
agneshb

Discussions |
Aug 7, 2015 5:41 AM

7260 views | 3 replies
subscripted key not in map{1} in access or evaluation of 'key' , key

Hi! i am using JMP to access SAS on demand for soem path analysis. once i hit run it gives me this message: how can i fix this?subscripted key not in map{1} in access or evaluation of 'key' , keyThank you!
soheila

Discussions |
Aug 1, 2015 10:53 AM

3329 views | 1 replies
How can I remove one data series from overlay plot?

I plot 3 data series in one overlay plot; now I want to remove one of them directly from the plot. (not from the script)in graph builder, when you right click on the graph under "line" option you can remove any "Y"; but in overlay plot I cannot find similar thing.p.s: I have hundreds of Overlay plots and it's nearly impossible to change all of them to graph builder!Any suggestion? Thanks
razmah

Discussions |
Jul 30, 2015 12:43 PM

4897 views | 2 replies

Previous
Next

Latest Discussions

Incorporating Reference Lines into legend for multiple bivariate graphs.

Hello everyone!I would like assistance in order to incorporate reference lines at certain numbers of the Y axis, horizontal lines, directly into the legend.This is my current script
Bivariate(
Y( :Cat),
X( :Dog),
Histogram Borders( 1 ),

Where(:Recipe == "B_XX" & (:Tool == "A_XX")),
Elements( Points( X, Legend( 1 ) ) ),
SendToReport(Dispatch(
{},
"2",
ScaleBox,
{Add Ref Line( 140, Solid, "...
saswatmishra50

Discussions |
Jul 13, 2015 1:00 PM

3280 views | 0 replies
Fit Y by X plot discrepancy (Oneway vs Bivariate)

Hi, I see a discrepancy in the plotted Y variables when plotting similar columns in the Oneway vs Bivariate plots. Bivariate plots the Y values correctly (left side below). Oneway seems to jitter the points on the Y-axis, which seems strange to me. I realize that my horizontal axis here is a numeric, and that bivariate makes more sense* but I'm just looking for a simple x-y scatter and I like the ...
mikedriscoll

Discussions |
Jul 10, 2015 9:04 AM

4233 views | 0 replies
how to invisible local data filter

Hi all,Till now I was using "Panel Box" and "Close" local data filter command for the invisible but functioning local data filter. Something like below closes the data filter it is visible by jmp graph but invisible by the HTML5 output (magical).nw[Panel Box( 1 )][Outline Box( "Local Data Filter" )] << Close( 1 );nw[Panel Box( 2 )][Outline Box( "Local Data Filter" )] << Close( 1 );
This time I use ...
saitcopuroglu

Discussions |
Jun 9, 2015 7:00 AM

2948 views | 0 replies
Fit Y by X Interactive HTML5 output

I don't know if anybody using the Interactive HTML output as intensive as me but Fit Y by X platform needs an upgrade about converting the jmp language to HTML5 language. Here is an example comparing the outputs of both. Almost none of the axis and font and colour settings seem to be carried over.
saitcopuroglu

Discussions |
May 22, 2015 3:14 AM

2568 views | 0 replies
PowerPoint Export of Journal

Is there a way to control the formatting of the exported PowerPoint deck? The exported file needs so much clean up I am not sure if it saves any time over cutting and pasting. I made a simple journal from the big class data table and a 1 page journal turns into a 5 page PowerPoint. The resulting PowerPoint is attached.
Hegedus

Discussions |
Apr 7, 2015 4:03 PM

10440 views | 0 replies