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

Showing results for

- JMP User Community
- :
- Discussions
- :
- how to make an auto-updating sample count column

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

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

Jan 7, 2016 6:39 AM
(968 views)

3 REPLIES

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

Jan 7, 2016 6:53 AM
(879 views)

This can be done using a formula column. Could you post some data so we could see it more clearly?

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

Jan 7, 2016 10:33 AM
(879 views)

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

Jan 8, 2016 10:46 AM
(879 views)

Create a formula column called Counter. Add this formula to it:

current_row = row**()**;

this_site = :Site**[**current_row**]**;

this_quarter = column**(**"Quarter (1-4)"**)[**current_row**]**;

this_counter = **1**;

for **(**i = **1**, i < current_row, i++,

one_site = :Site**[**i**]**;

one_quarter = column**(**"Quarter (1-4)"**)[**i**]**;

if **(**this_site == one_site & this_quarter == one_quarter,

this_counter++;

** )**;

**)**;

:Counter**[**current_row**]** = this_counter;