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
- :
- How to normalize data in the same 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

Sep 19, 2016 9:14 PM
(1396 views)

1 ACCEPTED SOLUTION

Accepted Solutions

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

Sep 20, 2016 2:41 AM
(1787 views)

Solution

hi ajguerrero,

i am not sure i understand your question, next time post an example of the data (can be fake).

anyhow, try to use table summary, put the date in the grouping and ask for the sum of the numbers. this should give you the total of events per day.

ron

1 REPLY

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

Sep 20, 2016 2:41 AM
(1788 views)

hi ajguerrero,

i am not sure i understand your question, next time post an example of the data (can be fake).

anyhow, try to use table summary, put the date in the grouping and ask for the sum of the numbers. this should give you the total of events per day.

ron