cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Find courses, tutorials, and lots of other methods of learning JMP.

view all learning resources

Latest Discussions

  • Saved Log vs. Viewed Log Contain Different Content

    I have a table that I've manually edited extensively and am looking to save the script for so I can automate in the future. I've written the following script (intended to be pasted into data table or allow user to run independently), which works, but I have to copy & paste into a text file to save: dt = Current Data Table(); If( Is Empty ( dt ), Try( dt = Open(), Throw("No data table found")) )...

    amurphy amurphy
    Discussions |
    Jun 18, 2021 6:52 AM
    1316 views | 2 replies

  • Refresh a JMP data table that had been previously populated with data imported from a .csv file

    Hello JMP community, I need some help with refreshing of a JMP data table that was previously populated using the File -> Open -> Text File import option, in this case a .csv file. The first time, the data got imported with no issues, I then added a couple of column formulas at the end and done some graphs using the Graph Builder, which I saved the script to the data table and the file as normal. ...

    VCO VCO
    Discussions |
    Jun 18, 2021 6:24 AM
    2553 views | 2 replies

  • time zone question

    Hello, I have data in the UTC time format. Can someone tell me how to convert this data to my local time (Pacific Standard Time)? Thanks   

    domenowe domenowe
    Discussions |
    Jun 18, 2021 5:18 AM
    1108 views | 1 replies

  • How do I transpose multiple delimited columns

    Hi,I'm trying to split and transpose multiple pipe delimited columns and would appreciate some help in finding the most efficient way of doing this.The table contains measurement values at X,Y location for a measurement type.The number of measurements and X,Y locations can vary for each batch and date. Example data and required output shown below. Start tableBatchDateTypeXYValueA101/06/2021L0 | 0 ...

    anna_717 anna_717
    Discussions |
    Jun 18, 2021 2:29 AM
    1780 views | 2 replies

  • SQL command limit in query builder?

    In normal SQL, I can limit the number of returned results using the function LIMIT. Is there a similar function in the Query Builder available?When querying large data bases, it would be nice if I could limit the number of results to avoid overloading JMP when selecting the filters unwisely.

    Feli Feli
    Discussions |
    Jun 17, 2021 10:47 PM
    1984 views | 2 replies

Latest Discussions

  • Refresh a JMP data table that had been previously populated with data imported from a .csv file

    Hello JMP community, I need some help with refreshing of a JMP data table that was previously populated using the File -> Open -> Text File import option, in this case a .csv file. The first time, the data got imported with no issues, I then added a couple of column formulas at the end and done some graphs using the Graph Builder, which I saved the script to the data table and the file as normal. ...

    VCO VCO
    Discussions |
    Jun 18, 2021 6:24 AM
    2553 views | 2 replies

  • time zone question

    Hello, I have data in the UTC time format. Can someone tell me how to convert this data to my local time (Pacific Standard Time)? Thanks   

    domenowe domenowe
    Discussions |
    Jun 18, 2021 5:18 AM
    1108 views | 1 replies

  • SQL command limit in query builder?

    In normal SQL, I can limit the number of returned results using the function LIMIT. Is there a similar function in the Query Builder available?When querying large data bases, it would be nice if I could limit the number of results to avoid overloading JMP when selecting the filters unwisely.

    Feli Feli
    Discussions |
    Jun 17, 2021 10:47 PM
    1984 views | 2 replies

  • Overlay a graph onto another graph

    Folks, What are the ways (or best way) to overlay another graph onto another as shown in first attachment? Final objective is to generate multiple plots, arrange them in a window that is saved as a table property. This table property is then run so the final composite picture is able to be copied and pasted to Powerpoint. The script I have so far almost gets me there (see attached script and 2nd a...

    NRW NRW
    Discussions |
    Jun 17, 2021 7:19 PM
    3002 views | 4 replies

  • ODBC Hive connection, change container size in the script?

    Wondering if anyone can help here. I am trying to write some JMP scripts that SQL query data from a hive table. I need to change the container size and am told that I should just "do it in the connection settings". I was told that in python, you just add a configuration={"hive.tez.container.size":'10240'} parameter to the hive.connect call. How would I do this through JMP? I already have the Cloud...

    aliegner1 aliegner1
    Discussions |
    Jun 17, 2021 3:43 PM
    974 views | 0 replies

Latest Discussions

  • ODBC Hive connection, change container size in the script?

    Wondering if anyone can help here. I am trying to write some JMP scripts that SQL query data from a hive table. I need to change the container size and am told that I should just "do it in the connection settings". I was told that in python, you just add a configuration={"hive.tez.container.size":'10240'} parameter to the hive.connect call. How would I do this through JMP? I already have the Cloud...

    aliegner1 aliegner1
    Discussions |
    Jun 17, 2021 3:43 PM
    974 views | 0 replies

  • Using a List to Filter in Custom Query Builder - Question

    Hello, I would like to use a list to filter within a continuous column in Query Builder. Range and then join does not work as my data set from my database will be tens of millions of lines, so I would like my list to be the only thing queried. I would like to use a list (I have a separate data sheet with the column) of about 40 or so unique numerical values and use that in the filter for a custom ...

    Benjamin_S Benjamin_S
    Discussions |
    Jun 3, 2021 7:59 AM
    1278 views | 0 replies

  • Can I control text size in a word cloud inside a dashboard container?

    Hi all,I have a dashboard with a data filter, a map, and a word cloud that looks like image 1 below. I have two formatting issues with the word cloud I'd like to fix. First, by design, when I make different selections using the data filter, the subset of records that are shown in the map changes and the word cloud applies only to that selection. However, when I change the data filter selection, th...

    caseylott caseylott
    Discussions |
    Apr 28, 2021 12:03 PM
    1265 views | 0 replies

  • 多重比較での生存曲線の書き方　Bonferroniなど

    4群での生存曲線をJMPproでの書き方を教えて下さい。 また、JMPで「環境設定グループ」から「レポート」を選択し、「ローカルデータフィルター」を出せればできる方法も紹介されていたのですが、「ローカルデータフィルター」を出せません。 どの方法でもよいので、JMPProで、多重比較法を用いた生存曲線の書き方をどなたか教えてください！宜しくお願い致します。

    27070 27070
    Discussions |
    Apr 20, 2021 1:41 AM
    2275 views | 0 replies

  • Fantasy Baseball League

    I am in a 16 team fantasy baseball league. Each week we tabulate totals for home runs, batting average, stolen bases, wins, saves, era, etc. If my team has the most home runs, I win that category for the week. We track 10 statistics so after each week I may have a final score of 6-3-1. My question is how can I use JMP to check what my score would have been if I had played each of the other 14 team...

    atlas100 atlas100
    Discussions |
    Apr 19, 2021 1:29 PM
    969 views | 0 replies
view all discussions

JMP Events

view all events
Latest Blog Post

Unlock dynamic data stories: Tips for publishing on JMP Public

 view all blog articles

Learn more about JMP's premier analytics conference