Subscribe Bookmark RSS Feed

Can I divide the counts in graph builder?

ajguerrero

New Contributor

Joined:

Aug 1, 2016

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
txnelson

Super User

Joined:

Jun 22, 2012

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

12420_pastedImage_0.png

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

12421_pastedImage_1.png

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

12422_pastedImage_2.png

And then use it in the graph

12423_pastedImage_3.png

Jim