Can I divide the counts in graph builder?

ajguerrero

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.

txnelson

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