turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Number of seris

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Nov 12, 2017 6:13 PM
(769 views)

Hi

During stacking, I want to make Number of Series a variable which sould be calculated before. It says, this should be a positive intege. Is there any workaround?

// Stack the data

Data Table( "Sample_data2" ) << Stack(

columns( ColList ),

Source Label Column( "Label" ),

Stacked Data Column( "Data" ),

Number of Series( j/12 ),

Contiguous

);

/*:

Number of series should be a positive integer

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Nov 12, 2017 7:16 PM
(1505 views)

Solution

You have to evaluate the equasion you are using for the setting of the numer of series

```
// Stack the data
Data Table( "Sample_data2" ) << Stack(
columns( ColList ),
Source Label Column( "Label" ),
Stacked Data Column( "Data" ),
Number of Series(eval( j/12 ) ),
Contiguous
);
```

The resulting value has to be an integer, which means your value of the variable "j" has to be, 12, 24, 36 etc

Jim

1 REPLY

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Nov 12, 2017 7:16 PM
(1506 views)

You have to evaluate the equasion you are using for the setting of the numer of series

```
// Stack the data
Data Table( "Sample_data2" ) << Stack(
columns( ColList ),
Source Label Column( "Label" ),
Stacked Data Column( "Data" ),
Number of Series(eval( j/12 ) ),
Contiguous
);
```

The resulting value has to be an integer, which means your value of the variable "j" has to be, 12, 24, 36 etc

Jim