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
- :
- Can I divide the counts in graph builder?

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

Aug 12, 2016 4:14 PM
(1125 views)

I have data that spans over 2 fiscal years. When I use graph builder to see particular subsets of data, the counts given are obviously over that 2 year period. What I'm interested in for my current project isn't the total over the 2 years, but the counts per day. So essentially I just need to take the response axis and divide all of the counts by 365*2. Can you recommend the easiest way to go about this? Thanks in advance.

1 REPLY

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

Just create a column in Graph Builder that is your target column divided by 2*365. To do this, just Right Click on the column of interest and select Formula

A formula window will open up, and just create the required formula

Then click on OK and go back to the Graph Builder window, Right Click on the newly created column and rename it to whatever you want it to be

And then use it in the graph

Jim